private void BindLoanGrid() { try { RadGrid1.Visible = true; SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT(); smhr_LoanAmount.OPERATION = operation.Get; smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]); smhr_LoanAmount.LoanID = Convert.ToInt32(rad_TypeOfLoan.SelectedValue); smhr_LoanAmount.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue); DataTable dt = BLL.get_LoanMaxEligibleAmount(smhr_LoanAmount); SMHR_PERIOD osmhr_period = new SMHR_PERIOD(); osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue); DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period); if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0) { RadGrid1.Enabled = false; btn_Save.Visible = false; } else { RadGrid1.Enabled = true; btn_Save.Visible = true; } RadGrid1.DataSource = dt; RadGrid1.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { clearControls(); BindFinancialPeriod(); //BindLoanTypes(); rad_TypeOfLoan.Enabled = false; RadGrid1.Visible = true; SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT(); smhr_LoanAmount.OPERATION = operation.Get; smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]); smhr_LoanAmount.LoanID = Convert.ToInt32(e.CommandArgument); DataTable dt = BLL.get_LoanMaxEligibleAmount(smhr_LoanAmount); RadGrid1.DataSource = dt; RadGrid1.DataBind(); if (dt.Rows.Count > 0) { SMHR_PAYITEMS _obj_Smhr_BusinessUnit = new SMHR_PAYITEMS(); _obj_Smhr_BusinessUnit.OPERATION = operation.Check2; _obj_Smhr_BusinessUnit.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt1 = BLL.get_PayItems(_obj_Smhr_BusinessUnit); rad_TypeOfLoan.DataSource = dt1; rad_TypeOfLoan.DataValueField = "PAYITEM_ID"; rad_TypeOfLoan.DataTextField = "PAYITEM_PAYITEMNAME"; rad_TypeOfLoan.DataBind(); rad_TypeOfLoan.Items.Insert(0, new RadComboBoxItem("Select", "-1")); rad_TypeOfLoan.SelectedIndex = rad_TypeOfLoan.FindItemIndexByValue(smhr_LoanAmount.LoanID.ToString()); radFinPeriod.SelectedIndex = radFinPeriod.FindItemIndexByValue(dt.Rows[0]["LOANELIGIBLEAMOUNT_FIN_PERIOD_ID"].ToString()); } SMHR_PERIOD osmhr_period = new SMHR_PERIOD(); osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue); DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period); if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0) { RadGrid1.Enabled = false; } else { RadGrid1.Enabled = true; } // trExpend.Visible = false; lbl_ExpenditureID.Text = smhr_LoanAmount.LoanID.ToString(); // rad_ExpenditureName.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_NAME"]); // rad_ExpenditureName.Enabled = false; // rtxt_ExpenditureDesc.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_DESC"]); btn_Save.Visible = true; Rm_CY_page.SelectedIndex = 1; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (radFinPeriod.SelectedIndex <= 0) { BLL.ShowMessage(this, "Please Select Financial Period"); return; } SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT(); smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]); DataTable dtGadeWiseAMount = GetGadeWiseAMount(); smhr_LoanAmount.GradeWiseAmount = dtGadeWiseAMount; smhr_LoanAmount.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue); smhr_LoanAmount.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session smhr_LoanAmount.CREATEDDATE = DateTime.Now; smhr_LoanAmount.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session smhr_LoanAmount.LASTMDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_SAVE": smhr_LoanAmount.LoanID = Convert.ToInt32(rad_TypeOfLoan.SelectedValue); smhr_LoanAmount.OPERATION = operation.Insert; if (BLL.set_LoanMaxEligibleAmount(smhr_LoanAmount)) { BLL.ShowMessage(this, "Information Saved Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; default: break; } Rm_CY_page.SelectedIndex = 0; LoadGrid(); Rg_MedicalBenifit.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public void LoadGrid() { try { SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT(); smhr_LoanAmount.OPERATION = operation.Select; smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_LoanMaxEligibleAmount(smhr_LoanAmount); Rg_MedicalBenifit.DataSource = DT; clearControls(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void BindLoanTypes() { try { SMHR_LOANELIGIBLEAMOUNT _obj_Smhr_loan = new SMHR_LOANELIGIBLEAMOUNT(); _obj_Smhr_loan.OPERATION = operation.Check; _obj_Smhr_loan.OrgID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_LoanMaxEligibleAmount(_obj_Smhr_loan); rad_TypeOfLoan.DataSource = dt; rad_TypeOfLoan.DataValueField = "PAYITEM_ID"; rad_TypeOfLoan.DataTextField = "PAYITEM_PAYITEMNAME"; rad_TypeOfLoan.DataBind(); rad_TypeOfLoan.Items.Insert(0, new RadComboBoxItem("Select", "-1")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }