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