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