public CPProductSearchModel searchCpProdCommisInau(CPProductSearchViewModel model) { try { CPProductSearchModel resultObject = new CPProductSearchModel(); SqlParameter[] prms = new SqlParameter[] { new SqlParameter { ParameterName = "fromDate", DbType = DbType.Date, Value = model.fromDate == null ? (object)DBNull.Value : model.fromDate, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "toDate", DbType = DbType.Date, Value = model.toDate == null ? (object)DBNull.Value : model.toDate, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "cif", DbType = DbType.String, Value = model.cif == null ? (object)DBNull.Value : model.cif, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "shortName", DbType = DbType.String, Value = model.shortName == null ? (object)DBNull.Value : model.shortName, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "cpGroupCode", DbType = DbType.String, Value = model.cpGroupCode == null ? (object)DBNull.Value : model.cpGroupCode, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "userUpdated", DbType = DbType.String, Value = model.userUpdated == null ? (object)DBNull.Value : model.userUpdated, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "branchCode", DbType = DbType.String, Value = model.branchCode == null ? (object)DBNull.Value : model.branchCode, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "userId", DbType = DbType.String, Value = model.userId == null ? (object)DBNull.Value : model.userId, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "pageNumber", DbType = DbType.Int32, Value = model.pageNumber, Size = Int32.MaxValue }, new SqlParameter { ParameterName = "pageSize", DbType = DbType.Int32, Value = model.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 result = _Repository.ExecWithStoreProcedureCommand(Store_searchCpProdCommisInau, prms); if (result.errorCode == 0) { resultObject = JsonConvert.DeserializeObject <CPProductSearchModel>(result.errorMessage); } return(resultObject); } catch (Exception ex) { HDBH.Log.WriteLog.Error("CPProductService => searchCpProdCommisInau", ex); return(null); } }
public JsonResult SearchInau(CPProductSearchViewModel input) { var result = new CPProductSearchModel(); result = _cPProductService.searchCpProdCommisInau(input); return(Json(new { recordsTotal = result.totalRecord, recordsFiltered = result.totalRecord, data = result.resultList })); }