protected void Add_Click(object sender, ImageClickEventArgs e)
{
DbSapInstance sa;
try
{
if (Mode.Equals(FlagEnum.EditFlag))
{
sa = ScgDbQueryProvider.DbSapInstanceQuery.FindByIdentity(SAPID);
}
else
{
sa = new DbSapInstance();
}
sa.Code = ctlSapInstanceCode.Text;
sa.AliasName = ctlAliasName.Text;
sa.SystemID = ctlSystemID.Text;
sa.Client = ctlClient.Text;
sa.UserName = ctlUser.Text;
sa.Password = ctlPassword.Text;
sa.Language = ctlLanguage.Text;
sa.SystemNumber = ctlSystemNumber.Text;
sa.MsgServerHost = ctlMsgServerHost.Text;
sa.LogonGroup = ctlLogonGroup.Text;
sa.UserCPIC = ctlUserCPIC.Text;
sa.DocTypeExpPostingDM = ctlDocTypeExpPostingDM.Text;
sa.DocTypeExpRmtPostingDM = ctlDocTypeExpRmtPostingDM.Text;
sa.DocTypeExpPostingFR = ctlDocTypeExpPostingFR.Text;
sa.DocTypeExpRmtPostingFR = ctlDocTypeExpRmtPostingFR.Text;
sa.DocTypeExpICPostingFR = ctlDocTypeExpICPostingFR.Text;
sa.DocTypeAdvancePostingDM = ctlDocTypeAdvancePostingDM.Text;
sa.DocTypeAdvancePostingFR = ctlDocTypeAdvancePostingFR.Text;
sa.DocTypeRmtPosting = ctlDocTypeRmtPosting.Text;
sa.DocTypeFixedAdvancePosting = ctlDocTypeFixedAdvancePosting.Text;
sa.DocTypeFixedAdvanceReturnPosting = ctlDocTypeFixedAdvanceReturnPosting.Text;
sa.CreBy = UserAccount.UserID;
sa.CreDate = DateTime.Now;
sa.UpdBy = UserAccount.UserID;
sa.UpdDate = DateTime.Now;
sa.UpdPgm = UserAccount.CurrentLanguageCode;
//DbSapInstanceService.SaveOrUpdate(sa);
if (Mode.Equals(FlagEnum.EditFlag))
{
DbSapInstanceService.UpdateSapInstance(sa);
}
else if (Mode.Equals(FlagEnum.NewFlag))
{
DbSapInstanceService.AddSapInstance(sa);
}
Notify_Ok(sender, e);
}
catch (ServiceValidationException ex)
{
ValidationErrors.MergeErrors(ex.ValidationErrors);
ctlUpdatePanel.Update();
}
}
protected void ctlSapGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex;
if (e.CommandName.Equals("SapEdit"))
{
rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
SapInstanceCode = ctlSapGrid.DataKeys[rowIndex].Values["Code"].ToString();
ctlSapInstanceEditor.Initialize(FlagEnum.EditFlag, SapInstanceCode);
ctlSapInstanceEditor.ShowPopUp();
}
if (e.CommandName.Equals("SapDelete"))
{
try
{
rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
SapInstanceCode = ctlSapGrid.DataKeys[rowIndex].Value.ToString();
DbSapInstance sa = ScgDbQueryProvider.DbSapInstanceQuery.FindByIdentity(SapInstanceCode);
DbSapInstanceService.Delete(sa);
}
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);
ctlSapGrid.DataCountAndBind();
}
}
ctlSapGrid.DataCountAndBind();
ctlUpdatePanel.Update();
}
}
