private string GetLoanTypeName(string loanTypeCode) { string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); DataTable dt = XMLBo.GetLoanType(path); foreach (DataRow dr in dt.Rows) { if (dr["XLT_LoanTypeCode"].ToString() == loanTypeCode) { return(dr["XLT_LoanType"].ToString()); } } return(string.Empty); }
protected void gvLnCommsnStrucLnPtr_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Footer) { DropDownList ddlAddLoanPartner; DropDownList ddlAddLoanType; DropDownList ddlSchemeName; ddlAddLoanPartner = e.Row.FindControl("ddlAddLoanPartner") as DropDownList; if (ddlAddLoanPartner != null) { ddlAddLoanPartner.DataSource = XMLBo.GetLoanPartner(path); ddlAddLoanPartner.DataTextField = "XLP_LoanPartner"; ddlAddLoanPartner.DataValueField = "XLP_LoanPartnerCode"; ddlAddLoanPartner.DataBind(); ddlAddLoanPartner.Items.Insert(0, "Select Loan Partner"); } ddlAddLoanType = e.Row.FindControl("ddlAddLoanType") as DropDownList; if (ddlAddLoanType != null) { ddlAddLoanType.DataSource = XMLBo.GetLoanType(path); ddlAddLoanType.DataTextField = "XLT_LoanType"; ddlAddLoanType.DataValueField = "XLT_LoanTypeCode"; ddlAddLoanType.DataBind(); ddlAddLoanType.Items.Insert(0, "Select Loan Type"); } ddlSchemeName = e.Row.FindControl("ddlAddSchemeName") as DropDownList; ddlSchemeName.Items.Insert(0, "Select Scheme"); } if (e.Row.RowType == DataControlRowType.DataRow) { if (dsCount != 0) { DropDownList ddlLoanPartner; DropDownList ddlLoanType; DropDownList ddlSchemeName; AdviserLoanCommsnStrucWithLoanPartnerVo adviserLoanCommsnStrucWithLoanPartnervo = new AdviserLoanCommsnStrucWithLoanPartnerVo(); adviserLoanCommsnStrucWithLoanPartnervo = AdviserLoanCommsnStrucWithLoanPartnerVoList[gvLnCommsnStrucLnPtr.Rows.Count]; ddlLoanPartner = e.Row.FindControl("ddlLoanPartner") as DropDownList; if (ddlLoanPartner != null) { ddlLoanPartner.DataSource = XMLBo.GetLoanPartner(path); ddlLoanPartner.DataTextField = "XLP_LoanPartner"; ddlLoanPartner.DataValueField = "XLP_LoanPartnerCode"; ddlLoanPartner.DataBind(); ddlLoanPartner.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanPartnerCode.ToString(); } ddlLoanType = e.Row.FindControl("ddlLoanType") as DropDownList; if (ddlLoanType != null) { ddlLoanType.DataSource = XMLBo.GetLoanType(path); ddlLoanType.DataTextField = "XLT_LoanType"; ddlLoanType.DataValueField = "XLT_LoanTypeCode"; ddlLoanType.DataBind(); ddlLoanType.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanTypeCode.ToString(); } AdviserLoanCommsnStrucWithLoanPartnerBo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerBo(); DataSet ds1 = AdviserLoanCommsnStrucWithLoanPartner.GetAdviserLoanSchemeNameForLnPtnrLnType(int.Parse(ddlLoanType.SelectedValue), int.Parse(ddlLoanPartner.SelectedValue), adviserVo.advisorId); ddlSchemeName = e.Row.FindControl("ddlSchemeName") as DropDownList; if (ddlSchemeName != null) { ddlSchemeName.DataSource = ds1; ddlSchemeName.DataTextField = "LoanSchemeName"; ddlSchemeName.DataValueField = "LoanSchemeId"; ddlSchemeName.DataBind(); ddlSchemeName.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanSchemeId.ToString(); } } } }