protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
//to clear controls
ClearControls();
rcmb_FinancialYear.Enabled = false;
LoadFinancialPeriods(); //To load financial periods
//To fetch data based on CommandArgument
SMHR_PENSION_INT_REG_UNREG _objPensionInt = new SMHR_PENSION_INT_REG_UNREG();
_objPensionInt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_objPensionInt.INT_ID = Convert.ToInt32(e.CommandArgument);
_objPensionInt.OPERATION = operation.Get;
DataTable dt = BLL.get_PensionIntOnRegtUnRegtAmt(_objPensionInt);
if (dt.Rows.Count > 0)
{
lblInterestID.Text = Convert.ToString(dt.Rows[0]["INT_ID"]);
rcmb_FinancialYear.SelectedIndex = rcmb_FinancialYear.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["INT_PERIOD_ID"]));
rtxt_Registered.Text = Convert.ToString(dt.Rows[0]["INT_REGISTERED_AMT"]);
rtxt_UnRegistered.Text = Convert.ToString(dt.Rows[0]["INT_UNREGISTERED_AMT"]);
rtxt_Normal.Text = Convert.ToString(dt.Rows[0]["INT_NORMAL_AMT"]);
}
else
{
ClearControls();
}
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
btn_Save.Visible = false;
RMP_IntrstOnRegstUnRegstAcct.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IntrstOnRegUnRegAcct", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadGrid()
{
try
{
SMHR_PENSION_INT_REG_UNREG objPensionInt = new SMHR_PENSION_INT_REG_UNREG();
objPensionInt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
objPensionInt.OPERATION = operation.Select;
DataTable dtPensionInt = BLL.get_PensionIntOnRegtUnRegtAmt(objPensionInt);
Rg_IntrstOnRegstUnRegstAcct.DataSource = dtPensionInt;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IntrstOnRegUnRegAcct", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (rcmb_FinancialYear.SelectedIndex <= 0)
{
BLL.ShowMessage(this, "Please Select Financial Year");
return;
}
SMHR_PENSION_INT_REG_UNREG _objPensionInt = new SMHR_PENSION_INT_REG_UNREG();
_objPensionInt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_objPensionInt.INT_PERIOD_ID = Convert.ToInt32(rcmb_FinancialYear.SelectedValue);
_objPensionInt.INT_REGISTERED_AMT = Convert.ToDecimal(rtxt_Registered.Text);
_objPensionInt.INT_UNREGISTERED_AMT = Convert.ToDecimal(rtxt_UnRegistered.Text);
_objPensionInt.INT_NORMAL_AMT = Convert.ToDecimal(rtxt_Normal.Text);
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SAVE":
//To check if similar record exists
_objPensionInt.OPERATION = operation.Check;
if (BLL.set_PensionIntOnRegtUnRegtAcct(_objPensionInt))
{
BLL.ShowMessage(this, "Record already exists with similar data");
return;
}
_objPensionInt.OPERATION = operation.Insert;
_objPensionInt.CREATEDBY = Convert.ToInt32(Session["User_ID"]);
_objPensionInt.CREATEDDATE = DateTime.Now;
if (BLL.set_PensionIntOnRegtUnRegtAcct(_objPensionInt))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_UPDATE":
_objPensionInt.OPERATION = operation.Update;
_objPensionInt.INT_ID = Convert.ToInt32(lblInterestID.Text);
_objPensionInt.CREATEDBY = Convert.ToInt32(Session["User_ID"]);
_objPensionInt.CREATEDDATE = DateTime.Now;
if (BLL.set_PensionIntOnRegtUnRegtAcct(_objPensionInt))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
default:
break;
}
RMP_IntrstOnRegstUnRegstAcct.SelectedIndex = 0;
ClearControls();
LoadGrid();
Rg_IntrstOnRegstUnRegstAcct.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IntrstOnRegUnRegAcct", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
