public int CreateInsuranceAccount(InsuranceVo insuranceVo, int userId)
{
InsuranceDao insuranceDao = new InsuranceDao();
int id = 0;
try
{
id = insuranceDao.CreateInsuranceAccount(insuranceVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateInsuranceAccount()");
object[] objects = new object[2];
objects[0] = insuranceVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(id);
}
public bool UpdateInsurancePortfolio(InsuranceVo insuranceVo, int userId)
{
bool bResult = false;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
bResult = insuranceDao.UpdateInsurancePortfolio(insuranceVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:UpdateInsurancePortfolio()");
object[] objects = new object[2];
objects[0] = insuranceVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public InsuranceVo GetInsuranceAsset(int insurancePortfolioId)
{
InsuranceDao insuranceDao = new InsuranceDao();
InsuranceVo insuranceVo = new InsuranceVo();
try
{
insuranceVo = insuranceDao.GetInsuranceAsset(insurancePortfolioId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetInsuranceAsset()");
object[] objects = new object[1];
objects[0] = insurancePortfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(insuranceVo);
}
protected void hiddenassociation_Click(object sender, EventArgs e)
{
string val = Convert.ToString(hdnMsgValue.Value);
if (val == "1")
{
bool DeleteAccount;
CustomerVo customervo = (CustomerVo)Session["customerVo"];
int Account = customervo.CustomerId;
InsuranceVo insuranceVo = (InsuranceVo)Session["insuranceId"];
int InsuranceNo = insuranceVo.AccountId;
//int Insurance = Session ;
CustomerPortfolioBo BoCustomerPortfolio = new CustomerPortfolioBo();
DeleteAccount = BoCustomerPortfolio.DeleteGIAccount(Account, InsuranceNo);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('ViewGeneralInsuranceDetails','none');", true);
}
if (val == "0")
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('ViewGeneralInsuranceDetails','none');", true);
}
}
//protected void ddlPortfolio_SelectedIndexChanged(object sender, EventArgs e)
//{
// portfolioId = int.Parse(ddlPortfolio.SelectedValue.ToString());
// Session[SessionContents.PortfolioId] = portfolioId;
// BindGeneralInsuranceGridview(portfolioId);
//}
protected void ddlMenu_SelectedIndexChanged(object sender, EventArgs e)
{
int insuranceId;
string qryString = null;
try
{
DropDownList ddlAction = (DropDownList)sender;
GridViewRow gvr = (GridViewRow)ddlAction.NamingContainer;
int selectedRow = gvr.RowIndex;
int.TryParse(gvGeneralInsurance.DataKeys[selectedRow].Value.ToString(), out insuranceId);
int Insurance = insuranceId;
// insuranceId;
//// Set the VO into the Session
//insuranceVo = insuranceBo.GetInsuranceAsset(insuranceId);
InsuranceVo insuranceVo = new InsuranceVo();
insuranceVo.AccountId = insuranceId;
Session["insuranceId"] = insuranceVo;
//Session["customerAccountVo"] = customerAccountsBo.GetCustomerInsuranceAccount(insuranceVo.AccountId);
if (ddlAction.SelectedItem.Value.ToString() == "Edit")
{
qryString = "FromPage=ViewGeneralInsuranceDetails&InsuranceId=" + insuranceId + "&action=Edit";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioGeneralInsuranceEntry','" + qryString + "');", true);
}
else if (ddlAction.SelectedItem.Value.ToString() == "View")
{
qryString = "FromPage=ViewGeneralInsuranceDetails&InsuranceId=" + insuranceId + "&action=View";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioGeneralInsuranceEntry','" + qryString + "');", true);
}
if (ddlAction.SelectedItem.Value.ToString() == "Delete")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Message", "showmessage();", true);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewGeneralInsuranceDetails.ascx:ddlMenu_SelectedIndexChanged()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void ddlMenu_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//DropDownList ddlAction = (DropDownList)sender;
RadComboBox ddlAction = (RadComboBox)sender;
GridDataItem gvr = (GridDataItem)ddlAction.NamingContainer;
//GridViewRow gvr = (GridViewRow)ddlAction.NamingContainer;
int selectedRow = gvr.ItemIndex + 1;
int insuranceId = int.Parse(gvrLifeInsurance.MasterTableView.DataKeyValues[selectedRow - 1]["InsuranceId"].ToString());
DataTable dtAssociationId = new DataTable();
// Set the VO into the Session
insuranceVo = insuranceBo.GetInsuranceAssetLI(insuranceId, out dtAssociationId);
Session["dtAssociationId"] = dtAssociationId;
Session["insuranceVo"] = insuranceVo;
Session["customerAccountVo"] = customerAccountsBo.GetCustomerInsuranceAccount(insuranceVo.AccountId);
if (ddlAction.SelectedItem.Value.ToString() == "Edit")
{
Session.Remove("table");
Session.Remove("moneyBackEpisodeList");
Session.Remove("insuranceULIPList");
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioInsuranceEntry','action=edit');", true);
}
if (ddlAction.SelectedItem.Value.ToString() == "View")
{
Session.Remove("table");
Session.Remove("moneyBackEpisodeList");
Session.Remove("insuranceULIPList");
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioInsuranceEntry','action=view');", true);
}
if (ddlAction.SelectedItem.Value.ToString() == "Delete")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Message", "showmessage();", true);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewInsuranceDetails.ascx:ddlMenu_SelectedIndexChanged()");
object[] objects = new object[1];
objects[0] = insuranceVo;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void lnkLifeInsurancePolicy_Click(object sender, EventArgs e)
{
GridViewRow gvRow = ((GridViewRow)(((LinkButton)sender).Parent.Parent));
int rowIndex = gvRow.RowIndex;
DataKey dk = gvLifeInsurance.DataKeys[rowIndex];
int insuranceId = Convert.ToInt32(dk.Value);
DataTable dtAssociationId = new DataTable();
//insuranceVo = insuranceBo.GetInsuranceAsset(insuranceId);
insuranceVo = insuranceBo.GetInsuranceAssetLI(insuranceId, out dtAssociationId);
Session["dtAssociationId"] = dtAssociationId;
Session["insuranceVo"] = insuranceVo;
Session["customerAccountVo"] = customerAccountsBo.GetCustomerInsuranceAccount(insuranceVo.AccountId);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioInsuranceEntry','action=view');", true);
}
private void SortGridVIew(string sortExpression, string direction)
{
List <InsuranceVo> insuranceList = new List <InsuranceVo>();
try
{
// int count;
insuranceList = insuranceBo.GetInsurancePortfolio(portfolioId, hdnSort.Value.Trim());
//if (count > 0)
//{
// //lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
// //tblPager.Visible = true;
//}
InsuranceVo insuranceVo;
DataTable dtInsurance = new DataTable();
dtInsurance.Columns.Add("SI.No");
dtInsurance.Columns.Add("InsuranceId");
dtInsurance.Columns.Add("Category");
dtInsurance.Columns.Add("Particulars");
dtInsurance.Columns.Add("Premium Amount");
dtInsurance.Columns.Add("Sum Assured");
dtInsurance.Columns.Add("Maturity Value");
DataRow drInsurance;
for (int i = 0; i < insuranceList.Count; i++)
{
drInsurance = dtInsurance.NewRow();
insuranceVo = new InsuranceVo();
insuranceVo = insuranceList[i];
drInsurance[0] = insuranceVo.CustInsInvId.ToString();
drInsurance[1] = insuranceVo.AssetInstrumentCategoryCode.ToString();
drInsurance[2] = insuranceVo.Name.ToString();
drInsurance[3] = String.Format("{0:n2}", decimal.Parse(insuranceVo.PremiumAmount.ToString("N0")));
drInsurance[4] = String.Format("{0:n0}", decimal.Parse(insuranceVo.SumAssured.ToString("N0")));
drInsurance[5] = String.Format("{0:n2}", decimal.Parse(insuranceVo.MaturityValue.ToString("N0")));
dtInsurance.Rows.Add(drInsurance);
}
DataView dv = new DataView(dtInsurance);
dv.Sort = sortExpression + direction;
gvrLifeInsurance.DataSource = dv;
gvrLifeInsurance.DataBind();
if (Cache["LIList" + customerVo.CustomerId.ToString()] == null)
{
Cache.Insert("LIList" + customerVo.CustomerId.ToString(), dtInsurance);
}
else
{
Cache.Remove("LIList" + customerVo.CustomerId.ToString());
Cache.Insert("LIList" + customerVo.CustomerId.ToString(), dtInsurance);
}
gvrLifeInsurance.Visible = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewInsuranceDetails.ascx:SortGridVIew()");
object[] objects = new object[2];
objects[0] = insuranceVo;
objects[1] = insuranceList;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void LoadGridview(int portfolioId)
{
List <InsuranceVo> insuranceList = new List <InsuranceVo>();
try
{
//int count;
insuranceList = insuranceBo.GetInsurancePortfolio(portfolioId, hdnSort.Value);
#region unused
//if (count > 0)
//{
// //lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
// //tblPager.Visible = true;
// //trPager.Visible = true;
//}
//else
//{
// ErrorMessage.Visible = true;
// //tblPager.Visible = false;
// //trPager.Visible = false;
//}
#endregion
int RecordsCount = 0;
if (insuranceList != null)
{
RecordsCount = insuranceList.Count;
}
if (RecordsCount > 0)
{
btnExportFilteredData.Visible = true;
ErrorMessage.Visible = false;
//trPager.Visible = true;
InsuranceVo insuranceVo;
DataTable dtInsurance = new DataTable();
//dtInsurance.Columns.Add("SI.No");
dtInsurance.Columns.Add("InsuranceId");
dtInsurance.Columns.Add("Category");
dtInsurance.Columns.Add("Particulars");
dtInsurance.Columns.Add("CINP_SumAssured", typeof(double));
dtInsurance.Columns.Add("Premium Amount", typeof(double));
dtInsurance.Columns.Add("Commencement Date", typeof(DateTime));
dtInsurance.Columns.Add("Maturity Value", typeof(double));
dtInsurance.Columns.Add("Maturity Date", typeof(DateTime));
dtInsurance.Columns.Add("Insurance Company");
dtInsurance.Columns.Add("XII_InsuranceIssuerName");
//dtInsurance.Columns.Add("CINP_FirstPremiumDate");
dtInsurance.Columns.Add("Next Due Date", typeof(DateTime));
dtInsurance.Columns.Add("XF_Frequency");
dtInsurance.Columns.Add("PolicyNo");
dtInsurance.Columns.Add("Amount", typeof(double));
dtInsurance.Columns.Add("ModeOfPayment");
dtInsurance.Columns.Add("PaymentInstrumentNumber");
dtInsurance.Columns.Add("PaymentInstrumentDate", typeof(DateTime));
dtInsurance.Columns.Add("BankName");
dtInsurance.Columns.Add("BankBranch");
DataRow drInsurance;
for (int i = 0; i < insuranceList.Count; i++)
{
drInsurance = dtInsurance.NewRow();
insuranceVo = new InsuranceVo();
insuranceVo = insuranceList[i];
//drInsurance[0] = (i + 1).ToString();
drInsurance["InsuranceId"] = insuranceVo.CustInsInvId.ToString();
drInsurance["Category"] = insuranceVo.AssetInstrumentCategoryName.ToString();
drInsurance["Particulars"] = insuranceVo.Name.ToString();
if (insuranceVo.SumAssured.ToString() != "")
{
drInsurance["CINP_SumAssured"] = insuranceVo.SumAssured;
}
if (insuranceVo.PremiumAmount.ToString() != "")
{
drInsurance["Premium Amount"] = insuranceVo.PremiumAmount;
}
DateTime dtNow = DateTime.Now;
#region unused
//DateTime dtPremiumPayDate;
//********************************************************************************************************************
//Code Commented as the premium date is not displayed properly in the grid. Instead adding Commencement date as of now
//********************************************************************************************************************
//int premiumPayDate = insuranceVo.PremiumPaymentDate;
//if (premiumPayDate != 0)
//{
// dtPremiumPayDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
// DateTime premiumPayDate1 = dtPremiumPayDate.AddDays(premiumPayDate - 1);
// // Compare the two date time values
// // Less than 0 -- dtNow is earlier than dtPremiumPayDate
// // Greater than 0 -- dtNow is later than dtPremiumPayDate
// // Equal to 0 -- dtNow is equal to dtPremiumPayDate
// int compare = DateTime.Compare(dtNow, dtPremiumPayDate);
// switch (insuranceVo.PremiumFrequencyCode.ToString())
// {
// case "AM":
// drInsurance[5] = "N/A";
// break;
// case "DA":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "FN":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(15);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "HY":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(6);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "MN":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "NA":
// drInsurance[5] = "N/A";
// break;
// case "QT":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(3);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "WK":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(7);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "YR":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddYears(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// }
//}
//else
//{
// drInsurance[5] = "";
//}
#endregion
drInsurance["Commencement Date"] = insuranceVo.StartDate.ToShortDateString();
if (insuranceVo.MaturityValue.ToString() != "")
{
drInsurance["Maturity Value"] = insuranceVo.MaturityValue;
}
drInsurance["Maturity Date"] = insuranceVo.EndDate.ToShortDateString();
drInsurance["Insurance Company"] = insuranceVo.AssetInstrumentCategoryName;
drInsurance["XII_InsuranceIssuerName"] = insuranceVo.InsuranceIssuerName;
drInsurance["XF_Frequency"] = insuranceVo.Frequency;
drInsurance["PolicyNo"] = insuranceVo.PolicyNumber;
if (insuranceVo.Amount.ToString() != "")
{
drInsurance["Amount"] = insuranceVo.Amount;
}
if (insuranceVo.PaymentInstrumentDate != DateTime.MinValue)
{
drInsurance["PaymentInstrumentDate"] = insuranceVo.PaymentInstrumentDate;
}
drInsurance["ModeOfPayment"] = insuranceVo.ModeOfPayment.ToString();
drInsurance["PaymentInstrumentNumber"] = insuranceVo.PaymentInstrumentNumber;
drInsurance["BankName"] = insuranceVo.BankName;
drInsurance["BankBranch"] = insuranceVo.BankBranch;
string frequency = "";
DateTime startDate = insuranceVo.FirstPremiumDate;
DateTime endDate = DateTime.Parse(drInsurance["Maturity Date"].ToString());
frequency = insuranceVo.PremiumFrequencyCode;
DateTime nextPremiumDate = GetNextPremiumDate(frequency, startDate, endDate);
if (nextPremiumDate != DateTime.MinValue)
{
drInsurance["Next Due Date"] = nextPremiumDate.ToShortDateString();
}
else
{
//drLifeInsurance["NextPremiumDate"] = "---";
}
dtInsurance.Rows.Add(drInsurance);
}
gvrLifeInsurance.DataSource = dtInsurance;
gvrLifeInsurance.DataBind();
gvrLifeInsurance.Visible = true;
if (Cache["LIList" + customerVo.CustomerId.ToString()] == null)
{
Cache.Insert("LIList" + customerVo.CustomerId.ToString(), dtInsurance);
}
else
{
Cache.Remove("LIList" + customerVo.CustomerId.ToString());
Cache.Insert("LIList" + customerVo.CustomerId.ToString(), dtInsurance);
}
//this.GetPageCount();
}
else
{
gvrLifeInsurance.DataSource = null;
gvrLifeInsurance.DataBind();
ErrorMessage.Visible = true;
gvrLifeInsurance.Visible = false;
//trPager.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewInsuranceDetails.ascx:LoadGridview()");
object[] objects = new object[3];
objects[0] = insuranceList;
objects[1] = portfolioId;
objects[2] = insuranceVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void LoadGridview(int portfolioId)
{
List <InsuranceVo> insuranceList = new List <InsuranceVo>();
try
{
int count;
insuranceList = insuranceBo.GetInsurancePortfolio(portfolioId, mypager.CurrentPage, hdnSort.Value, out count);
if (count > 0)
{
lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
tblPager.Visible = true;
trPager.Visible = true;
}
else
{
ErrorMessage.Visible = true;
tblPager.Visible = false;
trPager.Visible = false;
}
int RecordsCount = 0;
if (insuranceList != null)
{
RecordsCount = insuranceList.Count;
}
if (RecordsCount > 0)
{
ErrorMessage.Visible = false;
trPager.Visible = true;
InsuranceVo insuranceVo;
DataTable dtInsurance = new DataTable();
//dtInsurance.Columns.Add("SI.No");
dtInsurance.Columns.Add("InsuranceId");
dtInsurance.Columns.Add("Category");
dtInsurance.Columns.Add("Particulars");
dtInsurance.Columns.Add("Sum Assured");
dtInsurance.Columns.Add("Premium Amount");
dtInsurance.Columns.Add("Commencement Date");
dtInsurance.Columns.Add("Maturity Value");
dtInsurance.Columns.Add("Maturity Date");
DataRow drInsurance;
for (int i = 0; i < insuranceList.Count; i++)
{
drInsurance = dtInsurance.NewRow();
insuranceVo = new InsuranceVo();
insuranceVo = insuranceList[i];
//drInsurance[0] = (i + 1).ToString();
drInsurance[0] = insuranceVo.CustInsInvId.ToString();
drInsurance[1] = insuranceVo.AssetInstrumentCategoryName.ToString();
drInsurance[2] = insuranceVo.Name.ToString();
drInsurance[3] = String.Format("{0:n0}", decimal.Parse(insuranceVo.SumAssured.ToString("f0")));
drInsurance[4] = String.Format("{0:n2}", decimal.Parse(insuranceVo.PremiumAmount.ToString("f2")));
DateTime dtNow = DateTime.Now;
//DateTime dtPremiumPayDate;
//********************************************************************************************************************
//Code Commented as the premium date is not displayed properly in the grid. Instead adding Commencement date as of now
//********************************************************************************************************************
//int premiumPayDate = insuranceVo.PremiumPaymentDate;
//if (premiumPayDate != 0)
//{
// dtPremiumPayDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
// DateTime premiumPayDate1 = dtPremiumPayDate.AddDays(premiumPayDate - 1);
// // Compare the two date time values
// // Less than 0 -- dtNow is earlier than dtPremiumPayDate
// // Greater than 0 -- dtNow is later than dtPremiumPayDate
// // Equal to 0 -- dtNow is equal to dtPremiumPayDate
// int compare = DateTime.Compare(dtNow, dtPremiumPayDate);
// switch (insuranceVo.PremiumFrequencyCode.ToString())
// {
// case "AM":
// drInsurance[5] = "N/A";
// break;
// case "DA":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "FN":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(15);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "HY":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(6);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "MN":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "NA":
// drInsurance[5] = "N/A";
// break;
// case "QT":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddMonths(3);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "WK":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddDays(7);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// case "YR":
// if (compare < 0)
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else if (compare > 0)
// { // Calculate the Next Payment Date and display it
// dtPremiumPayDate.AddYears(1);
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// else
// { // Display the Premium Payment Date
// drInsurance[5] = dtPremiumPayDate.ToShortDateString();
// }
// break;
// }
//}
//else
//{
// drInsurance[5] = "";
//}
drInsurance[5] = insuranceVo.StartDate.ToShortDateString();
drInsurance[6] = String.Format("{0:n2}", decimal.Parse(insuranceVo.MaturityValue.ToString("f2")));
drInsurance[7] = insuranceVo.EndDate.ToShortDateString();
dtInsurance.Rows.Add(drInsurance);
}
gvrLifeInsurance.DataSource = dtInsurance;
gvrLifeInsurance.DataBind();
gvrLifeInsurance.Visible = true;
this.GetPageCount();
}
else
{
gvrLifeInsurance.DataSource = null;
gvrLifeInsurance.DataBind();
ErrorMessage.Visible = true;
trPager.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewInsuranceDetails.ascx:LoadGridview()");
object[] objects = new object[3];
objects[0] = insuranceList;
objects[1] = portfolioId;
objects[2] = insuranceVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
