internal static DropDownList FillddlIntAccumulate(DropDownList ddl, int Event, int Id, string Code)//event 1 for ddl fill
{
ddl.Items.Clear();
var dt = BL_Bank_Desc.GetIntAccumulate(Event, Id, Code);
if (dt.Rows.Count > 0)
{
ddl.DataSource = dt;
ddl.DataValueField = "IntAcc_ID";
ddl.DataTextField = "IntAcc_Desc";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("Select", "0", true));
}
return(ddl);
}
public void FillGrid()
{
try
{
var dt = BL_Bank_Desc.GetBankDetails(1, branchId, "");
if (dt.Rows.Count > 0)
{
gridview_mode.DataSource = dt;
gridview_mode.DataBind();
}
else
{
gridview_mode.DataSource = null;
gridview_mode.DataBind();
gridview_mode.EmptyDataText = "<center>No Records Found.</center>";
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gridview_mode_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit1")
{
var index = Convert.ToInt32(e.CommandArgument);
var row = gridview_mode.Rows[index];
var lblid = (Label)row.FindControl("lblid");
var id = int.Parse(lblid.Text);
var lblBankName = (Label)row.FindControl("lblBankName");
var lblAccountNo = (Label)row.FindControl("lblAccountNo");
var lblAccounttype = (Label)row.FindControl("lblAccounttype");
var lblRate = (Label)row.FindControl("lblRate");
var lblcalmethod = (Label)row.FindControl("lblcalmethod");
var lblaccumulationmethod = (Label)row.FindControl("lblaccumulationmethod");
var lblMaturityDate = (Label)row.FindControl("lblMaturityDate");
var lblOpeningDate = (Label)row.FindControl("lblOpeningDate");
var lblBankClass = (Label)row.FindControl("lblBankClass");
var lblNomineeAc = (Label)row.FindControl("lblNomineeAc");
// ddlBranch.SelectedIndex=ddlBranch.Items.IndexOf(ddlBranch.Items.FindByText(lblBra))
ddl_calMethod.SelectedIndex = ddl_calMethod.Items.IndexOf(ddl_calMethod.Items.FindByText(lblcalmethod.Text));
ddl_acc.SelectedIndex = ddl_acc.Items.IndexOf(ddl_acc.Items.FindByText(lblaccumulationmethod.Text));
txt_BankName.Text = lblBankName.Text;
txt_AccountNo.Text = lblAccountNo.Text;
txt_OpeningDate.Text = lblOpeningDate.Text;
txtMaturityDate.Text = lblMaturityDate.Text;
txtinterestaccumulation.Text = lblNomineeAc.Text;
txtAmount.Text = BL_Bank_Desc.GetBankBal(int.Parse(lblid.Text)).ToString();
// txtinterestaccumulation.Text = DL_Bank.Nomineeacno(int.Parse(lblid.Text));
txtAmount.Enabled = false;
txtRate.Text = lblRate.Text;
ddl_class.SelectedValue = lblBankClass.Text;
if (lblAccounttype.Text == "S")
{
ddlaccounttype.SelectedValue = "2";
}
else if (lblAccounttype.Text == "C")
{
ddlaccounttype.SelectedValue = "1";
}
else
{
ddlaccounttype.SelectedValue = "3";
}
if (ddlaccounttype.SelectedValue == "1")
{
pnlAccountType.Visible = false;
pnlFD.Visible = false;
}
else if (ddlaccounttype.SelectedValue == "2")
{
pnlAccountType.Visible = true;
pnlFD.Visible = false;
}
else
{
pnlAccountType.Visible = true;
pnlFD.Visible = true;
}
btn_submit.Text = "Update";
btn_submit.CommandName = "Update";
btn_submit.CommandArgument = id.ToString();
btnCancel.Visible = true;
ddlaccounttype_SelectedIndexChanged(sender, e);
}
}
private void InsUpdDelBankDetail(char Event, int id)
{
var msg = "";
if (Event == 'I' || Event == 'U')
{
msgSuccess.Text = "";
msgSuccess.Visible = false;
int userid = Convert.ToInt16(BK_Session.GetSession().UserId.ToString());
var accounttype = "";
var cashbank = false;
var bankid = 0;
var maturitydate = new DateTime();
if (ddlaccounttype.SelectedValue == "1")
{
accounttype = "C";
txtRate.Text = "0";
txtAmount.Text = "0";
maturitydate = DateTime.Parse("01/01/1991");
}
else if (ddlaccounttype.SelectedValue == "2")
{
accounttype = "S";
txtAmount.Text = "0";
maturitydate = DateTime.Parse("01/01/1991");
}
else
{
txtAmount.Text = "0";
accounttype = "FD";
maturitydate =
DateTime.Parse(txtMaturityDate.Text);
}
if (ddlmodeofpayment.SelectedItem.Text == "Bank")
{
cashbank = true;
bankid = int.Parse(ddlSelectBank.SelectedValue);
}
var objBank = new Bank(id, txt_BankName.Text + "-" + txt_AccountNo.Text, txt_AccountNo.Text,
float.Parse(txtAmount.Text), 0, Convert.ToDateTime(txt_OpeningDate.Text), BK_Session.GetSession().UserId,
Convert.ToDateTime(txt_OpeningDate.Text), 0, Convert.ToDateTime(txt_OpeningDate.Text), accounttype,
ddl_class.SelectedValue, int.Parse(ddlBranch.SelectedValue), decimal.Parse(txtRate.Text), int.Parse(ddl_calMethod.SelectedValue), int.Parse(ddl_acc.SelectedValue), maturitydate,
cashbank, bankid, txtinterestaccumulation.Text);
msg = BL_Bank_Desc.InsUpdDelBankDetail(Event, objBank, out id);
branchId = BK_Session.GetSession().BranchId;
FillGrid();
}
else
{
}
if (DatabaseMessage.ContainMessage(msg))
{
msgbox.ShowSuccess(msg);
}
else
{
msgbox.ShowWarning(msg);
}
}
