/// <summary>
/// Get all the liabilities of the customer
/// </summary>
/// <param name="customerIds"></param>
/// <returns></returns>
public DataSet GetLiabilities(string customerIds)
{
Database db;
DbCommand cmdGetLiabilities;
DataSet dsGetLiabilities;
int tempId = 0;
Calculator calculator = new Calculator();
List <LiabilitiesVo> liabilitiesVoList = new List <LiabilitiesVo>();
LiabilitiesVo liabilityVo = new LiabilitiesVo();
LiabilitiesBo liabilitiesBo = new LiabilitiesBo();
double liabilityValue = 0;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdGetLiabilities = db.GetStoredProcCommand("SP_RPT_GetLiabilities");
db.AddInParameter(cmdGetLiabilities, "@PortfolioIds", DbType.String, customerIds);
cmdGetLiabilities.CommandTimeout = 60 * 60;
dsGetLiabilities = db.ExecuteDataSet(cmdGetLiabilities);
if (dsGetLiabilities != null && dsGetLiabilities.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsGetLiabilities.Tables[0].Rows.Count; i++)
{
liabilityValue = 0;
liabilityVo = liabilitiesBo.GetLiabilityDetails(int.Parse(dsGetLiabilities.Tables[0].Rows[i]["CL_LiabilitiesId"].ToString()));
if (liabilityVo.PaymentOptionCode == 1)
{
liabilityValue = liabilityValue + calculator.GetLoanOutstanding(liabilityVo.CompoundFrequency, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 1, liabilityVo.LumpsumRepaymentAmount, liabilityVo.NoOfInstallments);
}
else if (liabilityVo.PaymentOptionCode == 2)
{
liabilityValue = liabilityValue + calculator.GetLoanOutstanding(liabilityVo.FrequencyCodeEMI, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 2, liabilityVo.EMIAmount, liabilityVo.NoOfInstallments);
}
else
{
liabilityValue = liabilityVo.LoanAmount;
}
dsGetLiabilities.Tables[0].Rows[i]["LoanAmount"] = liabilityValue.ToString();
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "LiabilitiesDao.cs:GetLiabilities()");
object[] objects = new object[1];
objects[0] = customerIds;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsGetLiabilities);
}
protected void ddlAction_SelectedIndexChanged(object sender, EventArgs e)
{
string menu;
int liabilityId = 0;
LiabilitiesVo liabilityVo = new LiabilitiesVo();
try
{
DropDownList MyDropDownList = (DropDownList)sender;
GridViewRow gvr = (GridViewRow)MyDropDownList.NamingContainer;
int selectedRow = gvr.RowIndex;
liabilityId = int.Parse(gvLiabilities.DataKeys[selectedRow].Value.ToString());
liabilityVo = liabilitiesBo.GetLiabilityDetails(liabilityId);
menu = MyDropDownList.SelectedItem.Value.ToString();
if (menu == "View")
{
Session["menu"] = "View";
Session["liabilityVo"] = liabilityVo;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('LiabilitiesMaintenanceForm','none');", true);
}
if (menu == "Edit")
{
Session["menu"] = "Edit";
Session["liabilityVo"] = liabilityVo;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('LiabilitiesMaintenanceForm','none');", true);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "LiabilityView.ascx:ddlMenu_SelectedIndexChanged()");
object[] objects = new object[2];
objects[1] = liabilityVo;
objects[2] = liabilityId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public double GetCustomerPortfolioLiability(int portfolioId)
{
double liabilityValue = 0;
AssetDao assetDao = new AssetDao();
Calculator calculator = new Calculator();
List <LiabilitiesVo> listLiabilitiesVo = new List <LiabilitiesVo>();
LiabilitiesVo liabilityVo = new LiabilitiesVo();
try
{
listLiabilitiesVo = assetDao.GetCustomerPortfolioLiability(portfolioId);
for (int i = 0; i < listLiabilitiesVo.Count; i++)
{
liabilityVo = new LiabilitiesVo();
liabilityVo = listLiabilitiesVo[i];
if (liabilityVo.PaymentOptionCode == 1)
{
liabilityValue = liabilityValue + calculator.GetLoanOutstanding(liabilityVo.CompoundFrequency, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 1, liabilityVo.LumpsumRepaymentAmount, liabilityVo.NoOfInstallments);
}
else if (liabilityVo.PaymentOptionCode == 2)
{
liabilityValue = liabilityValue + calculator.GetLoanOutstanding(liabilityVo.FrequencyCodeEMI, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 2, liabilityVo.EMIAmount, liabilityVo.NoOfInstallments);
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AssetBo.cs:GetCustomerPortfolioLiability(int portfolioId)");
object[] objects = new object[1];
objects[0] = portfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(liabilityValue);
}
protected void ddlAction_SelectedIndexChanged(object sender, EventArgs e)
{
string menu;
int liabilityId = 0;
LiabilitiesVo liabilityVo = new LiabilitiesVo();
try
{
RadComboBox MyDropDownList = (RadComboBox)sender;
GridDataItem gvr = (GridDataItem)MyDropDownList.NamingContainer;
int selectedRow = gvr.ItemIndex + 1;
liabilityId = int.Parse(gvLiabilities.MasterTableView.DataKeyValues[selectedRow - 1]["LiabilityId"].ToString());
liabilityVo = liabilitiesBo.GetLiabilityDetails(liabilityId);
hdndeleteId.Value = liabilityId.ToString();
menu = MyDropDownList.SelectedItem.Value.ToString();
if (menu == "View")
{
Session["menu"] = "View";
Session["liabilityVo"] = liabilityVo;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('LiabilitiesMaintenanceForm','none');", true);
}
if (menu == "Edit")
{
Session["menu"] = "Edit";
Session["liabilityVo"] = liabilityVo;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('LiabilitiesMaintenanceForm','none');", true);
}
if (menu == "Delete")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Message", "showmessage();", true);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
}
protected void BindGridview()
{
liabilitiesListVo = new List <LiabilitiesVo>();
LiabilitiesVo liabilityVo = new LiabilitiesVo();
liabilitiesListVo = liabilitiesBo.GetLiabilities(customerVo.CustomerId);
DataTable dt = new DataTable();
DataRow dr;
Double loanOutStanding = 0;
DateTime nextInsDate = new DateTime();
if (liabilitiesListVo != null)
{
lblMsg.Visible = false;
dt.Columns.Add("LiabilityId");
dt.Columns.Add("Loan Type");
dt.Columns.Add("Lender");
dt.Columns.Add("Amount");
dt.Columns.Add("Rate of Interest");
dt.Columns.Add("PaymentType");
dt.Columns.Add("LumpsusmInstallment");
dt.Columns.Add("LoanOutstanding");
dt.Columns.Add("NextInstallmentDate");
dt.Columns.Add("Frequency");
for (int i = 0; i < liabilitiesListVo.Count; i++)
{
dr = dt.NewRow();
liabilityVo = liabilitiesListVo[i];
dr[0] = liabilityVo.LiabilitiesId;
dr[1] = liabilityVo.LoanType.ToString();
dr[2] = liabilityVo.LoanPartner.ToString();
dr[3] = decimal.Parse(liabilityVo.LoanAmount.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
dr[4] = liabilityVo.RateOfInterest.ToString();
if (liabilityVo.PaymentOptionCode == 1)
{
dr[5] = "Lumpsum";
dr[6] = Math.Round(liabilityVo.LumpsumRepaymentAmount, 2).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
loanOutStanding = calculator.GetLoanOutstanding(liabilityVo.CompoundFrequency, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 1, liabilityVo.LumpsumRepaymentAmount, liabilityVo.NoOfInstallments);
dr[7] = Math.Round(loanOutStanding, 2).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
dr[8] = "-";
dr[9] = "-";
}
else if (liabilityVo.PaymentOptionCode == 2)
{
dr[5] = "Installment";
dr[6] = Math.Round(liabilityVo.EMIAmount, 2).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
loanOutStanding = calculator.GetLoanOutstanding(liabilityVo.FrequencyCodeEMI, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 2, liabilityVo.EMIAmount, liabilityVo.NoOfInstallments);
dr[7] = Math.Round(loanOutStanding, 2).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
nextInsDate = calculator.GetNextPremiumDate(liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, liabilityVo.FrequencyCodeEMI);
if (nextInsDate != DateTime.MinValue)
{
dr[8] = nextInsDate.ToLongDateString();
}
else
{
dr[8] = "-";
}
switch (liabilityVo.FrequencyCodeEMI)
{
case "MN":
dr[9] = "Monthly";
break;
case "QT":
dr[9] = "Quarterly";
break;
case "HY":
dr[9] = "Half Yearly";
break;
case "YR":
dr[9] = "Yearly";
break;
}
}
else
{
dr[5] = "-";
dr[6] = "-";
//loanOutStanding = calculator.GetLoanOutstanding(liabilityVo.FrequencyCodeEMI, liabilityVo.LoanAmount, liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, 2, liabilityVo.EMIAmount, liabilityVo.NoOfInstallments);
dr[7] = "-";
//nextInsDate = calculator.GetNextPremiumDate(liabilityVo.InstallmentStartDate, liabilityVo.InstallmentEndDate, liabilityVo.FrequencyCodeEMI);
dr[8] = "-";
dr[9] = "-";
}
dt.Rows.Add(dr);
}
gvLiabilities.DataSource = dt;
gvLiabilities.DataBind();
}
else
{
lblMsg.Visible = true;
}
}
protected void BindGridview(int id, bool isAdviser, bool isBranchHead, bool isBranchId)
{
ISAQueueListVo = new List <LiabilitiesVo>();
LiabilitiesVo liabilityVo = new LiabilitiesVo();
ISAQueueListVo = liabilitiesBo.GetISAQueueList(id, isAdviser, isBranchHead, isBranchId, currentUserRole);
DataTable dt = new DataTable();
DataRow dr;
Double loanOutStanding = 0;
DateTime nextInsDate = new DateTime();
string format = "dd/MM/yyyy hh:mm tt";
if (ISAQueueListVo != null)
{
btnExportFilteredData.Visible = true;
trErrorMessage.Visible = false;
dt.Columns.Add("AISAQ_RequestQueueid");
dt.Columns.Add("AISAQ_date");
dt.Columns.Add("AISAQ_Status");
dt.Columns.Add("AISAQ_Priority");
dt.Columns.Add("CustomerName");
dt.Columns.Add("WWFSM_StepCode");
dt.Columns.Add("AISAQD_Status");
dt.Columns.Add("BranchName");
dt.Columns.Add("StepName");
dt.Columns.Add("StatusCode");
dt.Columns.Add("CISAA_AccountNumber");
dt.Columns.Add("AISAQ_ProcessedDate");
for (int i = 0; i < ISAQueueListVo.Count; i++)
{
dr = dt.NewRow();
liabilityVo = ISAQueueListVo[i];
dr[0] = liabilityVo.ISARequestId;
if (liabilityVo.RequestDate != DateTime.MinValue)
{
dr[1] = liabilityVo.RequestDate.ToString(format);
}
if (liabilityVo.CurrentStatus != null)
{
dr[2] = liabilityVo.CurrentStatus;
}
if (liabilityVo.Priority != null)
{
dr[3] = liabilityVo.Priority;
}
if (liabilityVo.CustomerName != null)
{
dr[4] = liabilityVo.CustomerName;
}
if (liabilityVo.StepCode != null)
{
dr[5] = liabilityVo.StepCode;
}
if (liabilityVo.Status != null)
{
dr[6] = liabilityVo.Status;
}
if (liabilityVo.BranchName != null)
{
dr[7] = liabilityVo.BranchName;
}
if (liabilityVo.StepName != null)
{
dr[8] = liabilityVo.StepName;
}
if (liabilityVo.StatusCode != null)
{
dr[9] = liabilityVo.StatusCode;
}
if (liabilityVo.IsaNo != null)
{
dr[10] = liabilityVo.IsaNo;
}
if (liabilityVo.ProcessedDate != DateTime.MinValue)
{
dr[11] = liabilityVo.ProcessedDate.ToString(format);
}
dt.Rows.Add(dr);
}
gvISArequest.DataSource = dt;
gvISArequest.DataBind();
gvISArequest.Visible = true;
if (Cache["IsaRequestDetails + '" + advisorVo.advisorId + "'"] == null)
{
Cache.Insert("IsaRequestDetails + '" + advisorVo.advisorId + "'", dt);
}
else
{
Cache.Remove("IsaRequestDetails + '" + advisorVo.advisorId + "'");
Cache.Insert("IsaRequestDetails + '" + advisorVo.advisorId + "'", dt);
}
}
else
{
trErrorMessage.Visible = true;
gvISArequest.Visible = false;
btnExportFilteredData.Visible = false;
}
}
