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