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