protected void ctlBankFormView_ItemInserting(object sender, FormViewInsertEventArgs e)
{
DbBank dbBank = new DbBank();
TextBox txtBankNo = ctlBankFormView.FindControl("ctlTxtBankNo") as TextBox;
TextBox txtComment = ctlBankFormView.FindControl("ctlTxtComment") as TextBox;
CheckBox chkActive = ctlBankFormView.FindControl("chkActive") as CheckBox;
dbBank.BankNo = txtBankNo.Text;
dbBank.Comment = txtComment.Text;
dbBank.Active = chkActive.Checked;
dbBank.UpdPgm = ProgramCode;
dbBank.CreDate = DateTime.Now.Date;
dbBank.UpdDate = DateTime.Now.Date;
dbBank.CreBy = UserAccount.UserID;
dbBank.UpdBy = UserAccount.UserID;
try
{
DbBankService.Save(dbBank);
e.Cancel = true;
ctlGridBank.DataCountAndBind();
ctlBankModalPopupExtender.Hide();
UpdatePanelGridView.Update();
}
catch
{ }
//catch (ServiceValidationException ex)
//{
// ValidationErrors.MergeErrors(ex.ValidationErrors);
//}
}
protected void ctlBankFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
short bankId = UIHelper.ParseShort(ctlBankFormView.DataKey.Value.ToString());
DbBank dbBank = DbBankService.FindByIdentity(bankId);
TextBox txtBankNo = ctlBankFormView.FindControl("ctlTxtBankNo") as TextBox;
TextBox txtComment = ctlBankFormView.FindControl("ctlTxtComment") as TextBox;
CheckBox chkActive = ctlBankFormView.FindControl("chkActive") as CheckBox;
dbBank.BankNo = txtBankNo.Text;
dbBank.Comment = txtComment.Text;
dbBank.Active = chkActive.Checked;
dbBank.UpdPgm = ProgramCode;
dbBank.UpdDate = DateTime.Now.Date;
dbBank.UpdBy = UserAccount.UserID;
try
{
DbBankService.SaveOrUpdate(dbBank);
// Cancel insert with DataSource.
e.Cancel = true;
ctlGridBank.DataCountAndBind();
ctlBankModalPopupExtender.Hide();
UpdatePanelGridView.Update();
}
catch
{ }
//catch ( ServiceValidationException ex)
//{
// ValidationErrors.MergeErrors(ex.ValidationErrors);
//}
}
protected void ctlGridBank_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "BankEdit")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
short bankId = UIHelper.ParseShort(ctlGridBank.DataKeys[rowIndex].Value.ToString());
ctlGridBank.EditIndex = rowIndex;
IList <DbBank> bankList = new List <DbBank>();
DbBank bank = DbBankService.FindByIdentity(bankId);
bankList.Add(bank);
ctlBankFormView.DataSource = bankList;
ctlBankFormView.PageIndex = 0;
ctlBankFormView.ChangeMode(FormViewMode.Edit);
ctlBankFormView.DataBind();
UpdatePanelBankForm.Update();
ctlBankModalPopupExtender.Show();
BankLangGridViewFinish();
}
else if (e.CommandName == "Select")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
short bankId = UIHelper.ParseShort(ctlGridBank.DataKeys[rowIndex].Value.ToString());
ctlBankLangGrid.DataSource = DbBankLangService.FindByBankId(bankId);
ctlBankLangGrid.DataBind();
if (ctlBankLangGrid.Rows.Count > 0)
{
ctlSubmit.Visible = true;
ctlCancel.Visible = true;
ctlBankLangLangFds.Visible = true;
}
else
{
ctlSubmit.Visible = false;
ctlCancel.Visible = false;
ctlBankLangLangFds.Visible = false;
}
ctlBankLangUpdatePanel.Update();
}
}
protected void ctlBtnDeleteBank_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in ctlGridBank.Rows)
{
if ((row.RowType == DataControlRowType.DataRow) && ((CheckBox)row.FindControl("ctlSelect")).Checked)
{
short bankId = UIHelper.ParseShort(ctlGridBank.DataKeys[row.RowIndex].Value.ToString());
if (!((CheckBox)row.FindControl("ctlChkActive")).Checked)//ไม่ Active
{
try
{
BankLangGridViewFinish();
DbBank bank = DbBankService.FindProxyByIdentity(bankId);
ScgDbDaoProvider.DbBankLangDao.DeleteAllBankLang(bankId);
DbBankService.Delete(bank);
UpdatePanelGridView.Update();
}
catch (Exception ex)
{
if (((System.Data.SqlClient.SqlException)(ex.GetBaseException())).Number == 547)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertInUseData",
"alert('Bank ID : " + bankId.ToString() + " is Active. Can't Delete It');", true);
}
}
}
else//Active
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertActiveData",
"alert('Bank ID :" + bankId.ToString() + " is Active. Can't Delete It');", true);
}
}
}
ctlGridBank.DataCountAndBind();
}