protected void ExpenseGroup_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = 0; if (e.CommandName.Equals("ExpenseGroup")) { rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex; ExpenseGropID = UIHelper.ParseLong(ctlExpenseGroupGrid.DataKeys[rowIndex].Value.ToString()); ctlExpenseInfoEditor.Initialize(ExpenseGropID); ctlExpenseInfoEditor.ShowDetail(); } if (e.CommandName.Equals("ExpenseGroupEdit")) { rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; ExpenseGropID = UIHelper.ParseLong(ctlExpenseGroupGrid.DataKeys[rowIndex].Value.ToString()); // call for edit/add popup ctlExpenseGroupEditor.Initialize(FlagEnum.EditFlag, ExpenseGropID); ctlExpenseGroupEditor.ShowPopUp(); ctlExpenseInfoEditor.HideDetail(); } if (e.CommandName.Equals("ExpenseGroupDelete")) { try { rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; ExpenseGropID = UIHelper.ParseLong(ctlExpenseGroupGrid.DataKeys[rowIndex].Value.ToString()); // get DbExpenseGroup to delete DbExpenseGroup expense = ScgDbQueryProvider.DbExpenseGroupQuery.FindByIdentity(ExpenseGropID); DbExpenseGroupService.DeleteExpenseGroup(expense); } 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); ctlExpenseGroupGrid.DataCountAndBind(); } } } ctlExpenseGroupGrid.SelectedIndex = rowIndex; ctlExpenseGroupGrid.DataCountAndBind(); ctlExpenseGroupUpdatePanel.Update(); }
public void Initialize(string mode, long expanseID) { Mode = mode.ToString(); EGroupID = expanseID; if (mode.Equals(FlagEnum.EditFlag)) { DbExpenseGroup ep = ScgDbQueryProvider.DbExpenseGroupQuery.FindProxyByIdentity(EGroupID); ctlExpenseGroup.Text = ep.ExpenseGroupCode; ctlActive.Checked = ep.Active; ctlExpenseEditorGrid.DataCountAndBind(); ctlExpenseGroupUpdatePanel.Update(); } else if (mode.ToString() == FlagEnum.NewFlag) { ResetValue(); } }
protected void ctlAdd_Click(object sender, ImageClickEventArgs e) { DbExpenseGroup ep = new DbExpenseGroup(); if (Mode.Equals(FlagEnum.EditFlag)) { ep.ExpenseGroupID = EGroupID; } ep.ExpenseGroupCode = ctlExpenseGroup.Text; ep.Active = ctlActive.Checked; /// save in service ep.CreBy = UserAccount.UserID; ep.CreDate = DateTime.Now; ep.UpdBy = UserAccount.UserID; ep.UpdDate = DateTime.Now; ep.UpdPgm = UserAccount.CurrentProgramCode; try { // save or update PB if (Mode.Equals(FlagEnum.EditFlag)) { DbExpenseGroupService.UpdateExpenseGroup(ep); } else { long id = DbExpenseGroupService.AddExpenseGroup(ep); ep.ExpenseGroupID = id; } // save or update PBlang IList <DbExpenseGroupLang> list = new List <DbExpenseGroupLang>(); foreach (GridViewRow row in ctlExpenseEditorGrid.Rows) { short languageId = UIHelper.ParseShort(ctlExpenseEditorGrid.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))) { DbExpenseGroupLang exLang = new DbExpenseGroupLang(); exLang.Description = description.Text; exLang.Comment = comment.Text; exLang.Active = active.Checked; // save in service exLang.CreBy = UserAccount.UserID; exLang.CreDate = DateTime.Now; exLang.ExpenseGroupID = ep; exLang.LanguageID = new DbLanguage(languageId); exLang.UpdBy = UserAccount.UserID; exLang.UpdDate = DateTime.Now; exLang.UpdPgm = UserAccount.CurrentProgramCode; list.Add(exLang); } } if (Mode.Equals(FlagEnum.EditFlag)) { DbExpenseGroupLangService.UpdateExpenseGroupLang(list); } if (Mode.Equals(FlagEnum.NewFlag)) { DbExpenseGroupLangService.AddExpenseGroupLang(list); } Notify_Ok(sender, e); } catch (ServiceValidationException ex) { this.ValidationErrors.MergeErrors(ex.ValidationErrors); } }