public bool UpdatePensionAndGratuities(PensionAndGratuitiesVo pensionAndGratuitiesVo, int userId) { bool bResult = false; PensionAndGratuitiesDao pensionAndGratuitiesDao = new PensionAndGratuitiesDao(); try { bResult = pensionAndGratuitiesDao.UpdatePensionAndGratuities(pensionAndGratuitiesVo, userId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PensionAndGratuitiesBo.cs:UpdatePensionAndGratuities()"); object[] objects = new object[2]; objects[0] = pensionAndGratuitiesVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
public PensionAndGratuitiesVo GetPensionAndGratuities(int portfolioId) { PensionAndGratuitiesDao pensionAndGratuitiesDao = new PensionAndGratuitiesDao(); PensionAndGratuitiesVo pensionAndGratuitiesVo = new PensionAndGratuitiesVo(); try { pensionAndGratuitiesVo = pensionAndGratuitiesDao.GetPensionAndGratuities(portfolioId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PensionAndGratuitiesBo.cs:GetPensionAndGratuities()"); object[] objects = new object[1]; objects[0] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(pensionAndGratuitiesVo); }
protected void Page_Load(object sender, EventArgs e) { try { SessionBo.CheckSession(); pensionAndGratuitiesVo = (PensionAndGratuitiesVo)Session["pensionAndGratuities"]; ShowPensionDetails(); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewPensionDetails.cs:Page_Load()"); object[] objects = new object[1]; objects[0] = pensionAndGratuitiesVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
protected void Button1_Click(object sender, EventArgs e) { PensionAndGratuitiesBo pensionAndGratuitiesBo = new PensionAndGratuitiesBo(); PensionAndGratuitiesVo pensionAndGratuitiesVo = new PensionAndGratuitiesVo(); pensionAndGratuitiesVo.AccountId = int.Parse(ddlAccountId.SelectedItem.Text.ToString()); //pensionAndGratuitiesVo.AssetGroupCode = ddlAssetGroupCode.SelectedItem.Text.ToString(); pensionAndGratuitiesVo.AssetGroupCode = "Pension"; pensionAndGratuitiesVo.InterestBasis = ddlInterestBasis.SelectedItem.Value.ToString(); if (pensionAndGratuitiesVo.InterestBasis == "SI") { pensionAndGratuitiesVo.InterestPayableFrequencyCode = ddlSIFrequencyCode.SelectedItem.Value.ToString(); } else { pensionAndGratuitiesVo.CompoundInterestFrequencyCode = ddlCIInterestFrequencyCode.SelectedItem.Value.ToString(); } pensionAndGratuitiesVo.AssetInstrumentCategoryCode = ddlCategory.SelectedItem.Text.ToString(); pensionAndGratuitiesVo.CurrentValue = float.Parse(txtCurrentValue.Text); pensionAndGratuitiesVo.DebtIssuerCode = ddlDebtIssuerCode.SelectedItem.Text.ToString(); pensionAndGratuitiesVo.DepositAmount = float.Parse(txtDepositAmount.Text); pensionAndGratuitiesVo.FiscalYearCode = ddlFiscalYearCode.SelectedItem.Text.ToString(); if (rbtnAccumulated.Checked) { pensionAndGratuitiesVo.IsInterestAccumalated = 1; } else { pensionAndGratuitiesVo.IsInterestAccumalated = 0; } if (pensionAndGratuitiesVo.IsInterestAccumalated == 1) { pensionAndGratuitiesVo.InterestAmtAccumalated = float.Parse(txtAmountAccumulated.Text); pensionAndGratuitiesVo.InterestAmtPaidOut = 0; } else { pensionAndGratuitiesVo.InterestAmtPaidOut = float.Parse(txtAmountPaidout.Text); pensionAndGratuitiesVo.InterestAmtAccumalated = 0; } // pensionAndGratuitiesVo.InterestPayableFrequencyCode = ddlInterestPayableFrequencyCode.SelectedItem.Text.ToString(); pensionAndGratuitiesVo.InterestRate = float.Parse(txtInterstRate.Text); pensionAndGratuitiesVo.LoanEndDate = DateTime.Parse(ddlLoanEndDay.SelectedItem.Value.ToString() + "/" + ddlLoanEndMonth.SelectedItem.Value.ToString() + "/" + ddlLoanEndYear.SelectedItem.Value.ToString()); pensionAndGratuitiesVo.LoanOutstandingAmount = float.Parse(txtLoanOutstandingAmount.Text); pensionAndGratuitiesVo.LoanStartDate = DateTime.Parse(ddlLoanStartDay.SelectedItem.Value.ToString() + "/" + ddlLoanStartMonth.SelectedItem.Value.ToString() + "/" + ddlLoanStartYear.SelectedItem.Value.ToString()); pensionAndGratuitiesVo.MaturityDate = DateTime.Parse(ddlMaturityDay.SelectedItem.Value.ToString() + "/" + ddlMaturityMonth.SelectedItem.Value.ToString() + "/" + ddlMaturityYear.SelectedItem.Value.ToString()); pensionAndGratuitiesVo.MaturityValue = float.Parse(txtMaturityValue.Text); pensionAndGratuitiesVo.OrganizationName = txtOrganizationName.Text; pensionAndGratuitiesVo.PurchaseDate = DateTime.Parse(ddlPurchaseDay.SelectedItem.Value.ToString() + "/" + ddlProductMonth.SelectedItem.Value.ToString() + "/" + ddlProductYear.SelectedItem.Value.ToString()); pensionAndGratuitiesBo.CreatePensionAndGratuities(pensionAndGratuitiesVo, userVo.UserId); }
protected void ddlMenu_SelectedIndexChanged(object sender, EventArgs e) { string menu; try { DropDownList MyDropDownList = (DropDownList)sender; GridViewRow gvr = (GridViewRow)MyDropDownList.NamingContainer; int selectedRow = gvr.RowIndex; portfolioId = int.Parse(gvrPensionAndGratuities.DataKeys[selectedRow].Value.ToString()); pensionAndGratuitiesVo = pensionAndGratuitiesBo.GetPensionAndGratuities(portfolioId); Session["pensionAndGratuitiesVo"] = pensionAndGratuitiesVo; Session["customerAccountVo"] = customerAccountsBo.GetCustomerPensionAndGratuitiesAccount(pensionAndGratuitiesVo.AccountId); menu = MyDropDownList.SelectedItem.Value.ToString(); if (menu == "Edit") { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PensionAndGratuities','?action=edit');", true); } if (menu == "View") { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PensionAndGratuities','?action=view');", true); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PensionPortfolio.ascx:ddlMenu_SelectedIndexChanged()"); object[] objects = new object[3]; objects[0] = pensionAndGratuitiesBo; objects[1] = pensionAndGratuitiesVo; objects[2] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void LoadGridview(int portfolioId) { List <PensionAndGratuitiesVo> pensionAndGratuitiesList = new List <PensionAndGratuitiesVo>(); int count; try { pensionAndGratuitiesList = pensionAndGratuitiesBo.GetPensionAndGratuitiesList(portfolioId, mypager.CurrentPage, hdnSort.Value, out count); PensionAndGratuitiesVo pensionAndGratuitiesVo; if (count > 0) { lblTotalRows.Text = hdnRecordCount.Value = count.ToString(); tblPager.Visible = true; trTotalRows.Visible = true; } else { tblPager.Visible = false; trTotalRows.Visible = false; } if (pensionAndGratuitiesList != null) { lblMsg.Visible = false; DataTable dtPension = new DataTable(); //dtPension.Columns.Add("SI.No"); dtPension.Columns.Add("PortfolioId"); dtPension.Columns.Add("Organization Name"); dtPension.Columns.Add("Category"); dtPension.Columns.Add("Deposit Amount"); dtPension.Columns.Add("Current Value"); DataRow drPension; for (int i = 0; i < pensionAndGratuitiesList.Count; i++) { drPension = dtPension.NewRow(); pensionAndGratuitiesVo = new PensionAndGratuitiesVo(); pensionAndGratuitiesVo = pensionAndGratuitiesList[i]; //drPension[0] = (i + 1).ToString(); drPension[0] = pensionAndGratuitiesVo.PensionGratuitiesPortfolioId.ToString(); drPension[1] = pensionAndGratuitiesVo.OrganizationName.ToString(); drPension[2] = pensionAndGratuitiesVo.AssetInstrumentCategoryName.ToString(); drPension[3] = String.Format("{0:n2}", decimal.Parse(pensionAndGratuitiesVo.DepositAmount.ToString("f2"))); drPension[4] = String.Format("{0:n2}", decimal.Parse(pensionAndGratuitiesVo.CurrentValue.ToString("f2"))); dtPension.Rows.Add(drPension); } gvrPensionAndGratuities.DataSource = dtPension; gvrPensionAndGratuities.DataBind(); gvrPensionAndGratuities.Visible = true; this.GetPageCount(); } else { gvrPensionAndGratuities.DataSource = null; gvrPensionAndGratuities.DataBind(); lblMsg.Visible = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PortfolioViewDashboard.ascx.cs:LoadGridview()"); object[] objects = new object[2]; objects[0] = pensionAndGratuitiesList; objects[1] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public PensionAndGratuitiesVo GetPensionAndGratuities(int portfolioId) { PensionAndGratuitiesVo pensionAndGratuitiesVo = null; Database db; DbCommand getPensionAndGratuitiesCmd; DataSet getPensionAndGratuitiesDs; DataRow dr; try { db = DatabaseFactory.CreateDatabase("wealtherp"); getPensionAndGratuitiesCmd = db.GetStoredProcCommand("SP_GetPensionAndGratuities"); db.AddInParameter(getPensionAndGratuitiesCmd, "@CPGNP_PensionGratutiesNPId", DbType.Int32, portfolioId); getPensionAndGratuitiesDs = db.ExecuteDataSet(getPensionAndGratuitiesCmd); if (getPensionAndGratuitiesDs.Tables[0].Rows.Count > 0) { pensionAndGratuitiesVo = new PensionAndGratuitiesVo(); dr = getPensionAndGratuitiesDs.Tables[0].Rows[0]; pensionAndGratuitiesVo.PensionGratuitiesPortfolioId = Int32.Parse(dr["CPGNP_PensionGratutiesNPId"].ToString()); pensionAndGratuitiesVo.AccountId = int.Parse(dr["CPGA_AccountId"].ToString()); pensionAndGratuitiesVo.AssetInstrumentCategoryCode = dr["PAIC_AssetInstrumentCategoryCode"].ToString(); pensionAndGratuitiesVo.AssetGroupCode = dr["PAG_AssetGroupCode"].ToString(); pensionAndGratuitiesVo.FiscalYearCode = dr["XFY_FiscalYearCode"].ToString(); pensionAndGratuitiesVo.InterestPayableFrequencyCode = dr["XF_InterestPayableFrequencyCode"].ToString(); pensionAndGratuitiesVo.CompoundInterestFrequencyCode = dr["XF_CompoundInterestFrequencyCode"].ToString(); pensionAndGratuitiesVo.InterestRate = float.Parse(dr["CPGNP_InterestRate"].ToString()); pensionAndGratuitiesVo.OrganizationName = dr["CPGNP_OrganizationName"].ToString(); pensionAndGratuitiesVo.DepositAmount = float.Parse(dr["CPGNP_DepositAmount"].ToString()); pensionAndGratuitiesVo.CurrentValue = float.Parse(dr["CPGNP_CurrentValue"].ToString()); pensionAndGratuitiesVo.InterestBasis = dr["XIB_InterestBasisCode"].ToString(); pensionAndGratuitiesVo.IsInterestAccumalated = int.Parse(dr["CPGNP_IsInterestAccumalated"].ToString()); pensionAndGratuitiesVo.InterestAmtAccumalated = float.Parse(dr["CPGNP_InterestAmtAccumalated"].ToString()); pensionAndGratuitiesVo.InterestAmtPaidOut = float.Parse(dr["CPGNP_InterestAmtPaidOut"].ToString()); if (dr["CPGNP_EmployeeContri"].ToString() != "") { pensionAndGratuitiesVo.EmployeeContribution = float.Parse(dr["CPGNP_EmployeeContri"].ToString()); } else { pensionAndGratuitiesVo.EmployeeContribution = 0; } if (dr["CPGNP_EmployerContri"].ToString() != "") { pensionAndGratuitiesVo.EmployerContribution = float.Parse(dr["CPGNP_EmployerContri"].ToString()); } else { pensionAndGratuitiesVo.EmployerContribution = 0; } if (dr["CPGNP_Remark"].ToString() != "") { pensionAndGratuitiesVo.Remarks = dr["CPGNP_Remark"].ToString(); } else { pensionAndGratuitiesVo.Remarks = ""; } } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PensionAndGratuitiesDao.cs:GetPensionAndGratuities()"); object[] objects = new object[1]; objects[0] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(pensionAndGratuitiesVo); }
public bool CreatePensionAndGratuities(PensionAndGratuitiesVo pensionAndGratuitiesVo, int userId) { bool bResult = false; Database db; DbCommand createPensionAndGratuitiesCmd; try { db = DatabaseFactory.CreateDatabase("wealtherp"); createPensionAndGratuitiesCmd = db.GetStoredProcCommand("SP_CreatePensionAndGratuities"); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGA_AccountId", DbType.Int32, pensionAndGratuitiesVo.AccountId); db.AddInParameter(createPensionAndGratuitiesCmd, "@PAIC_AssetInstrumentCategoryCode", DbType.String, pensionAndGratuitiesVo.AssetInstrumentCategoryCode); db.AddInParameter(createPensionAndGratuitiesCmd, "@PAG_AssetGroupCode", DbType.String, pensionAndGratuitiesVo.AssetGroupCode); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_OrganizationName", DbType.String, pensionAndGratuitiesVo.OrganizationName); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_DepositAmount", DbType.Double, pensionAndGratuitiesVo.DepositAmount); if (pensionAndGratuitiesVo.FiscalYearCode != "") { db.AddInParameter(createPensionAndGratuitiesCmd, "@XFY_FiscalYearCode", DbType.String, pensionAndGratuitiesVo.FiscalYearCode); } else { db.AddInParameter(createPensionAndGratuitiesCmd, "@XFY_FiscalYearCode", DbType.String, DBNull.Value); } db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_EmployeeContri", DbType.Double, pensionAndGratuitiesVo.EmployeeContribution); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_EmployerContri", DbType.Double, pensionAndGratuitiesVo.EmployerContribution); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_InterestRate", DbType.Double, pensionAndGratuitiesVo.InterestRate); if (pensionAndGratuitiesVo.InterestBasis != "") { db.AddInParameter(createPensionAndGratuitiesCmd, "@XIB_InterestBasisCode", DbType.String, pensionAndGratuitiesVo.InterestBasis); } else { db.AddInParameter(createPensionAndGratuitiesCmd, "@XIB_InterestBasisCode", DbType.String, DBNull.Value); } if (pensionAndGratuitiesVo.CompoundInterestFrequencyCode != "") { db.AddInParameter(createPensionAndGratuitiesCmd, "@XF_CompoundInterestFrequencyCode", DbType.String, pensionAndGratuitiesVo.CompoundInterestFrequencyCode); } else { db.AddInParameter(createPensionAndGratuitiesCmd, "@XF_CompoundInterestFrequencyCode", DbType.String, DBNull.Value); } if (pensionAndGratuitiesVo.InterestPayableFrequencyCode != "") { db.AddInParameter(createPensionAndGratuitiesCmd, "@XF_InterestPayableFrequencyCode", DbType.String, pensionAndGratuitiesVo.InterestPayableFrequencyCode); } else { db.AddInParameter(createPensionAndGratuitiesCmd, "@XF_InterestPayableFrequencyCode", DbType.String, DBNull.Value); } db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_IsInterestAccumalated", DbType.Int16, pensionAndGratuitiesVo.IsInterestAccumalated); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_InterestAmtAccumalated", DbType.Double, pensionAndGratuitiesVo.InterestAmtAccumalated); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_InterestAmtPaidOut", DbType.Double, pensionAndGratuitiesVo.InterestAmtPaidOut); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_CurrentValue", DbType.Double, pensionAndGratuitiesVo.CurrentValue); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_Remark", DbType.String, pensionAndGratuitiesVo.Remarks); db.AddInParameter(createPensionAndGratuitiesCmd, "@CPGNP_CreatedBy", DbType.Int32, userId); if (db.ExecuteNonQuery(createPensionAndGratuitiesCmd) != 0) { bResult = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PensionAndGratuitiesDao.cs:CreatePensionAndGratuities()"); object[] objects = new object[2]; objects[0] = pensionAndGratuitiesVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }