protected void btnSave_Click(object sender, EventArgs e)
{
try
{
//if (rcmb_Relation.SelectedIndex <= 0)
//{
// BLL.ShowMessage(this, "Please Select Relation");
// return;
//}
if (rtxt_Amount.Value <= 0)
{
BLL.ShowMessage(this, "Insufficient Pension Balance");
return;
}
SMHR_PENSION_WITHDRAWL objPensionWithdrwl = new SMHR_PENSION_WITHDRAWL();
objPensionWithdrwl.WITHDRAWL_WITHDRAWLAMOUNT = Convert.ToDouble(rtxt_Amount.Value);
if (trPayItem.Visible == true)
{
objPensionWithdrwl.WITHDRAWL_PAYITEMID = Convert.ToInt32(rcmb_PayItem.SelectedValue);
}
objPensionWithdrwl.WITHDRAWL_FFS_ID = Convert.ToInt32(hdnFFSID.Value);
objPensionWithdrwl.WITHDRAWL_SETTLEMENTTYPE = Convert.ToInt32(rcmb_SettlementType.SelectedValue);
objPensionWithdrwl.WITHDRAWL_SETTLEMENTDATE = Convert.ToDateTime(rdtpSettlementDate.SelectedDate);
objPensionWithdrwl.WITHDRAWL_BENEFICIARY = Convert.ToString(rtxt_Beneficiary.Text);
objPensionWithdrwl.WITHDRAWL_BALANCE = Convert.ToDouble(rtxt_TotPensionAmt.Value) - Convert.ToDouble(rtxt_AmtDisbursed.Value) - Convert.ToDouble(rtxt_Amount.Value);
objPensionWithdrwl.WITHDRAWL_RELATIONTYPE = Convert.ToInt32(rcmb_Relation.SelectedValue);
objPensionWithdrwl.WITHDRAWL_WITHDRAWLTYPE = Convert.ToString(rcmb_WithdrawlType.SelectedValue);
objPensionWithdrwl.OPERATION = operation.Insert;
if (BLL.set_PENSION_WITHDRAWL(objPensionWithdrwl))
{
BLL.ShowMessage(this, "Information Saved Successfully");
clearControls();
}
else
{
BLL.ShowMessage(this, "Error occured while processing");
clearControls();
}
LoadGrid();
RG_PensionFFS.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PensionFFS", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadGrid()
{
try
{
SMHR_PENSION_WITHDRAWL objPensionWithdrwl = new SMHR_PENSION_WITHDRAWL();
objPensionWithdrwl.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
objPensionWithdrwl.OPERATION = operation.Select;
DataTable dtPensioWithdrwl = BLL.get_PENSION_WITHDRAWL(objPensionWithdrwl);
RG_PensionFFS.DataSource = dtPensioWithdrwl;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PensionFFS", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnkWithdrawlEdit_Command(object sender, CommandEventArgs e)
{
try
{
clearControls();
EnableDisableContols(false);
rcmb_BusinessUnit.Items.Clear();
SMHR_PENSION_WITHDRAWL objPensionWithdrwl = new SMHR_PENSION_WITHDRAWL();
objPensionWithdrwl.WITHDRAWL_ID = Convert.ToInt32(e.CommandArgument);
objPensionWithdrwl.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
objPensionWithdrwl.OPERATION = operation.Edit;
DataTable dtPensionWithdrwl = BLL.get_PENSION_WITHDRAWL(objPensionWithdrwl);
if (dtPensionWithdrwl.Rows.Count > 0)
{
//To populate pension amounts
#region LoadPensionAmounts
SMHR_EMPLOYEE objEmployee = new SMHR_EMPLOYEE();
objEmployee.EMP_ID = Convert.ToInt32(dtPensionWithdrwl.Rows[0]["EMP_ID"]);
objEmployee.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
objEmployee.BUID = Convert.ToInt32(dtPensionWithdrwl.Rows[0]["EMP_BUSINESSUNIT_ID"]);
DataTable dtPensionAmt = BLL.get_PensionFNF(objEmployee);
if (dtPensionAmt.Rows.Count > 0)
{
rtxt_TotPensionAmt.Text = Convert.ToString(dtPensionAmt.Rows[0]["FFS_AMOUNT"]);
rtxt_AmtDisbursed.Text = Convert.ToString(dtPensionAmt.Rows[0]["WITHDRAWL"]);
rtxt_BalAmt.Text = Convert.ToString(dtPensionAmt.Rows[0]["WITHDRAWL_BALANCE"]);
//hdnFFSID.Value = Convert.ToString(dtPensionAmt.Rows[0]["FFS_ID"]);
//rtxt_Amount.MaxValue = Convert.ToDouble(dtPensionAmt.Rows[0]["WITHDRAWL_BALANCE"]);
}
else
{
rtxt_TotPensionAmt.Text = string.Empty;
rtxt_AmtDisbursed.Text = string.Empty;
rtxt_BalAmt.Text = string.Empty;
hdnFFSID.Value = null;
}
#endregion
rtxt_BalAmt.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_BALANCE"]);
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["BUSINESSUNIT_CODE"])))
{
rcmb_BusinessUnit.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["BUSINESSUNIT_CODE"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["DIRECTORATE_CODE"])))
{
rcmb_Directorate.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["DIRECTORATE_CODE"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["DEPARTMENT_NAME"])))
{
rcmb_Department.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["DEPARTMENT_NAME"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["EMP_NAME"])))
{
rcmb_Employee.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["EMP_NAME"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_WITHDRAWLTYPE"])))
{
//rcmb_WithdrawlType.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_WITHDRAWLTYPE"]);
rcmb_WithdrawlType.SelectedIndex = rcmb_WithdrawlType.FindItemIndexByValue(Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_WITHDRAWLTYPE"]));
if (string.Compare(Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_WITHDRAWLTYPE"]), "Family", true) == 0)
{
trRelation.Visible = true;
}
else
{
trRelation.Visible = false;
}
}
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["RELATION"])))
{
rcmb_Relation.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["RELATION"]);
}
rtxt_Beneficiary.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_BENEFICIARY"]);
if (!string.IsNullOrEmpty(Convert.ToString(dtPensionWithdrwl.Rows[0]["SETTLEMENT_TYPE"])))
{
rcmb_SettlementType.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["SETTLEMENT_TYPE"]);
}
rtxt_Amount.Text = Convert.ToString(dtPensionWithdrwl.Rows[0]["WITHDRAWL_WITHDRAWLAMOUNT"]);
rdtpSettlementDate.SelectedDate = Convert.ToDateTime(dtPensionWithdrwl.Rows[0]["WITHDRAWL_SETTLEMENTDATE"]);
Rm_CY_page.SelectedIndex = 1;
}
else
{
clearControls();
Rm_CY_page.SelectedIndex = 0;
BLL.ShowMessage(this, "No data found");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PensionFFS", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
