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