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);
}
}
