/// <summary> /// Used to Get Liabilties for Customer Prospect /// </summary> /// <param name="customerId"></param> /// <param name="totalLoanOutstanding"></param> /// <param name="totalLiabilities"></param> /// <returns></returns> public List <CustomerProspectLiabilitiesDetailsVo> GetLiabilitiesDetailsForCustomerProspect(DataTable dtCustomerLiabilitiesDetails) { CustomerProspectDao customerprospectdao = new CustomerProspectDao(); CustomerProspectLiabilitiesDetailsVo customerprospectliabilitiesetailsvo; List <CustomerProspectLiabilitiesDetailsVo> customerprospectliabilitiesdetailslist = new List <CustomerProspectLiabilitiesDetailsVo>(); try { if (dtCustomerLiabilitiesDetails != null && dtCustomerLiabilitiesDetails.Rows.Count > 0) { for (int i = 0; i < dtCustomerLiabilitiesDetails.Rows.Count; i++) { customerprospectliabilitiesetailsvo = new CustomerProspectLiabilitiesDetailsVo(); customerprospectliabilitiesetailsvo.LiabilitiesDetailsId = int.Parse(dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_FPLiabilitiesDetailsId"].ToString()); if (dtCustomerLiabilitiesDetails.Rows[i]["XLT_LoanTypeCode"].ToString() != null) { //Total Value if (dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_TotalLoanOutstanding"].ToString() != string.Empty && dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_TotalLoanOutstanding"] != null) { customerprospectliabilitiesetailsvo.LoanOutstanding = double.Parse(dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_TotalLoanOutstanding"].ToString()); } //Adjusted Value if (dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_AdjustedLoanOutstanding"].ToString() != string.Empty && dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_AdjustedLoanOutstanding"] != null) { customerprospectliabilitiesetailsvo.AdjustedLoan = double.Parse(dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_AdjustedLoanOutstanding"].ToString()); } customerprospectliabilitiesetailsvo.LoanTypeCode = int.Parse(dtCustomerLiabilitiesDetails.Rows[i]["XLT_LoanTypeCode"].ToString()); if (dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_Tenure"] != null && dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_Tenure"].ToString() != "") { customerprospectliabilitiesetailsvo.Tenure = int.Parse(dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_Tenure"].ToString()); } if (dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_EMIAmount"] != null && dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_EMIAmount"].ToString() != "") { customerprospectliabilitiesetailsvo.EMIAmount = double.Parse(dtCustomerLiabilitiesDetails.Rows[i]["CFPLD_EMIAmount"].ToString()); } customerprospectliabilitiesdetailslist.Add(customerprospectliabilitiesetailsvo); } } } } catch (Exception ex) { throw ex; } return(customerprospectliabilitiesdetailslist); }
/// <summary> /// Used to Get Liabilties for Customer Prospect /// </summary> /// <param name="customerId"></param> /// <param name="totalLoanOutstanding"></param> /// <param name="totalLiabilities"></param> /// <returns></returns> public List <CustomerProspectLiabilitiesDetailsVo> GetLiabilitiesDetailsForCustomerProspect(int customerId) { DataSet dsCustomerLiabilitiesDetails = null; CustomerProspectDao customerprospectdao = new CustomerProspectDao(); CustomerProspectLiabilitiesDetailsVo customerprospectliabilitiesetailsvo; List <CustomerProspectLiabilitiesDetailsVo> customerprospectliabilitiesdetailslist = new List <CustomerProspectLiabilitiesDetailsVo>(); try { dsCustomerLiabilitiesDetails = customerprospectdao.GetLiabilitiesDetailsForCustomerProspect(customerId); for (int i = 0; i < dsCustomerLiabilitiesDetails.Tables[0].Rows.Count; i++) { customerprospectliabilitiesetailsvo = new CustomerProspectLiabilitiesDetailsVo(); customerprospectliabilitiesetailsvo.LiabilitiesDetailsId = int.Parse(dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_FPLiabilitiesDetailsId"].ToString()); customerprospectliabilitiesetailsvo.LoanOutstanding = double.Parse(dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_LoanOutstanding"].ToString()); if (dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["XLT_LoanTypeCode"].ToString() != null) { customerprospectliabilitiesetailsvo.LoanTypeCode = int.Parse(dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["XLT_LoanTypeCode"].ToString()); if (dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_Tenure"] != null && dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_Tenure"].ToString() != "") { customerprospectliabilitiesetailsvo.Tenure = int.Parse(dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_Tenure"].ToString()); } if (dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_EMIAmount"] != null && dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_EMIAmount"].ToString() != "") { customerprospectliabilitiesetailsvo.EMIAmount = double.Parse(dsCustomerLiabilitiesDetails.Tables[0].Rows[i]["CFPLD_EMIAmount"].ToString()); } customerprospectliabilitiesdetailslist.Add(customerprospectliabilitiesetailsvo); } } } catch (Exception ex) { throw ex; } return(customerprospectliabilitiesdetailslist); }
/// <summary> /// Used to Update Liabilities Details of a Particular Customer /// </summary> /// <param name="userId"></param> /// <param name="customerId"></param> /// <param name="customerProspectLiabilitiesDetailsVo"></param> /// <returns></returns> public bool UpdateCustomerLiabilitiesDetailsForCustomerProspect(int userId, int customerId, CustomerProspectLiabilitiesDetailsVo customerProspectLiabilitiesDetailsVo) { Database db; DbCommand cmdUpdateLiabilitiesDetailsForCustomerProspect; bool bLiabilitiesResult = false; try { db = DatabaseFactory.CreateDatabase("wealtherp"); //Adding Data to the table cmdUpdateLiabilitiesDetailsForCustomerProspect = db.GetStoredProcCommand("SP_UpdateLiabilitiesDetailsForCustomerProspect"); db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@C_CustomerId", DbType.Int32, customerId); if (customerProspectLiabilitiesDetailsVo.LoanTypeCode != 0) { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@XLT_LoanTypeCode", DbType.Int32, customerProspectLiabilitiesDetailsVo.LoanTypeCode); } else { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@XLT_LoanTypeCode", DbType.Int32, 0); } if (customerProspectLiabilitiesDetailsVo.LoanOutstanding != 0.0) { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_LoanOutstanding", DbType.Decimal, customerProspectLiabilitiesDetailsVo.LoanOutstanding); } else { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_LoanOutstanding", DbType.Decimal, 0.0); } if (customerProspectLiabilitiesDetailsVo.Tenure != 0) { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_Tenure", DbType.Int32, customerProspectLiabilitiesDetailsVo.Tenure); } else { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_Tenure", DbType.Int32, 0); } if (customerProspectLiabilitiesDetailsVo.EMIAmount != 0) { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_EMIAmount", DbType.Int32, customerProspectLiabilitiesDetailsVo.EMIAmount); } else { db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@CFPLD_EMIAmount", DbType.Int32, 0.0); } db.AddInParameter(cmdUpdateLiabilitiesDetailsForCustomerProspect, "@U_UserId", DbType.Int32, userId); if (db.ExecuteNonQuery(cmdUpdateLiabilitiesDetailsForCustomerProspect) != 0) { bLiabilitiesResult = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerProspectDao.cs:UpdateCustomerLiabilitiesDetailsForCustomerProspect(int userId, int customerId, CustomerProspectLiabilitiesDetailsVo customerProspectLiabilitiesDetailsVo)"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bLiabilitiesResult); }