public string loadBankers(int id)
{
type = "update";
try
{
LoanDSTableAdapters.BankersTableAdapter bankers = new LoanDSTableAdapters.BankersTableAdapter();
LoanDS.BankersDataTable tblBankers = bankers.GetBankerDetails(id);
if (tblBankers.Rows.Count > 0)
{
txtAcName.Value = tblBankers[0].datAccountName.ToString();
txtAcNo.Value = tblBankers[0].datAccountNo.ToString();
txtbank.Value = tblBankers[0].datBank.ToString();
txtbranch.Value = tblBankers[0].datBranch.ToString();
try {
ddlType.SelectedValue = tblBankers[0].datAccountType.ToString();
}
catch (Exception ex) { }
//ddlType.SelectedIndex = ddlType.Items.IndexOf(ddlType.Items.FindByValue(tblBankers[0].datAccountType.ToString()));
}
this.editskip.Value = "2";
}
catch(Exception ex)
{
Console.Write(ex.Message);
}
return "";
}
public string loadBankers(int id)
{
type = "update";
try
{
LoanDSTableAdapters.BankersTableAdapter bankers = new LoanDSTableAdapters.BankersTableAdapter();
LoanDS.BankersDataTable tblBankers = bankers.GetBankerDetails(id);
if (tblBankers.Rows.Count > 0)
{
txtAcName.Value = tblBankers[0].datAccountName.ToString();
txtAcNo.Value = tblBankers[0].datAccountNo.ToString();
txtbank.Value = tblBankers[0].datBank.ToString();
txtbranch.Value = tblBankers[0].datBranch.ToString();
try {
ddlType.SelectedValue = tblBankers[0].datAccountType.ToString();
}
catch (Exception ex) { }
//ddlType.SelectedIndex = ddlType.Items.IndexOf(ddlType.Items.FindByValue(tblBankers[0].datAccountType.ToString()));
}
this.editskip.Value = "2";
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return("");
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.BankersTableAdapter bankers = new LoanDSTableAdapters.BankersTableAdapter();
if (!(type == "update"))
{
bankers.InsertBanker(MySessionManager.ClientID,
MySessionManager.AppID,
txtbank.Value.Trim(),
txtAcName.Value.Trim(),
txtbranch.Value.Trim(),
ddlType.Text,
txtAcNo.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
// Request.QueryString[]
bankers.UpdateBankers(txtbank.Value.Trim(),
txtAcName.Value.Trim(),
txtbranch.Value.Trim(),
ddlType.Text,
txtAcNo.Value.Trim(),
MySessionManager.CurrentUser.UserID,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "bedit"));
this.editskip.Value = "1";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.BankersTableAdapter bankers = new LoanDSTableAdapters.BankersTableAdapter();
if (!(type == "update"))
{
bankers.InsertBanker(MySessionManager.ClientID,
MySessionManager.AppID,
txtbank.Value.Trim(),
txtAcName.Value.Trim(),
txtbranch.Value.Trim(),
ddlType.Text,
txtAcNo.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
// Request.QueryString[]
bankers.UpdateBankers(txtbank.Value.Trim(),
txtAcName.Value.Trim(),
txtbranch.Value.Trim(),
ddlType.Text,
txtAcNo.Value.Trim(),
MySessionManager.CurrentUser.UserID,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "bedit"));
this.editskip.Value = "1";
}
}
