/// <summary> /// تعداد افرادی که در محاسبات به خطا خورده اند را بر می گرداند /// </summary> /// <returns>تعداد</returns> public int GetErrorCountInCalculating() { try { int errorCount = 0; errorCount = gtsEngineWS.GTS_GETTotalErrorExecuting(BUser.CurrentUser.UserName); if (SessionHelper.GetSessionValue(SessionHelper.PersonIsFailedForCalculate) != null) { errorCount += Convert.ToInt32(SessionHelper.GetSessionValue(SessionHelper.PersonIsFailedForCalculate)); } return(errorCount); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BEngineCalculator", "GetErrorCountInCalculating"); throw ex; } }
public List <string> SaveEventMessageTrans(EventMessageTransSave data) { try { DataTable dtEventMessageTrans = CollectionHelper.ConvertTo(data.EventTransData, ""); //Remove column which is not required in Table Type dtEventMessageTrans.Columns.Remove("SNo"); dtEventMessageTrans.Columns.Remove("SubProcessName"); dtEventMessageTrans.Columns.Remove("MessageType"); dtEventMessageTrans.Columns.Remove("Origin"); dtEventMessageTrans.Columns.Remove("Destination"); List <string> ErrorMessage = new List <string>(); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter[] param = { new SqlParameter("@AirlineSNo", data.AirlineSNo), new SqlParameter("@UpdatedBy", data.UserSNo), new SqlParameter("@tt", dtEventMessageTrans) }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "spEventMessageTrans_Create", param); if (ret > 0) { if (ret > 1000) { string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "EventMessageTrans"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); } catch (Exception ex)//(Exception ex) { throw ex; } }
private void Frm_Report_Checkout_Load(object sender, EventArgs e) { bo = this.swapdata["BusinessObject"] as BaseBusiness; dateEdit2.EditValue = DateTime.Today; dateEdit1.EditValue = DateTime.Today.AddMonths(-1); ac007Adapter.Fill(dt_ac007_source); DataRow newrow = dt_ac007_source.NewRow(); newrow["ST001"] = "%"; newrow["ST003"] = "全部"; dt_ac007_source.Rows.Add(newrow); lookUp_ac007.Properties.DataSource = dt_ac007_source; lookUp_ac007.Properties.DisplayMember = "ST003"; lookUp_ac007.Properties.ValueMember = "ST001"; lookUp_ac007.EditValue = "%"; }
public List <string> UpdateCheckListType(List <CheckListType> CheckListType) { try { DataTable dtCreateCheckListType = CollectionHelper.ConvertTo(CheckListType, "ISIATA,ISSAS,SPHCGroupName,AirportName,CopyFrom,Text_CopyFrom,AirlineName,Text_AirportName,Text_AirlineName,Text_SPHCGroupName,Text_SPHCCode,Text_For,Text_SHC,Text_Type,Text_SPHCSubGroupSNo"); List <string> ErrorMessage = new List <string>(); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter param = new SqlParameter(); param.ParameterName = "@CheckListTypeTable"; param.SqlDbType = System.Data.SqlDbType.Structured; param.Value = dtCreateCheckListType; SqlParameter[] Parameters = { param }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "CheckListTypeUpdate", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "CheckListType"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); } catch (Exception ex)// { throw ex; } }
public List <string> SaveSkillMaster(List <SkillMaster> SkillMaster) { //validate Business Rule List <string> ErrorMessage = new List <string>(); DataTable dtCreateSkillMaster = CollectionHelper.ConvertTo(SkillMaster, "Active"); BaseBusiness baseBusiness = new BaseBusiness(); if (!baseBusiness.ValidateBaseBusiness("SkillMaster", dtCreateSkillMaster, "SAVE")) { ErrorMessage = baseBusiness.ErrorMessage; return(ErrorMessage); } SqlParameter param = new SqlParameter(); param.ParameterName = "@SkillMasterTable"; param.SqlDbType = System.Data.SqlDbType.Structured; param.Value = dtCreateSkillMaster; SqlParameter[] Parameters = { param }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "CreateSkillMaster", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "SkillMaster"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); }
public string GetIrregularityHistory(int CurrentComplaintSNo) { try { BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter[] param = { new SqlParameter("@ComplaintSNo", CurrentComplaintSNo) }; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetComplaintIrregulartityRecord", param); ds.Dispose(); return(CargoFlash.Cargo.Business.Common.CompleteDStoJSON(ds)); } catch (Exception ex)//(Exception ex) { throw ex; } }
public List <string> SaveAllotment(List <Allotment> Allotment) { List <string> ErrorMessage = new List <string>(); DataTable dtCreateAllotment = CollectionHelper.ConvertTo(Allotment, "Text_AircraftSNo,Sector,TotalGross,TotalVolume,ReserveGross,ReserveVolume,TotalGrossUnit,TotalVolumeUnit,ReserveGrossUnit,ReserveVolumeUnit,Text_OriginSNo,Text_DestinationSNo,AllotmentCode,Text_AllotmentType,Text_OfficeSNo,Text_AccountSNo,Text_GrossWeightType,Text_VolumeWeightType,Text_CommodityType,UpdatedBy,Text_Days,Text_ProductSNo,Text_Commodity,Text_FlightNo,Text_ShipperAccountSNo,Text_ProductType,Active,Mandatory,Text_FlightNo,Text_SHC,Text_SHCType,FlightValidFrom,FlightValidTo,IsUsed,FlightDaysOfOps,Text_AirlineSNo,AllotmentReleaseTimeMin,AllotmentReleaseTimeHr"); BaseBusiness baseBusiness = new BaseBusiness(); if (!baseBusiness.ValidateBaseBusiness("Allotment", dtCreateAllotment, "SAVE")) { ErrorMessage = baseBusiness.ErrorMessage; return(ErrorMessage); } SqlParameter param = new SqlParameter(); param.ParameterName = "@AllotmentTable"; param.SqlDbType = System.Data.SqlDbType.Structured; param.Value = dtCreateAllotment; SqlParameter[] Parameters = { param }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "spAllotment_Create", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "Allotment"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); }
public int GetSearchCount(PersonAdvanceSearchProxy proxy, int year, int month) { try { int rangeOrder = month; ISearchPerson searchTool = new BPerson(); IList <Person> personList = searchTool.GetPersonInAdvanceSearch(proxy); var ids = from o in personList select o.ID; IList <decimal> personIds = archiveRep.GetExsitsArchivePersons(ids.ToList(), year, rangeOrder); return(personIds.Count); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex); throw ex; } }
/// <summary> /// نمای گرافیکی گزارش کارکرد ماهیانه کاربر جاری را برمی گرداند /// </summary> /// <param name="year">سال</param> /// <param name="month">ماه</param> /// <param name="fromDate">تاریخ ابتدا</param> /// <param name="toDate">تاریخ انتها</param> /// <returns>لیست سطرهای گزارش کارکرد</returns> public IList <PersonalMonthlyReportRow> GetPersonGanttChart(int year, int month, string fromDate, string toDate) { IList <PersonalMonthlyReportRow> DailyRows = new List <PersonalMonthlyReportRow>(); try { if (Utility.IsEmpty(fromDate) || Utility.IsEmpty(toDate)) { throw new InvalidDatabaseStateException(UIFatalExceptionIdentifiers.PersonDateRangeIsNotDefiend, String.Format("برای شخص {0} رینج محاسبات تعریف نشده است", workingPersonId), ExceptionSrc); } if (IsValidPeson()) { DateTime from, to; if (sysLanguageResource == LanguagesName.Parsi) { from = Utility.ToMildiDate(fromDate); to = Utility.ToMildiDate(toDate); } else { from = Utility.ToMildiDateTime(fromDate); to = Utility.ToMildiDateTime(toDate); } gtsEngineWS.GTS_ExecuteByPersonID(BUser.CurrentUser.UserName, this.workingPersonId); PersonalMonthlyReport Result = new PersonalMonthlyReport(this.workingPersonId, from, to); Result.LanguageName = sysLanguageResource; DailyRows = Result.PersonalGanttChartRows; } else { throw new IllegalServiceAccess(String.Format("این سرویس بعللت اعتبارسنجی قابل دسترسی نمیباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc); } return(DailyRows); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BPersonMonthlyWorkedTime", "GetPersonMonthlyReport"); throw ex; } }
/// <summary> /// نتایج محاسبات را بارگزاری میکند /// </summary> /// <param name="year">سال</param> /// <param name="month">ماه</param> /// <param name="personList">لیست پرسنل</param> /// <returns>لیست پروکسی مقادیر نتایج محاسبات محاسبات</returns> private IList <ArchiveCalcValuesProxy> GetArchiveValues(int year, int month, IList <Person> personList) { try { //personList = this.CheckMaxArrayParamCount(personList); IList <ArchiveCalcValuesProxy> resultList = new List <ArchiveCalcValuesProxy>(); DateTime date = new DateTime(year, month, Utility.GetEndOfMiladiMonth(year, month)); int rangeOrder = month; if (BLanguage.CurrentSystemLanguage == LanguagesName.Parsi) { date = Utility.ToMildiDate(String.Format("{0}/{1}/{2}", year, month, Utility.GetEndOfPersianMonth(year, month))); } var ids = from o in personList select o.ID; IList <ArchiveConceptValue> archiveValues = archiveRep.LoadArchiveValueList(ids.ToList(), year, rangeOrder); IList <ArchiveFieldMap> fildsMapList = mapRep.GetAll(); foreach (Person prs in personList) { if (archiveValues.Any(x => x.PersonId == prs.ID)) { ArchiveCalcValuesProxy proxy = new ArchiveCalcValuesProxy() { PersonId = prs.ID, PersonCode = prs.PersonCode, PersonName = prs.Name }; proxy = SetMapValue(proxy, prs.ID, archiveValues, fildsMapList); resultList.Add(proxy); } } return(resultList); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex); throw ex; } }
//protected static void GetLog(Exception ex,string className,string methodName,string exceptionSource) //{ // BaseBusiness<Report>.LogException(ex, className, methodName, exceptionSource); //} public static IDictionary <string, object> ParsParameter(string parameters) { try { if (Utility.IsEmpty(parameters)) { return(null); } DateTime toDate = new DateTime(); if (!parameters.Contains("@") || !parameters.Contains("=") || !parameters.Contains(";") || Utility.CharOccuranceCount(parameters, "@") != Utility.CharOccuranceCount(parameters, "=") || Utility.CharOccuranceCount(parameters, "@") != Utility.CharOccuranceCount(parameters, ";")) { throw new ReportParameterIsNotMatchException(UIFatalExceptionIdentifiers.ReportParameterParsingSplitSign, "فرمت پارامتر های ارسالی جهت ترجمه نادرست است", ExceptionSrc); } string[] parts = Utility.Spilit(parameters, ';'); IDictionary <string, object> ParamValues = new Dictionary <string, object>(); foreach (string part in parts.Where(x => x.Length > 0).ToArray()) { string[] parmValues = Utility.Spilit(part, '='); if (parmValues.Length == 2 && parmValues[0].Contains('@')) { string paramName = parmValues[0].Replace("@", ""); string paramvalue = parmValues[1]; ParamValues.Add(paramName, paramvalue); } else { throw new ReportParameterIsNotMatchException(UIFatalExceptionIdentifiers.ReportParameterParsingIsNotMatch, "پارامترهای ارسالی جهت بازگشایی کامل نیستند", ExceptionSrc); } } return(ParamValues); } catch (Exception ex) { BaseBusiness <Report> .LogException(ex); throw ex; } }
public List <string> SaveCreditLimitUpdate(List <CreditLimitUpdate> CreditLimitUpdate) { List <string> ErrorMessage = new List <string>(); try { DataTable dtCreateCreditLimitUpdate = CollectionHelper.ConvertTo(CreditLimitUpdate, ""); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter param = new SqlParameter(); param.ParameterName = "@CreditLimitUpdateTable"; param.SqlDbType = System.Data.SqlDbType.Structured; param.Value = dtCreateCreditLimitUpdate; SqlParameter[] Parameters = { param }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "UpdateCreditLimitAgent", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "CreditLimitUpdate"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } } catch (Exception ex)// { throw ex; } return(ErrorMessage); }
public List <string> UpdateAlertEventType(AlertEventType alertEventType) { //validate Business Rule List <string> ErrorMessage = new List <string>(); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter[] Parameters = { new SqlParameter("@AlertSNo", alertEventType.SNo), new SqlParameter("@AlertEventTypeName", alertEventType.AlertEventTypeName), new SqlParameter("@UpdatedBy", alertEventType.UpdatedBy), new SqlParameter("@IsActive", alertEventType.IsActive), }; //DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "UpdateAlertEventType", Parameters); int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "UpdateAlertEventType", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "AlertEventType"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); }
public int GetSearchCount(string searchKey, int year, int month) { try { int rangeOrder = month; ISearchPerson searchTool = new BPerson(); int totalCount = searchTool.GetPersonInQuickSearchCount(searchKey); IList <Person> personList = searchTool.QuickSearchByPage(0, totalCount, searchKey); var ids = from o in personList select o.ID; IList <decimal> personIds = archiveRep.GetExsitsArchivePersons(ids.ToList(), year, rangeOrder); return(personIds.Count); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex); throw ex; } }
protected void dgDoktorlar_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "duzenle") { txtDoktorAd.Text = dgDoktorlar.Rows[index].Cells[3].Text; txtDoktorSoyad.Text = dgDoktorlar.Rows[index].Cells[4].Text; hfGizliAlan.Value = dgDoktorlar.Rows[index].Cells[2].Text; hfGizliAlan2.Value = dgDoktorlar.Rows[index].Cells[5].Text; } else if (e.CommandName == "sil") { Doktor d = new Doktor(); d.ID = Convert.ToInt32(dgDoktorlar.Rows[index].Cells[2].Text); BaseBusiness <Doktor> dr = new BaseBusiness <Doktor>(); dr.Sil(d); Temizle(); } }
public void DeletePersonnelMonthlyExceptionShifts(decimal personnelID, IList <DateTime> MonthDatesList) { try { for (int i = 0; i < MonthDatesList.Count(); i++) { ShiftException shiftException = this.objectRep.GetPersonnelExceptionShiftByDate(personnelID, MonthDatesList[i]); if (shiftException != null) { base.Delete(shiftException); } } } catch (Exception ex) { BaseBusiness <ShiftException> .LogException(ex, "BMonthlyExceptionShifts", "DeletePersonnelMonthlyExceptionShifts"); throw ex; } }
public List <string> UpdateConsumableStock(int ConsumableStockTransSno, int ConsumableSno, decimal TareWeight, string IsActive, string EquipmentNbr) { BaseBusiness baseBusiness = new BaseBusiness(); List <string> ErrorMessage = new List <string>(); int ret = 0; //DataTable dtItemList = CollectionHelper.ConvertTo(ItemList, ""); // var dtItemList = JsonConvert.DeserializeObject<DataTable>(ItemList); SqlParameter[] Parameters = { new SqlParameter("@ConsumableStockTransSno", ConsumableStockTransSno), new SqlParameter("@ConsumableSno", ConsumableSno), new SqlParameter("@TareWeight", TareWeight), new SqlParameter("@IsActive", IsActive), new SqlParameter("@EquipmentNbr", EquipmentNbr), new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "UpdateConsumableStock", Parameters); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "ConsumableStock"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); }
/// <summary> /// مانده مرخصی را انتهای ماه برمیگرداند /// </summary> /// <param name="personId"></param> /// <param name="year"></param> /// <param name="month"></param> /// <returns></returns> private string GetReaiLeaveToEndMonth(decimal personId, int year, int month) { string remain = ""; try { ILeaveInfo leaveInfo = new BRemainLeave(); int day, minutes; leaveInfo.GetRemainLeaveToEndOfMonth(personId, year, month, out day, out minutes); int hour = (minutes / 60); int min = minutes % 60; if (BLanguage.CurrentLocalLanguage == LanguagesName.Parsi) { remain = String.Format(" {0} روز و {1} ساعت و {2} دقیقه", day, hour, min); } else if (BLanguage.CurrentLocalLanguage == LanguagesName.English) { remain = String.Format(" {0} days and {1} hours and {2} minutes", day, hour, min); } } catch (InvalidDatabaseStateException ex) { BaseBusiness <Entity> .LogException(ex, "BWorkdTime", "GetReaiLeaveToEndMonth"); if (BLanguage.CurrentLocalLanguage == LanguagesName.Parsi) { remain = " محاسبه نشده"; } else if (BLanguage.CurrentLocalLanguage == LanguagesName.English) { remain = "Not Calculated"; } } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BWorkdTime", "GetReaiLeaveToEndMonth"); throw ex; } return(remain); }
private void btnGuncelle_Click(object sender, EventArgs e) { DialogResult rs = MessageBox.Show("Onaylıyor Musunuz?", "Onay", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { BaseBusiness <Doktor> bs = new BaseBusiness <Doktor>(); Doktor dr = new Doktor(); dr.Ad = txtDoktorAdi.Text.YaziyiDuzelt(); dr.Soyad = txtDoktorSoyadi.Text.YaziyiDuzelt(); dr.PoliklinikID = Convert.ToInt32(cbPoliklinik.SelectedValue); dr.ID = Convert.ToInt32(dgvDoktorlar.CurrentRow.Cells["ID"].Value); bs.Guncelle(dr); btnGuncelle.Enabled = false; btnKaydet.Enabled = true; dgvDoktorlar.Enabled = true; txtDoktorAdi.Text = ""; txtDoktorSoyadi.Text = ""; dgvDoktorlar.DatagridviewaDoktorGetir(cbPoliklinik.SelectedValue.ToString()); } }
public List <string> NewCashRegister(string CashierID, string GroupSNo) { try { int ret = 0; List <string> ErrorMessage = new List <string>(); BaseBusiness baseBussiness = new BaseBusiness(); SqlParameter[] Parameters = { new SqlParameter("@CashierID", CashierID), new SqlParameter("@GroupSNo", GroupSNo) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "NewCashRegister", Parameters); ErrorMessage.Add(Convert.ToString(ret)); return(ErrorMessage); } catch (Exception ex)//(Exception ex) { throw ex; } }
public string CreateIssueConsumables(List <IssueConsumablesList> lstConsumabIssue) { BaseBusiness baseBusiness = new BaseBusiness(); List <string> ErrorMessage = new List <string>(); int ret = 0; try { DataTable dtlstConsumabIssue = CollectionHelper.ConvertTo(lstConsumabIssue, ""); // var dtlstConsumabIssue = JsonConvert.DeserializeObject<DataTable>(lstConsumabIssue); SqlParameter[] Parameters = { new SqlParameter("@IssueConsumablesTable", dtlstConsumabIssue), new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "CreateIssueConsumables", Parameters); } catch (Exception ex)// { throw ex; } return(ret.ToString()); }
public string AWBSwap(string AWBList, string SwapAWBList) { BaseBusiness baseBusiness = new BaseBusiness(); List <string> ErrorMessage = new List <string>(); int ret = 0; try { var dtAWBList = JsonConvert.DeserializeObject <DataTable>(AWBList); var dtSwapAWBList = JsonConvert.DeserializeObject <DataTable>(SwapAWBList); SqlParameter[] Parameters = { new SqlParameter("@AWBList", dtAWBList), new SqlParameter("@SwapAWBList", dtSwapAWBList) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "SwapAWB", Parameters); } catch (Exception ex)// { throw ex; } return(ret.ToString()); }
private void btnGuncelle_Click(object sender, EventArgs e) { DialogResult rs = MessageBox.Show("Güncellemek istediğinizden emin misiniz?", "Emin Misininiz?", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { BaseBusiness <object> bs = new BaseBusiness <object>(); Poliklinik temp = new Poliklinik(); temp.Adi = txtPoliklinikAdi.Text.YaziyiDuzelt();; temp.ID = Convert.ToInt32(lbPoliklinikler.SelectedValue); temp.HastaneID = Convert.ToInt32(cbHastane.SelectedValue); bs.Guncelle(temp); lbPoliklinikler.ListboxaPoliklinikGetir(cbHastane.SelectedValue.ToString()); MessageBox.Show("Poliklinik Güncellendi", "Başarılı"); } txtPoliklinikAdi.Text = ""; lbPoliklinikler.SelectedIndex = -1; btnGuncelle.Enabled = false; btnKaydet.Enabled = true; lbPoliklinikler.Enabled = true; }
/// <summary> /// با دریافت یک گره از درخت تحت مدیریت مدیر تعداد اشخاص تحت مدیریت را برمیگرداند /// </summary> /// <param name="departmentID"></param> /// <returns></returns> public int GetUnderManagmentByDepartmentCount(int month, decimal departmentID) { try { if (BLanguage.CurrentSystemLanguage == LanguagesName.Parsi) { if (month <= 0) { month = Utility.ToPersianDateTime(DateTime.Now).Month; } } else { if (month <= 0) { month = DateTime.Now.Month; } } if (InitManager()) { int Result = managerRepository.GetUnderManagmentByDepartmentCount(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", ""); return(Result); } else if (InitOperator()) { int Result = managerRepository.GetUnderManagmentOperatorByDepartmentCount(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", ""); return(Result); } else { throw new IllegalServiceAccess(String.Format("این سرویس تنها توسط مدیران قابل استفاده میباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc); } } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BWorkedTime", "GetUnderManagmentByDepartmentCount"); throw ex; } }
public bool Calculate(decimal personId, string fromDate, string toDate, bool forceCalculate) { try { DateTime from, to; if (BLanguage.CurrentSystemLanguage == LanguagesName.Parsi) { from = Utility.ToMildiDate(fromDate); to = Utility.ToMildiDate(toDate); } else { from = Utility.ToMildiDateTime(fromDate); to = Utility.ToMildiDateTime(toDate); } decimal[] ids = new decimal[1]; ids[0] = personId; if (forceCalculate) { BusinessEntity entity = new BusinessEntity(); entity.UpdateCFP(new List <Person>() { new Person() { ID = personId } }, from, true); } gtsEngineWS.GTS_ExecutePersonsByToDate(BUser.CurrentUser.UserName, ids, to); BaseBusiness <Entity> .LogUserAction(String.Format("CalculateAll -> personId: {0} -->Calculate(personId,toDate)", personId)); return(true); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BEngineCalculator", "Calculate(personId,toDate)"); throw ex; } }
public IList <ProceedTrafficProxy> GetAllTrafic(decimal prsId, DateTime fromDate, DateTime toDate) { IList <ProceedTrafficProxy> list3; try { EntityRepository <ProceedTraffic> repository = new EntityRepository <ProceedTraffic>(); List <ProceedTrafficProxy> list = new List <ProceedTrafficProxy>(); CriteriaStruct[] structArray = new CriteriaStruct[3]; Person person = new Person(); person.ID = prsId; IList <ProceedTraffic> byCriteria = repository.GetByCriteria(new CriteriaStruct(Utility.GetPropertyName(() => new ProceedTraffic().Person), new Person() { ID = prsId }), new CriteriaStruct(Utility.GetPropertyName(() => new ProceedTraffic().FromDate), fromDate, CriteriaOperation.GreaterEqThan), new CriteriaStruct(Utility.GetPropertyName(() => new ProceedTraffic().FromDate), toDate, CriteriaOperation.LessEqThan)); foreach (ProceedTraffic traffic in byCriteria) { for (int i = 0; i < traffic.Pairs.Count; i++) { ProceedTrafficProxy item = new ProceedTrafficProxy(); item.From = Utility.IntTimeToRealTime(traffic.Pairs[i].From); item.To = Utility.IntTimeToRealTime(traffic.Pairs[i].To); item.Pishcard = traffic.Pairs[i].Precard.Name; item.Date = Utility.ToString(traffic.FromDate); list.Add(item); } } list3 = list; } catch (Exception exception) { BaseBusiness <BasicTraffic> .LogException(exception); throw exception; } return(list3); }
public List <string> UpdateMessageTypeMaster(List <MessageTypeMasterTrans> MessageTypeMasterInfoUpdate, string MessageDescription) { try { //validate Business Rule DataTable dtUpdateMessageTypeMaster = CollectionHelper.ConvertTo(MessageTypeMasterInfoUpdate, ""); List <string> ErrorMessage = new List <string>(); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter[] param = { new SqlParameter("@MessageTypeMasterTable", dtUpdateMessageTypeMaster), new SqlParameter("@MessageDescription", MessageDescription), new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; int ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "UpdateMessageTypeMaster", param); if (ret > 0) { if (ret > 1000) { //For Customised Validation Messages like 'Record Already Exists' etc string serverErrorMessage = baseBusiness.ReadServerErrorMessages(ret, "ULDInCompatibility"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBusiness.ReadServerErrorMessages(ret, baseBusiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); } catch (Exception ex)//(Exception ex) { throw ex; } }
public IList <ArchiveFieldMap> GetArchiveGridSettings() { try { IList <ArchiveFieldMap> mapList = mapRep.GetAll(); foreach (ArchiveFieldMap map in mapList) { if (Utility.IsEmpty(map.PId)) { map.Visible = false; } else if (!map.PId.ToLower().StartsWith("p")) { map.Visible = false; } if (map.Visible) { if (BLanguage.CurrentLocalLanguage == LanguagesName.Parsi) { map.Title = map.FnTitle; map.ColumnSize = map.FnColumnSize; } else { map.Title = map.EnTitle; map.ColumnSize = map.EnColumnSize; } } } return(mapList); } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex); throw ex; } }
// for update record public List <string> UpdateIndustryType(List <IndustryType> IndustryType) { int ret = 0; List <string> ErrorMessage = new List <string>(); BaseBusiness baseBussiness = new BaseBusiness(); SqlParameter[] Parameters = { new SqlParameter("@SNo", IndustryType[0].SNo), new SqlParameter("@IndustryTypeName", IndustryType[0].IndustryTypeName), new SqlParameter("@IndustryTypeDesc", IndustryType[0].IndustryTypeDesc), new SqlParameter("@IsActive", IndustryType[0].IsActive), new SqlParameter("@CreatedBy", IndustryType[0].CreatedBy), new SqlParameter("@UpdatedBy", IndustryType[0].UpdatedBy) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "UpdateIndustryType", Parameters); if (ret > 0) { if (ret > 1000) { string serverErrorMessage = baseBussiness.ReadServerErrorMessages(ret, "IndustryType"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBussiness.ReadServerErrorMessages(ret, baseBussiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } return(ErrorMessage); }
/// <summary> /// delete the perticular AccountTarget touple /// </summary> /// <param name="RecordID">Id of that AccountTarget touple</param> public List <string> deleteAccountTarget(string recordID) { List <string> ErrorMessage = new List <string>(); try { int ret = 0; BaseBusiness baseBussiness = new BaseBusiness(); int userSNo = ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo; SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", userSNo) }; ret = (int)SqlHelper.ExecuteScalar(DMLConnectionString.WebConfigConnectionString, "DeleteAccountTarget", Parameters); if (ret > 0) { if (ret > 1000) { string serverErrorMessage = baseBussiness.ReadServerErrorMessages(ret, "AccountTarget"); if (!string.IsNullOrEmpty(serverErrorMessage)) { ErrorMessage.Add(serverErrorMessage); } } else { //For DataBase Exceptions like 'Foreign Key refrence Errors' etc string dataBaseExceptionMessage = baseBussiness.ReadServerErrorMessages(ret, baseBussiness.DatabaseExceptionFileName); if (!string.IsNullOrEmpty(dataBaseExceptionMessage)) { ErrorMessage.Add(dataBaseExceptionMessage); } } } } catch (Exception ex)// { throw ex; } return(ErrorMessage); }