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