/// <summary>
/// Used to Get Expense Details about customers
/// </summary>
/// <param name="customerId"></param>
/// <param name="totalExpense"></param>
/// <returns></returns>
public List <CustomerProspectExpenseDetailsVo> GetExpenseDetailsForCustomerProspect(DataTable dtCustomerProspectExpenseDetails)
{
CustomerProspectDao customerprospectdao = new CustomerProspectDao();
CustomerProspectExpenseDetailsVo customerprospectexpensedetailsvo;
List <CustomerProspectExpenseDetailsVo> customerprospectexpensedetailslist = new List <CustomerProspectExpenseDetailsVo>();
try
{
if (dtCustomerProspectExpenseDetails != null && dtCustomerProspectExpenseDetails.Rows.Count > 0)
{
for (int i = 0; i < dtCustomerProspectExpenseDetails.Rows.Count; i++)
{
customerprospectexpensedetailsvo = new CustomerProspectExpenseDetailsVo();
customerprospectexpensedetailsvo.ExpenseDetailsId = int.Parse(dtCustomerProspectExpenseDetails.Rows[i]["CFPED_FPExpenseDetailsId"].ToString());
customerprospectexpensedetailsvo.ExpenseCategoryCode = int.Parse(dtCustomerProspectExpenseDetails.Rows[i]["XEC_ExpenseCategoryCode"].ToString());
if (dtCustomerProspectExpenseDetails.Rows[i]["CFPED_Value"] != null && dtCustomerProspectExpenseDetails.Rows[i]["CFPED_Value"].ToString() != "")
{
customerprospectexpensedetailsvo.ExpenseValue = double.Parse(dtCustomerProspectExpenseDetails.Rows[i]["CFPED_Value"].ToString());
}
customerprospectexpensedetailslist.Add(customerprospectexpensedetailsvo);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(customerprospectexpensedetailslist);
}
/// <summary>
/// Used to Add Customer Expense Details in Customer Prospect
/// </summary>
/// <param name="customerId"></param>
/// <param name="userId"></param>
/// <param name="customerProspectExpenseeDetailsVo"></param>
/// <returns></returns>
public bool AddCustomerFPExpenseDetails(int customerId, int userId, CustomerProspectExpenseDetailsVo customerProspectExpenseeDetailsVo)
{
Database db;
DbCommand cmdAddCustomerFPExpenseDetails;
bool bExpenseResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
//Adding Data to the table
cmdAddCustomerFPExpenseDetails = db.GetStoredProcCommand("SP_AddCustomerFPExpenseDetails");
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@C_CustomerId", DbType.Int32, customerId);
if (customerProspectExpenseeDetailsVo.ExpenseCategoryCode != 0)
{
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@XEC_ExpenseCategoryCode", DbType.Int32, customerProspectExpenseeDetailsVo.ExpenseCategoryCode);
}
else
{
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@XEC_ExpenseCategoryCode", DbType.Int32, 0);
}
if (customerProspectExpenseeDetailsVo.ExpenseValue != 0)
{
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@CFPED_Value", DbType.Decimal, customerProspectExpenseeDetailsVo.ExpenseValue);
}
else
{
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@CFPED_Value", DbType.Decimal, 0.0);
}
db.AddInParameter(cmdAddCustomerFPExpenseDetails, "@U_UserId", DbType.Int32, userId);
if (db.ExecuteNonQuery(cmdAddCustomerFPExpenseDetails) != 0)
{
bExpenseResult = 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:AddCustomerFPExpenseDetails(int customerId, int userId, CustomerProspectIncomeDetailsVo customerProspectExpenseeDetailsVo)");
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(bExpenseResult);
}
