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