public void Initial(string mode, long costCenterID) { ResetValue(); Mode = mode; CostCenterID = costCenterID; if (mode == FlagEnum.EditFlag) { DbCostCenter costCenter = DbCostCenterService.FindByIdentity(costCenterID); if ((costCenter.CompanyID != null)) { DbCompany company = DbCompanyService.FindByIdentity(costCenter.CompanyID.CompanyID); ctlCompanyTextboxAutoComplete.CompanyCode = costCenter.CompanyID.CompanyCode; } this.CostCenterCode = costCenter.CostCenterCode; ctlCostCenterCodeLabel.Text = costCenter.CostCenterCode; ctlCostCenterCodeLabel.Visible = true; ctlTextBoxCostCenterCode.Visible = false; ctlTextBoxDescription.Text = costCenter.Description; //ctlCalendarValid.DateValue = costCenter.Valid.ToString(Constant.CalendarDateFormat); //ctlCalendarExpire.DateValue = costCenter.Valid.ToString(Constant.CalendarDateFormat); ctlCalendarValid.Value = costCenter.Valid; ctlCalendarExpire.Value = costCenter.Expire; ctlChkLock.Checked = costCenter.ActualPrimaryCosts; ctlChkActive.Checked = costCenter.Active; ctlBusinessArea.Text = costCenter.BusinessArea; ctlProfitCenter.Text = costCenter.ProfitCenter; } }
protected void ctlGridView_RowCommand(object sender, GridViewCommandEventArgs e) { #region e.CommandName == "Delete" if (e.CommandName == "DeleteCostCenter") { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; long costCenterID = UIHelper.ParseLong(ctlGridView.DataKeys[rowIndex].Value.ToString()); DbCostCenter costCenter = new DbCostCenter(); costCenter.CostCenterID = costCenterID; try { DbCostCenterService.DeleteCostCenter(costCenter); } catch (ServiceValidationException ex) { ValidationErrors.MergeErrors(ex.ValidationErrors); } } #endregion #region e.CommandName == "Edit" else if (e.CommandName == "EditCostCenter") { int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; long costCenterID = UIHelper.ParseLong(ctlGridView.DataKeys[rowIndex].Value.ToString()); ctlCostCenterEditor.Initial(FlagEnum.EditFlag, costCenterID); ctlCostCenterEditor.ShowPopUp(); } #endregion RefreshUpdatePanel(sender, e); }
public void SetValue(long costCenterID) { DbCostCenter costCenter = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(costCenterID); if (costCenter != null) { ctlAutoCostCenter.CostCenterCode = costCenter.CostCenterCode; ctlDescription.Text = costCenter.Description; ctlCostCenterCode.Value = costCenter.CostCenterCode.ToString(); ctlCostCenterID.Value = costCenter.CostCenterID.ToString(); Control ioField = this.NamingContainer.FindControl(IOFieldControlID); if (ioField != null && ioField is IOAutoCompleteLookup) { IOAutoCompleteLookup io = (IOAutoCompleteLookup)ioField; //io.CostCenterId = costCenter.CostCenterID; io.SetCostCenter(costCenter.CostCenterID); } } else { this.ResetValue(); } ctlUpdatePanelCostCenter.Update(); }
protected int RequestCount() { DbCostCenter costCenter = new DbCostCenter(); costCenter.CostCenterCode = ctlTxtCostCenterCode.Text; costCenter.Description = ctlTxtCostCenterDescription.Text; return(ScgDbQueryProvider.DbCostCenterQuery.CountCostCenterCompany(costCenter)); }
protected Object RequestData(int startRow, int pageSize, string sortExpression) { DbCostCenter costCenter = new DbCostCenter(); costCenter.CostCenterCode = ctlTxtCostCenterCode.Text; costCenter.Description = ctlTxtCostCenterDescription.Text; return(ScgDbQueryProvider.DbCostCenterQuery.FindCostCenterCompany(costCenter, startRow, pageSize, sortExpression)); }
protected void ctlCostCenterLookUp_OnObjectLookUpReturn(object sender, ObjectLookUpReturnArgs e) { IList <DbCostCenter> CostCenter = (IList <DbCostCenter>)e.ObjectReturn; DbCostCenter dbCostCenter = CostCenter.First <DbCostCenter>(); CostCenterID = dbCostCenter.CostCenterID; ctlCostCenter.Text = dbCostCenter.CostCenterCode; ctlUpdatePanelCostCenterSimple.Update(); }
public void SetCostCenterValue(long costcenterId) { if (costcenterId > 0) { CostCenterID = costcenterId; DbCostCenter cost = ScgDbQueryProvider.DbCostCenterQuery.FindProxyByIdentity(costcenterId); ctlCostCenter.Text = String.Format("{0}", cost.CostCenterCode); } ctlUpdatePanelCostCenterSimple.Update(); }
protected void ctlCostCenterLookup_OnNotifyPopup(object sender, PopUpReturnArgs args) { if (args.Type.Equals(PopUpReturnType.OK)) { IList <DbCostCenter> CostCenter = (IList <DbCostCenter>)args.Data; DbCostCenter dbCostCenter = CostCenter.First <DbCostCenter>(); CostCenterId = dbCostCenter.CostCenterID.ToString(); ctlAutoCostCenter.CostCenterCode = dbCostCenter.CostCenterCode; ctlDescription.Text = dbCostCenter.Description; CallOnObjectLookUpReturn(dbCostCenter); } ctlUpdatePanelCostCenter.Update(); }
public string DisplayCostCenter(Object obj) { ExpenseDataSet.FnExpenseInvoiceItemRow row = (ExpenseDataSet.FnExpenseInvoiceItemRow)obj; if (!string.IsNullOrEmpty(row["CostCenterID"].ToString())) { DbCostCenter costCenter = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(row.CostCenterID); if (costCenter != null) { return(Server.HtmlEncode(costCenter.CostCenterCode)); } } return(string.Empty); }
public void BindCostCenterControl(long costCenterId) { DbCostCenter costCenter = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(costCenterId); if (costCenter != null) { ctlCostCenterID.Value = costCenter.CostCenterID.ToString(); ctlCostCenterCode.Value = costCenter.CostCenterCode; ctlAutoCostCenter.CostCenterID = costCenter.CostCenterID.ToString(); ctlAutoCostCenter.CostCenterCode = costCenter.CostCenterCode; ctlDescription.Text = costCenter.Description; } ctlUpdatePanelCostCenter.Update(); }
public override void SaveOrUpdate(FnExpensePerdiem perdiem) { if (perdiem.CostCenter != null) { DbCostCenter costcenter = ScgDbDaoProvider.DbCostCenterDao.FindProxyByIdentity(perdiem.CostCenter.CostCenterID); perdiem.CostCenter = costcenter; } if (perdiem.Account != null) { DbAccount account = ScgDbDaoProvider.DbAccountDao.FindProxyByIdentity(perdiem.Account.AccountID); perdiem.Account = account; } if (perdiem.IO != null) { DbInternalOrder io = ScgDbDaoProvider.DbIODao.FindProxyByIdentity(perdiem.IO.IOID); perdiem.IO = io; } base.SaveOrUpdate(perdiem); }
public override long Save(FnExpenseInvoiceItem invoiceItem) { if (invoiceItem.CostCenter != null) { DbCostCenter costcenter = ScgDbDaoProvider.DbCostCenterDao.FindProxyByIdentity(invoiceItem.CostCenter.CostCenterID); invoiceItem.CostCenter = costcenter; } if (invoiceItem.Account != null) { DbAccount account = ScgDbDaoProvider.DbAccountDao.FindProxyByIdentity(invoiceItem.Account.AccountID); invoiceItem.Account = account; } if (invoiceItem.IO != null) { DbInternalOrder io = ScgDbDaoProvider.DbIODao.FindProxyByIdentity(invoiceItem.IO.IOID); invoiceItem.IO = io; } return(base.Save(invoiceItem)); }
private void CheckDataValueUpdate(DbCostCenter costCenter) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (string.IsNullOrEmpty(costCenter.CostCenterCode)) { errors.AddError("CostCenter.Error", new Spring.Validation.ErrorMessage("RequiredCostCenterCode")); } if (string.IsNullOrEmpty(costCenter.CompanyCode)) { errors.AddError("CostCenter.Error", new Spring.Validation.ErrorMessage("RequiredCompanyCode")); } if ((CostCenterCode.ToString() != ctlTextBoxCostCenterCode.Text) && (ScgDbQueryProvider.DbCostCenterQuery.IsDuplicateCostCenterCode(costCenter))) { errors.AddError("CostCenter.Error", new Spring.Validation.ErrorMessage("DuplicationCostCenterCode")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } }
protected void ctlCostCenterPopupCaller_NotifyPopupResult(object sender, string action, string value) { if (action != "ok") { return; } object returnValue = new object(); if (!isMultiple) { //DbCostCenter costCenter = ScgDbQueryProvider.DbCostCenterQuery.FindProxyByIdentity(UIHelper.ParseLong(value)); //returnValue = costCenter; DbCostCenter costCenter = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(UIHelper.ParseLong(value)); IList <DbCostCenter> list = new List <DbCostCenter>(); list.Add(costCenter); returnValue = list; NotifyPopUpReturn(new PopUpReturnArgs(PopUpReturnType.OK, returnValue)); } else { string[] strCostCenterIDList = value.Split('|'); IList <long> costCenterIDList = new List <long>(); foreach (string id in strCostCenterIDList) { costCenterIDList.Add(UIHelper.ParseLong(id)); } if (costCenterIDList.Count > 0) { returnValue = ScgDbQueryProvider.DbCostCenterQuery.FindByCostCenterIDList(costCenterIDList); } NotifyPopUpReturn(new PopUpReturnArgs(PopUpReturnType.OK, returnValue)); //CallOnObjectLookUpReturn(returnValue); } }
protected void ctlInsert_Click1(object sender, ImageClickEventArgs e) { DbInternalOrder io; try { if (Mode.Equals(FlagEnum.EditFlag)) { io = ScgDbQueryProvider.DbIOQuery.FindByIdentity(IOID); } else { io = new DbInternalOrder(); io.IONumber = ctlIONumber.Text; } io.IOType = ctlIOType.Text; io.IOText = ctlIOText.Text; io.Active = ctlIOActive.Checked; io.BusinessArea = ctlBusinessArea.Text; io.ProfitCenter = ctlProfitCenter.Text; DbCostCenter cost = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(UIHelper.ParseLong(ctlCostCenterField.CostCenterId)); if (cost != null) { io.CostCenterID = cost.CostCenterID; io.CostCenterCode = cost.CostCenterCode; } DbCompany com = ScgDbQueryProvider.DbCompanyQuery.FindByIdentity(UIHelper.ParseLong(ctlCompanyField.CompanyID)); if (com != null) { io.CompanyID = com.CompanyID; io.CompanyCode = com.CompanyCode; } io.CreBy = UserAccount.UserID; io.CreDate = DateTime.Now; io.UpdBy = UserAccount.UserID; io.UpdDate = DateTime.Now; io.UpdPgm = UserAccount.CurrentLanguageCode; if (!string.IsNullOrEmpty(ctlCalEffectiveDate.DateValue)) { try { io.EffectiveDate = UIHelper.ParseDate(ctlCalEffectiveDate.DateValue).Value; } catch {} } else { io.EffectiveDate = null; } if (!string.IsNullOrEmpty(ctlCalLastDisplayDate.DateValue)) { try { io.ExpireDate = UIHelper.ParseDate(ctlCalLastDisplayDate.DateValue).Value; } catch { } } else { io.ExpireDate = null; } CheckDataValueUpdate(io); if (Mode.Equals(FlagEnum.EditFlag)) { DbIOService.UpdateIO(io); } else { DbIOService.AddIO(io); } Notify_Ok(sender, e); } catch (ServiceValidationException ex) { this.ValidationErrors.MergeErrors(ex.ValidationErrors); } catch (NullReferenceException) { //Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); //errors.AddError("InternalOrder.Error", new ErrorMessage("CostCenter and Company Require.")); //ValidationErrors.MergeErrors(errors); //return; } }
public void ValidateInvoiceItem(Guid txId, long expenseId) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpenseDocumentRow expRow = expDs.FnExpenseDocument.FindByExpenseID(expenseId); ExpenseDataSet.DocumentRow docRow = expDs.Document.FindByDocumentID(expRow.DocumentID); ExpenseDataSet.FnExpenseInvoiceItemRow[] itemRows = (ExpenseDataSet.FnExpenseInvoiceItemRow[])expDs.FnExpenseInvoiceItem.Select(); foreach (ExpenseDataSet.FnExpenseInvoiceItemRow row in itemRows) { string accountCode = string.Empty; if (!row.IsIOIDNull()) { DbInternalOrder io = ScgDbQueryProvider.DbIOQuery.FindByIdentity(row.IOID); if (io == null || !io.CompanyID.HasValue || io.CompanyID.Value != docRow.CompanyID) { if (io == null) { io = new DbInternalOrder() { IONumber = "Unknown" }; } errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("InternalOrder_Is_Invalid", new object[] { io.IONumber })); } } if (!row.IsAccountIDNull()) { DbAccount account = ScgDbQueryProvider.DbAccountQuery.FindByIdentity(row.AccountID); IList <VOAccountCompany> accountList = ScgDbQueryProvider.DbAccountCompanyQuery.FindAccountCompany(docRow.CompanyID, row.AccountID); if (account == null || accountList.Count == 0) { if (account == null) { account = new DbAccount() { AccountCode = "Unknown" }; } errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ExpenseCode_Is_Invalid", new object[] { account.AccountCode })); } accountCode = account.AccountCode; } if (!row.IsCostCenterIDNull()) { DbCostCenter cost = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(row.CostCenterID); if (cost == null || cost.CompanyID == null || cost.CompanyID.CompanyID != docRow.CompanyID) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CostCenter_Is_Invalid", new object[] { cost.CostCenterCode })); } else { if (!string.IsNullOrEmpty(accountCode)) { DbAccount ac = ScgDbQueryProvider.DbAccountQuery.FindAccountByAccountCodeExpenseGroup(accountCode, null); if (ac == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ExpenseCode_Is_Invalid_With_Costcenter", new object[] { accountCode, cost.CostCenterCode })); } } } } } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } }
public void UpdateExpenseMileageOnTransaction(FnExpenseMileage expenseMileage, Guid txId) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId); long documentId = 0; if (expenseMileage.Expense != null) { ExpenseDataSet.FnExpenseDocumentRow expRow = ds.FnExpenseDocument.FindByExpenseID(expenseMileage.Expense.ExpenseID); documentId = expRow == null ? 0 : expRow.DocumentID; } if (expenseMileage.CarLicenseNo.Length.Equals(0)) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredCarLicenseNo")); } if (expenseMileage.Owner.Equals(OwnerMileage.Employee)) { if (expenseMileage.First100KmRate.Equals((double)0)) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredFirst100KmOverZero")); } if (expenseMileage.Exceed100KmRate.Equals((double)0)) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredExceed100KmOverZero")); } } else { if (expenseMileage.TotalAmount.Equals((double)0)) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredTotalAmountOverZero")); } } if (!expenseMileage.Owner.Equals(OwnerMileage.Company) || !expenseMileage.TypeOfCar.Equals(TypeOfCar.Pickup)) { // Validate CostCenter. if (expenseMileage.CostCenter == null) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredCostCenter")); } else { if (ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(expenseMileage.CostCenter.CostCenterID) == null) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredCostCenter")); } } // Validate Account. if (expenseMileage.Account == null) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredAccountID")); } else { if (ScgDbQueryProvider.DbAccountQuery.FindByIdentity(expenseMileage.Account.AccountID) == null) { errors.AddError("Mileage.Error", new Spring.Validation.ErrorMessage("RequiredAccountID")); } } } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } ExpenseDataSet.FnExpenseMileageRow row = ds.FnExpenseMileage.FindByExpenseMileageID(expenseMileage.ExpenseMileageID); row.BeginEdit(); if (expenseMileage.Expense != null) { row.ExpenseID = expenseMileage.Expense.ExpenseID; } row.Owner = expenseMileage.Owner; row.CarLicenseNo = expenseMileage.CarLicenseNo; row.TypeOfCar = expenseMileage.TypeOfCar; row.PermissionNo = expenseMileage.PermissionNo; row.HomeToOfficeRoundTrip = (decimal)expenseMileage.HomeToOfficeRoundTrip; row.PrivateUse = (decimal)expenseMileage.PrivateUse; row.IsOverrideLevel = expenseMileage.IsOverrideLevel; if (expenseMileage.OverrideCompanyId != null) { row.OverrideCompanyId = (long)expenseMileage.OverrideCompanyId; } if (expenseMileage.CurrentCompanyId != null) { row.CurrentCompanyId = (long)expenseMileage.CurrentCompanyId; } row.OverrideLevelRemark = expenseMileage.OverrideLevelRemark; row.OverrideUserPersonalLevelCode = expenseMileage.OverrideUserPersonalLevelCode; row.CurrentUserPersonalLevelCode = expenseMileage.CurrentUserPersonalLevelCode; row.First100KmRate = (decimal)expenseMileage.First100KmRate; row.Exceed100KmRate = (decimal)expenseMileage.Exceed100KmRate; row.HelpingAmount = (decimal)expenseMileage.HelpingAmount; row.OverHelpingAmount = (decimal)expenseMileage.OverHelpingAmount; row.TotalAmount = (decimal)expenseMileage.TotalAmount; if (expenseMileage.CostCenter != null) { row.CostCenterID = expenseMileage.CostCenter.CostCenterID; } else { row.SetCostCenterIDNull(); } if (expenseMileage.Account != null) { row.AccountID = expenseMileage.Account.AccountID; } else { row.SetAccountIDNull(); } if (expenseMileage.IO != null) { row.IOID = expenseMileage.IO.IOID; } else { row.SetIOIDNull(); } row.CreDate = DateTime.Now; row.CreBy = UserAccount.UserID; row.UpdDate = DateTime.Now; row.UpdBy = UserAccount.UserID; row.UpdPgm = UserAccount.CurrentProgramCode; row.Active = true; row.EndEdit(); UpdateMileageSummary(txId, expenseMileage); ExpenseDataSet.FnExpenseMileageRow mileageRow = ds.FnExpenseMileage.FindByExpenseMileageID(expenseMileage.ExpenseMileageID); ExpenseDataSet.FnExpenseDocumentRow expenseRow = ds.FnExpenseDocument.FindByExpenseID(row.ExpenseID); long requesterId = 0; if (expenseRow != null) { ExpenseDataSet.DocumentRow docRow = ds.Document.FindByDocumentID(expenseRow.DocumentID); if (docRow != null) { requesterId = docRow.RequesterID; } } long invoiceId = 0; DataRow[] invoiceRows = ds.FnExpenseInvoice.Select(String.Format("InvoiceDocumentType = '{0}'", InvoiceType.Mileage)); FnExpenseInvoice invoice = new FnExpenseInvoice(); string accountCode = string.Empty; SuUser requester = SS.SU.Query.QueryProvider.SuUserQuery.FindByIdentity(requesterId); if (expenseMileage.Owner.Equals(OwnerMileage.Employee) || (expenseMileage.Owner.Equals(OwnerMileage.Company) && !expenseMileage.TypeOfCar.Equals(TypeOfCar.Pickup))) { if (invoiceRows.Length > 0) { foreach (DataRow inv in invoiceRows) { invoiceId = inv.Field <long>("InvoiceID"); DataRow[] invoiceItemRows = ds.FnExpenseInvoiceItem.Select(String.Format("InvoiceID = {0} ", invoiceId)); foreach (DataRow item in invoiceRows) { item.Delete(); } inv.Delete(); } } } //Add empty invoice invoice.InvoiceDocumentType = InvoiceType.Mileage; invoice.Expense = expenseMileage.Expense; DbCostCenter cost = null; string expenseGroup = "0"; if (!mileageRow.IsCostCenterIDNull()) { cost = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(mileageRow.CostCenterID); expenseGroup = (cost == null ? string.Empty : cost.CostCenterCode.Substring(3, 1).Equals("0") ? "0" : "1"); } DbInternalOrder io = null; if (expenseMileage.IO != null) { io = ScgDbQueryProvider.DbIOQuery.FindByIdentity(expenseMileage.IO.IOID); } if (expenseMileage.Owner.Equals(OwnerMileage.Employee)) { double total = (double)mileageRow.TotalAmount; invoice.TotalAmount = total; invoice.TotalBaseAmount = total; invoice.NetAmount = total; invoiceId = FnExpenseInvoiceService.AddInvoiceOnTransaction(invoice, txId); invoice.InvoiceID = invoiceId; FnExpenseInvoiceItem invoiceItemGov = new FnExpenseInvoiceItem(); FnExpenseInvoiceItem invoiceItemExtra = new FnExpenseInvoiceItem(); invoiceItemGov.Invoice = invoice; invoiceItemExtra.Invoice = invoice; invoiceItemGov.CostCenter = expenseMileage.CostCenter; invoiceItemGov.Account = expenseMileage.Account; invoiceItemGov.IO = expenseMileage.IO; invoiceItemExtra.CostCenter = expenseMileage.CostCenter; if (io != null && !string.IsNullOrEmpty(io.IONumber)) { string ioType = io.IONumber.Substring(4, 2); if (ioType.Contains("02") || ioType.Contains("03") || ioType.Contains("04") || ioType.Contains("09")) { invoiceItemExtra.IO = null; } else { invoiceItemExtra.IO = io; } } invoiceItemExtra.Account = ScgDbQueryProvider.DbAccountQuery.FindAccountByAccountCodeExpenseGroup(ParameterServices.AccountMileageExtra, null); //switch (expenseGroup) //{ // case "0": // invoiceItemExtra.Account = ScgDbQueryProvider.DbAccountQuery.FindAccountByAccountCodeExpenseGroup(ParameterServices.AccountMileageOfficeExtra, expenseGroup, null); // break; // case "1": // invoiceItemExtra.Account = ScgDbQueryProvider.DbAccountQuery.FindAccountByAccountCodeExpenseGroup(ParameterServices.AccountMileageFactoryExtra, expenseGroup, null); // break; // default: // break; //} if (mileageRow.HelpingAmount <= mileageRow.TotalAmount) { invoiceItemGov.Amount = (double)mileageRow.HelpingAmount; } else if (mileageRow.HelpingAmount > mileageRow.TotalAmount) { invoiceItemGov.Amount = (double)mileageRow.TotalAmount; } invoiceItemExtra.Amount = (double)mileageRow.OverHelpingAmount; if (invoiceItemGov.Amount > 0) { FnExpenseInvoiceItemService.AddMileageInvoiceItem(invoiceItemGov, txId); } if (invoiceItemExtra.Amount > 0) { FnExpenseInvoiceItemService.AddMileageInvoiceItem(invoiceItemExtra, txId); } } else if (expenseMileage.Owner.Equals(OwnerMileage.Company) && (!expenseMileage.TypeOfCar.Equals(TypeOfCar.Pickup))) { invoice.TotalAmount = (double)mileageRow.HelpingAmount; invoice.TotalBaseAmount = (double)mileageRow.HelpingAmount; invoice.NetAmount = (double)mileageRow.HelpingAmount; invoiceId = FnExpenseInvoiceService.AddInvoiceOnTransaction(invoice, txId); FnExpenseInvoiceItem invoiceItem = new FnExpenseInvoiceItem(); invoice.InvoiceID = invoiceId; invoiceItem.Invoice = invoice; invoiceItem.CostCenter = expenseMileage.CostCenter; invoiceItem.Account = expenseMileage.Account; invoiceItem.IO = expenseMileage.IO; //switch (expenseGroup) //{ // case "0": // accountCode = ParameterServices.AccountMileageOfficeCompany; // break; // case "1": // accountCode = ParameterServices.AccountMileageFactoryCompany; // break; // default: // break; //} //invoiceItem.Account = ScgDbQueryProvider.DbAccountQuery.FindAccountByAccountCodeExpenseGroup(accountCode, expenseGroup, null); invoiceItem.Amount = (double)mileageRow.HelpingAmount; FnExpenseInvoiceItemService.AddMileageInvoiceItem(invoiceItem, txId); } }
protected void ctlInsert_Click1(object sender, ImageClickEventArgs e) { try { if (Mode == FlagEnum.NewFlag) { #region Insert user = new SuUser(); user.UserName = ctlUserProfileId.Text; user.PeopleID = ctlUserProfilePeopleId.Text; user.SetFailTime = UIHelper.ParseShort(ctlSetFailTime.Text); user.EmployeeCode = ctlUserProfileEmployeeCode.Text; user.EmployeeName = ctlUserProfileEmployeeName.Text; user.SMSApproveOrReject = ctlApproveRecject.Checked; user.SMSReadyToReceive = ctlToReceive.Checked; user.MobilePhoneNo = ctlUserProfileMobilePhoneNo.Text; user.SectionName = ctlUserProfileSectionName.Text; user.PersonalLevel = ctlUserProfilePersonalLevel.Text; user.PersonalDescription = ctlUserProfilePersonalLevelDescription.Text; user.PersonalGroup = ctlUserProfilePersonalGroup.Text; user.PersonalLevelGroupDescription = ctlUserProfilePersonalGroupDescription.Text; user.PositionName = ctlUserProfilePositionName.Text; user.PhoneNo = ctlUserProfilePhoneNo.Text; user.Email = ctlUserProfileEmail.Text; user.ApprovalFlag = ctlUserProfileApprovalFlag.Checked; user.Active = ctlUserProfileActive.Checked; user.Language = new SS.DB.DTO.DbLanguage(UIHelper.ParseShort(ctlCmbLanguage.SelectedValue)); user.ChangePassword = ctlChangePassword.Checked; user.IsAdUser = ctlIsAdUser.Checked; user.VendorCode = ctlVendorCode.Text; user.EmailActive = ctlEmailActive.Checked; DbCompany com = ScgDbQueryProvider.DbCompanyQuery.FindByIdentity(UIHelper.ParseLong(ctlCompanyField.CompanyID)); if (com != null) { user.CompanyCode = com.CompanyCode; user.Company = com; } if (ctlLocationField.LocationID != null) { DbLocation location = ScgDbQueryProvider.DbLocationQuery.FindProxyByIdentity(ctlLocationField.LocationID.Value); if (location != null) { user.LocationCode = location.LocationCode; user.Location = location; } } DbCostCenter cost = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(UIHelper.ParseLong(ctlCostCenterField.CostCenterId)); if (cost != null) { user.CostCenter = cost; user.CostCenterCode = cost.CostCenterCode; } if (ctlSupervisor.UserID != null) { SuUser su = QueryProvider.SuUserQuery.FindProxyByIdentity(ctlSupervisor.UserID.Value); if (su != null) { user.Supervisor = su.Userid; } } user.UpdBy = UserAccount.UserID; user.UpdDate = DateTime.Now; user.CreBy = UserAccount.UserID; user.CreDate = DateTime.Now; user.UpdPgm = UserAccount.CurrentProgramCode; // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== if (!string.IsNullOrEmpty(ctlUserPassword.Text)) { user.Password = Encryption.Md5Hash(ctlUserPassword.Text); } user.AllowPasswordChangeDate = DateTime.Now.AddDays(ParameterServices.MinPasswordAge); user.PasswordExpiryDate = DateTime.Now.AddDays(ParameterServices.MaxPasswordAge); if (ctlLockUser.Checked) { user.FailTime = user.SetFailTime; } else { user.FailTime = 0; } // ======== End add code for control password same as Password Policy by Anuwat S on 23/04/2009 ======== SuUserService.SaveUserProfile(user); // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== SCGEmailService.SendEmailEM08(user.Userid, ctlUserPassword.Text); #endregion Insert } else if (Mode == FlagEnum.EditFlag) { #region Edit user = QueryProvider.SuUserQuery.FindByIdentity(UserID); user.UserName = ctlUserProfileId.Text; user.PeopleID = ctlUserProfilePeopleId.Text; user.SetFailTime = UIHelper.ParseShort(ctlSetFailTime.Text); user.EmployeeCode = ctlUserProfileEmployeeCode.Text; user.EmployeeName = ctlUserProfileEmployeeName.Text; user.SMSApproveOrReject = ctlApproveRecject.Checked; user.SMSReadyToReceive = ctlToReceive.Checked; user.MobilePhoneNo = ctlUserProfileMobilePhoneNo.Text; user.SectionName = ctlUserProfileSectionName.Text; user.PersonalLevel = ctlUserProfilePersonalLevel.Text; user.PersonalDescription = ctlUserProfilePersonalLevelDescription.Text; user.PersonalGroup = ctlUserProfilePersonalGroup.Text; user.PersonalLevelGroupDescription = ctlUserProfilePersonalGroupDescription.Text; user.PositionName = ctlUserProfilePositionName.Text; user.PhoneNo = ctlUserProfilePhoneNo.Text; user.Email = ctlUserProfileEmail.Text; user.ApprovalFlag = ctlUserProfileApprovalFlag.Checked; user.Active = ctlUserProfileActive.Checked; user.Language = new SS.DB.DTO.DbLanguage(UIHelper.ParseShort(ctlCmbLanguage.SelectedValue)); user.ChangePassword = ctlChangePassword.Checked; user.IsAdUser = ctlIsAdUser.Checked; user.VendorCode = ctlVendorCode.Text; user.EmailActive = ctlEmailActive.Checked; DbCompany com = ScgDbQueryProvider.DbCompanyQuery.FindByIdentity(UIHelper.ParseLong(ctlCompanyField.CompanyID)); if (com != null) { user.CompanyCode = com.CompanyCode; user.Company = com; } if (ctlLocationField.LocationID != null) { DbLocation location = ScgDbQueryProvider.DbLocationQuery.FindProxyByIdentity(ctlLocationField.LocationID.Value); if (location != null) { user.LocationCode = location.LocationCode; user.Location = location; } } DbCostCenter cost = ScgDbQueryProvider.DbCostCenterQuery.FindByIdentity(UIHelper.ParseLong(ctlCostCenterField.CostCenterId)); if (cost != null) { user.CostCenter = cost; user.CostCenterCode = cost.CostCenterCode; } if (ctlSupervisor.UserID != null) { SuUser su = QueryProvider.SuUserQuery.FindProxyByIdentity(ctlSupervisor.UserID.Value); if (su != null) { user.Supervisor = su.Userid; } } user.UpdBy = UserAccount.UserID; user.UpdDate = DateTime.Now; user.CreBy = UserAccount.UserID; user.CreDate = DateTime.Now; user.UpdPgm = UserAccount.CurrentProgramCode; // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== if ((int.Parse(ctlOriginFailTime.Value) <= (user.FailTime) && !ctlLockUser.Checked) || !user.SetFailTime.Equals(short.Parse(ctlOriginFailTime.Value))) { user.FailTime = 0; // Unlock user } else if (ctlLockUser.Checked) { user.FailTime = user.SetFailTime; // Still lock user } // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== //SuUserService.SaveOrUpdate(user); SuUserService.UpdateUserProfile(user); #endregion Edit } // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== IList <SuPasswordHistory> passwordHistoryList = QueryProvider.SuPasswordHistoryQuery.FindActiveByUserId(user.Userid); foreach (SuPasswordHistory passwordHist in passwordHistoryList) { passwordHist.Active = false; passwordHist.UpdBy = UserAccount.UserID; passwordHist.UpdDate = DateTime.Now; passwordHist.UpdPgm = ProgramCode; SuPasswordHistoryService.SaveOrUpdate(passwordHist); } // ========== Add code for control password same as Password Policy by Anuwat S on 23/04/2009 ========== if (Notify_Ok != null) { Notify_Ok(sender, e); } Alert(GetMessage("SaveSuccessFully")); } catch (ServiceValidationException ex) { ValidationErrors.MergeErrors(ex.ValidationErrors); ctlUpdatePanelUserProfileForm.Update(); } }
protected void ctlButtonSave_Click(object sender, EventArgs e) { if (Mode == FlagEnum.EditFlag) { DbCostCenter costCenter = DbCostCenterService.FindByIdentity(CostCenterID); costCenter.ActualPrimaryCosts = ctlChkLock.Checked; costCenter.Active = ctlChkActive.Checked; costCenter.CompanyCode = ctlCompanyTextboxAutoComplete.Text; costCenter.Description = ctlTextBoxDescription.Text; //costCenter.CostCenterCode = ctlTextBoxCostCenterCode.Text; costCenter.BusinessArea = ctlBusinessArea.Text; costCenter.ProfitCenter = ctlProfitCenter.Text; try { costCenter.Valid = UIHelper.ParseDate(ctlCalendarValid.DateValue).Value; costCenter.Expire = UIHelper.ParseDate(ctlCalendarExpire.DateValue).Value; } catch (Exception) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); errors.AddError("CostCenter.Error", new ErrorMessage("Invalid or Null in Datetime fields.")); ValidationErrors.MergeErrors(errors); //return; } costCenter.UpdBy = UserAccount.UserID; costCenter.UpdDate = DateTime.Now.Date; costCenter.UpdPgm = ProgramCode; try { CheckDataValueUpdate(costCenter); DbCostCenterService.UpdateCostCenter(costCenter); DbCostCenterService.UpdateCostCenterToExp(costCenter); } catch (ServiceValidationException ex) { ValidationErrors.MergeErrors(ex.ValidationErrors); return; } } if (Mode == FlagEnum.NewFlag) { DbCostCenter costCenter = new DbCostCenter(); costCenter.CompanyID = new DbCompany(); costCenter.ActualPrimaryCosts = ctlChkLock.Checked; costCenter.Active = ctlChkActive.Checked; costCenter.CompanyCode = ctlCompanyTextboxAutoComplete.Text; costCenter.Description = ctlTextBoxDescription.Text; costCenter.CostCenterCode = ctlTextBoxCostCenterCode.Text; costCenter.BusinessArea = ctlBusinessArea.Text; costCenter.ProfitCenter = ctlProfitCenter.Text; try { costCenter.Valid = UIHelper.ParseDate(ctlCalendarValid.DateValue).Value; costCenter.Expire = UIHelper.ParseDate(ctlCalendarExpire.DateValue).Value; } catch (Exception) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); errors.AddError("CostCenter.Error", new ErrorMessage("Invalid or Null in Datetime fields.")); ValidationErrors.MergeErrors(errors); //return; } costCenter.UpdBy = UserAccount.UserID; costCenter.UpdDate = DateTime.Now.Date; costCenter.UpdPgm = ProgramCode; costCenter.CreBy = UserAccount.UserID; costCenter.CreDate = DateTime.Now.Date; try { CheckDataValueInsert(costCenter); DbCostCenterService.AddCostCenter(costCenter); } catch (ServiceValidationException ex) { ValidationErrors.MergeErrors(ex.ValidationErrors); return; } } HidePopUp(); Notify_Ok(sender, e); }