public CounterPartySearchModel searchCounterParty(CounterPartyListSeachModel model)
{
try
{
CounterPartySearchModel resultObject = new CounterPartySearchModel();
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 = "status", DbType = DbType.String, Value = model.status == null ? (object)DBNull.Value : model.status, 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_searchCounterParty, prms);
if (result.errorCode == 0)
{
resultObject = JsonConvert.DeserializeObject <CounterPartySearchModel>(result.errorMessage);
}
return(resultObject);
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("CounterPartyService => searchCounterParty", ex);
return(null);
}
}
public JsonResult Search(CounterPartyListSeachModel model)
{
var result = new CounterPartySearchModel();
result = _counterPartyService.searchCounterParty(model);
return(Json(new
{
recordsTotal = result.totalRecord,
recordsFiltered = result.totalRecord,
data = result.resultList
}));
}
