/// <summary> /// Truy vấn tình hình thu phí của hợp đồng /// dutp /// 22/7/20 /// </summary> /// <param name="input"></param> /// <returns></returns> public ResultSearchListRepaymentSchedule searchRepaymentSchedule(SearchRepaymentSchedule input) { try { SqlParameter[] prms = new SqlParameter[] { new SqlParameter { ParameterName = "fromDate", DbType = DbType.Date, Value = input.fromDate == null ? (object)DBNull.Value: input.fromDate, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "toDate", DbType = DbType.Date, Value = input.toDate == null ? (object)DBNull.Value: input.toDate, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "insuranceContractNo", DbType = DbType.String, Value = string.IsNullOrEmpty(input.insuranceContractNo) ? (object)DBNull.Value : input.insuranceContractNo, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "customerCif", DbType = DbType.String, Value = string.IsNullOrEmpty(input.customerCif) ? (object)DBNull.Value : input.customerCif, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "paymentStatus", DbType = DbType.String, Value = string.IsNullOrEmpty(input.paymentStatus) ? (object)DBNull.Value : input.paymentStatus, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "branchCode", DbType = DbType.String, Value = string.IsNullOrEmpty(input.branchCode) ? (object)DBNull.Value : input.branchCode, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "userId", DbType = DbType.String, Value = string.IsNullOrEmpty(input.userId) ? (object)DBNull.Value : input.userId, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "pageNumber", DbType = DbType.Int32, Value = input.pageNumber, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "pageSize", DbType = DbType.Int32, Value = input.pageSize, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "resultMessage", DbType = DbType.String, Direction = ParameterDirection.Output, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "resultCode", DbType = DbType.Int32, Direction = ParameterDirection.Output, Size = Int32.MaxValue } }; var resultObject = new ResultSearchListRepaymentSchedule(); var result = _Repository.ExecWithStoreProcedureCommand(Store_searchRepaymentSchedule, prms); if (result.errorCode == 0) { resultObject = JsonConvert.DeserializeObject <ResultSearchListRepaymentSchedule>(result.errorMessage); } return(resultObject); } catch (Exception ex) { HDBH.Log.WriteLog.Error("PaymentService => searchRepaymentSchedule", ex); return(new ResultSearchListRepaymentSchedule()); } }
public JsonResult searchRepaymentSchedule(SearchRepaymentSchedule input) { var result = new ResultSearchListRepaymentSchedule(); input.userId = RDAuthorize.UserId; input.branchCode = RDAuthorize.BranchCode; if (input._paymentStatus != null) { input.paymentStatus = JsonConvert.SerializeObject(input._paymentStatus); } else { input.paymentStatus = ""; } result = _paymentservice.searchRepaymentSchedule(input); return(Json(new { data = result.resultList, recordsTotal = result.TotalRecord, recordsFiltered = result.TotalRecord, })); }