protected void Expense_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex; if (e.CommandName.Equals("Company")) { rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex; AccountID = UIHelper.ParseShort(ctlExpenseInfoGrid.DataKeys[rowIndex].Values["AccountID"].ToString()); ctlExpenseInfoGrid.SelectedIndex = rowIndex; ctlCompanyInfoEditor.Initialize(AccountID); ctlCompanyInfoEditor.ShowDetail(); } if (e.CommandName.Equals("ExpenseInfoEdit")) { rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; ExpenseGroupID = UIHelper.ParseShort(ctlExpenseInfoGrid.DataKeys[rowIndex].Values["ExpenseGroupID"].ToString()); AccountID = UIHelper.ParseShort(ctlExpenseInfoGrid.DataKeys[rowIndex].Values["AccountID"].ToString()); ctlAccountLangEditor.Initialize(FlagEnum.EditFlag, AccountID, ExpenseGroupID); ctlAccountLangEditor.ShowPopUp(); } if (e.CommandName.Equals("ExpenseInfoDelete")) { try { rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; ExpenseGroupID = UIHelper.ParseShort(ctlExpenseInfoGrid.DataKeys[rowIndex].Values["ExpenseGroupID"].ToString()); AccountID = UIHelper.ParseShort(ctlExpenseInfoGrid.DataKeys[rowIndex].Values["AccountID"].ToString()); DbAccount ac = ScgDbQueryProvider.DbAccountQuery.FindAccountByEGroupIDAID(ExpenseGroupID, AccountID); DbAccountService.DeleteAccount(ac); ctlCompanyInfoEditor.HideDetail(); } catch (Exception ex) { if (((System.Data.SqlClient.SqlException)(ex.GetBaseException())).Number == 547) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertInUseData", "alert('This data is now in use.');", true); ctlExpenseInfoGrid.DataCountAndBind(); } } ctlExpenseInfoGrid.DataCountAndBind(); ctlExpenseInfoUpdatePanel.Update(); } }
protected void ctlAdd_Click(object sender, ImageClickEventArgs e) { DbAccount account = new DbAccount(); if (Mode.Equals(FlagEnum.EditFlag)) { account.AccountID = AcountID; } account.AccountCode = ctlExpenseCode.Text; account.Active = ctlActive.Checked; account.CreBy = UserAccount.UserID; account.CreDate = DateTime.Now; account.DomesticRecommend = ctlDomesticRecommend.Checked; account.ExpenseGroupID = ExpenseGroupID; account.ForeignRecommend = ctlForeignRecommend.Checked; account.SaveAsDebtor = ctlSaveAsDebtor.Checked; account.SaveAsVendor = ctlSaveAsVendor.Checked; account.SAPSpecialGL = ctlspecialGL.Text; account.SAPSpecialGLAssignment = ctlSAPSpecialGLAssignment.Text; account.TaxCode = Convert.ToInt32(ctlTaxCode.SelectedValue); account.CostCenter = Convert.ToInt32(ctlCostCenter.SelectedValue); account.InternalOrder = Convert.ToInt32(ctlInternalOrder.SelectedValue); account.SaleOrder = Convert.ToInt32(ctlSaleOrder.SelectedValue); account.UpdBy = UserAccount.UserID; account.UpdDate = DateTime.Now; account.UpdPgm = UserAccount.CurrentProgramCode; #region check for exception #endregion try { // save or update PB if (Mode.Equals(FlagEnum.EditFlag)) { DbAccountService.UpdateAccount(account); } else { account.AccountID = DbAccountService.AddNewAccount(account); } // save or update PBlang IList <DbAccountLang> list = new List <DbAccountLang>(); foreach (GridViewRow row in ctlAccountLangGrid.Rows) { short languageId = UIHelper.ParseShort(ctlAccountLangGrid.DataKeys[row.RowIndex]["LanguageID"].ToString()); TextBox Description = row.FindControl("ctrDescription") as TextBox; TextBox Comment = (TextBox)row.FindControl("ctrComment") as TextBox; CheckBox Active = (CheckBox)row.FindControl("ctlActive") as CheckBox; if ((!string.IsNullOrEmpty(Description.Text))) { DbAccountLang accountLang = new DbAccountLang(); accountLang.Active = Active.Checked; accountLang.CreBy = UserAccount.UserID; accountLang.CreDate = DateTime.Now; accountLang.AccountName = Description.Text; accountLang.Comment = Comment.Text; accountLang.LanguageID = new DbLanguage(languageId); accountLang.Account = account; accountLang.UpdBy = UserAccount.UserID; accountLang.UpdDate = DateTime.Now; accountLang.UpdPgm = UserAccount.CurrentLanguageCode; list.Add(accountLang); } } if (Mode.Equals(FlagEnum.EditFlag)) { DbAccountLangService.UpdateListAccountLang(list); } if (Mode.Equals(FlagEnum.NewFlag)) { DbAccountLangService.AddListAccountLang(list); } Notify_Ok(sender, e); } catch (ServiceValidationException ex) { this.ValidationErrors.MergeErrors(ex.ValidationErrors); } }
public static string GetAccountCodeExpMapping(string accountCode, string expenseGroupType) { DbAccountService service = new DbAccountService(); return(service.GetAccountCodeExpMapping(accountCode, expenseGroupType)); }