public DataSet EndCall(TeleCallerVM objTeleCallerVM, string UserID, string userHostAddress)
{
return(_CustomerDAL.EndCall(objTeleCallerVM, UserID, userHostAddress));
}
public DataSet EndCall(TeleCallerVM objTeleCallerVM, string UserID, string userHostAddress)
{
List <SqlParameter> _param = new List <SqlParameter>();
try
{
_param.Add(new SqlParameter("@CustomerName", (object)objTeleCallerVM.customer.CustomerName ?? DBNull.Value));
_param.Add(new SqlParameter("@AlternateNo", (object)objTeleCallerVM.customer.AltContactNo ?? DBNull.Value));
_param.Add(new SqlParameter("@Call_Type", objTeleCallerVM.callHistory.Call_Type));
_param.Add(new SqlParameter("@UpdatedBy", UserID));
_param.Add(new SqlParameter("@HostName", userHostAddress));
_param.Add(new SqlParameter("@EmailID", (object)objTeleCallerVM.customer.EmailID ?? DBNull.Value));
_param.Add(new SqlParameter("@LoanAmount", (object)objTeleCallerVM.customer.LoanAmount ?? DBNull.Value));
_param.Add(new SqlParameter("@NatureOfLoanID", (object)objTeleCallerVM.customer.NatureOfLoanID ?? DBNull.Value));
_param.Add(new SqlParameter("@BalanceTransferBankID", (object)objTeleCallerVM.customer.BalanceTransferBankID ?? DBNull.Value));
_param.Add(new SqlParameter("@BalanceTransferOtherBankName", (object)objTeleCallerVM.customer.BalanceTransferOtherBankName ?? DBNull.Value));
_param.Add(new SqlParameter("@ResalePropertyAddress", (object)objTeleCallerVM.customer.ResalePropertyAddress ?? DBNull.Value));
_param.Add(new SqlParameter("@ResaleAuthorityType", (object)objTeleCallerVM.customer.ResaleAuthorityType ?? DBNull.Value));
_param.Add(new SqlParameter("@ResaleAuthorityDetails", (object)objTeleCallerVM.customer.ResaleAuthorityDetails ?? DBNull.Value));
_param.Add(new SqlParameter("@PlotPurchaseAddress", (object)objTeleCallerVM.customer.PlotPurchaseAddress ?? DBNull.Value));
_param.Add(new SqlParameter("@MonthOfRegistration", (object)objTeleCallerVM.customer.MonthOfRegistration ?? DBNull.Value));
_param.Add(new SqlParameter("@AnyConstruction", (object)objTeleCallerVM.customer.AnyConstruction ?? DBNull.Value));
_param.Add(new SqlParameter("@ConstructionApprovedMap", (object)objTeleCallerVM.customer.ConstructionApprovedMap ?? DBNull.Value));
_param.Add(new SqlParameter("@OriginalCostOfAllotment", (object)objTeleCallerVM.customer.OriginalCostOfAllotment ?? DBNull.Value));
_param.Add(new SqlParameter("@PropertyDetailType", (object)objTeleCallerVM.customer.PropertyDetailType ?? DBNull.Value));
_param.Add(new SqlParameter("@BuilderName", (object)objTeleCallerVM.customer.BuilderName ?? DBNull.Value));
_param.Add(new SqlParameter("@BuilderProjectName", (object)objTeleCallerVM.customer.BuilderProjectName ?? DBNull.Value));
_param.Add(new SqlParameter("@BuliderProjectAddress", (object)objTeleCallerVM.customer.BuliderProjectAddress ?? DBNull.Value));
_param.Add(new SqlParameter("@CentralGovtProjectName", (object)objTeleCallerVM.customer.CentralGovtProjectName ?? DBNull.Value));
_param.Add(new SqlParameter("@CentralGovtProjectAddress", (object)objTeleCallerVM.customer.CentralGovtProjectAddress ?? DBNull.Value));
_param.Add(new SqlParameter("@IndependentMapApproved", (object)objTeleCallerVM.customer.IndependentMapApproved ?? DBNull.Value));
_param.Add(new SqlParameter("@IndependentMapApprovedType", (object)objTeleCallerVM.customer.IndependentMapApprovedType ?? DBNull.Value));
_param.Add(new SqlParameter("@PropertyType", (object)objTeleCallerVM.customer.PropertyType ?? DBNull.Value));
_param.Add(new SqlParameter("@DoableMarketValue", (object)objTeleCallerVM.customer.DoableMarketValue ?? DBNull.Value));
_param.Add(new SqlParameter("@DoableRegisteredValue", (object)objTeleCallerVM.customer.DoableRegisteredValue ?? DBNull.Value));
_param.Add(new SqlParameter("@OwnershipOfProperty", (object)objTeleCallerVM.customer.OwnershipOfProperty ?? DBNull.Value));
_param.Add(new SqlParameter("@IncomeSource", (object)objTeleCallerVM.customer.IncomeSource ?? DBNull.Value));
_param.Add(new SqlParameter("@SelfEmploymentType", (object)objTeleCallerVM.customer.SelfEmploymentType ?? DBNull.Value));
_param.Add(new SqlParameter("@CSEID", objTeleCallerVM.callHistory.CSEID));
_param.Add(new SqlParameter("@CrmID", objTeleCallerVM.customer.CrmID));
_param.Add(new SqlParameter("@CallStartDateTime", objTeleCallerVM.callHistory.CallDateTime));
_param.Add(new SqlParameter("@CallEndDateTime", DateTime.Now));
_param.Add(new SqlParameter("@CalledPhoneNo", objTeleCallerVM.customer.MobileNo));
_param.Add(new SqlParameter("@SubOutcomeID", objTeleCallerVM.callHistory.subOutcomeMaster.SubOutcomeID));
_param.Add(new SqlParameter("@Remarks", objTeleCallerVM.callHistory.Remarks));
_param.Add(new SqlParameter("@CallBackDateTime", objTeleCallerVM.callHistory.subOutcomeMaster.SubOutcomeID == 2 ? (object)objTeleCallerVM.callHistory.CallBackDateTime : DBNull.Value));
_param.Add(new SqlParameter("@OutcomeID", DBNull.Value));
_param.Add(new SqlParameter("@CallbackType", objTeleCallerVM.callHistory.subOutcomeMaster.SubOutcomeID == 2 ? (object)objTeleCallerVM.callHistory.CallbackType : DBNull.Value));
return(_SqlDbBridge.ExecuteDataSet("proc_endCall", _param));
}
catch (Exception ex)
{
return(null);
throw;
}
}
