/// <summary>
/// Used to get income details for Customer Prospect
/// </summary>
/// <param name="customerId"></param>
/// <param name="totalIncome"></param>
/// <returns></returns>
public List <CustomerProspectIncomeDetailsVo> GetIncomeDetailsForCustomerProspect(DataTable dtCustomerProspectIncomeDetails)
{
CustomerProspectDao customerprospectdao = new CustomerProspectDao();
CustomerProspectIncomeDetailsVo customerprospectincomedetailsvo;
List <CustomerProspectIncomeDetailsVo> customerprospectincomedetailslist = new List <CustomerProspectIncomeDetailsVo>();
try
{
if (dtCustomerProspectIncomeDetails != null && dtCustomerProspectIncomeDetails.Rows.Count > 0)
{
for (int i = 0; i < dtCustomerProspectIncomeDetails.Rows.Count; i++)
{
customerprospectincomedetailsvo = new CustomerProspectIncomeDetailsVo();
customerprospectincomedetailsvo.IncomeDetailsId = int.Parse(dtCustomerProspectIncomeDetails.Rows[i]["CFPID_FPIncomeDetailsId"].ToString());
customerprospectincomedetailsvo.IncomeCategoryCode = int.Parse(dtCustomerProspectIncomeDetails.Rows[i]["XIC_IncomeCategoryCode"].ToString());
if (dtCustomerProspectIncomeDetails.Rows[i]["CFPID_Value"] != null && dtCustomerProspectIncomeDetails.Rows[i]["CFPID_Value"].ToString() != "")
{
customerprospectincomedetailsvo.IncomeValue = double.Parse(dtCustomerProspectIncomeDetails.Rows[i]["CFPID_Value"].ToString());
}
customerprospectincomedetailslist.Add(customerprospectincomedetailsvo);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(customerprospectincomedetailslist);
}
/// <summary>
/// Used to Add Income Details for Customer
/// </summary>
/// <param name="customerId"></param>
/// <param name="userId"></param>
/// <param name="customerProspectIncomeDetailsVo"></param>
/// <returns></returns>
public bool AddCustomerFPIncomeDetails(int customerId, int userId, CustomerProspectIncomeDetailsVo customerProspectIncomeDetailsVo)
{
Database db;
DbCommand cmdAddCustomerFPIncomeDetails;
bool bIncomeResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
//Adding Data to the table
cmdAddCustomerFPIncomeDetails = db.GetStoredProcCommand("SP_AddCustomerFPIncomeDetails");
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@C_CustomerId", DbType.Int32, customerId);
if (customerProspectIncomeDetailsVo.IncomeCategoryCode != 0)
{
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@XIC_IncomeCategoryCode", DbType.Int32, customerProspectIncomeDetailsVo.IncomeCategoryCode);
}
else
{
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@XIC_IncomeCategoryCode", DbType.Int32, 0);
}
if (customerProspectIncomeDetailsVo.IncomeValue != 0)
{
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@CFPID_Value", DbType.Decimal, customerProspectIncomeDetailsVo.IncomeValue);
}
else
{
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@CFPID_Value", DbType.Decimal, 0.0);
}
db.AddInParameter(cmdAddCustomerFPIncomeDetails, "@U_UserId", DbType.Int32, userId);
if (db.ExecuteNonQuery(cmdAddCustomerFPIncomeDetails) != 0)
{
bIncomeResult = 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:AddCustomerFPIncomeDetails(int customerId,int userId,CustomerProspectIncomeDetailsVo customerProspectIncomeDetailsVo)");
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(bIncomeResult);
}
