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