public List <SPGetConfig_Result> Filter(SystemConfigQuery query, out int count)
{
count = 0;
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var start = 0;
var limit = query.PageSize;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetConfig_Result> result = new List <SPGetConfig_Result>();
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
result = _entities.SPGetConfig(Util.DetecVowel(keyword), start, limit, prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public BaseListResponse <SPGetConfig_Result> FilterSystemConfig(SystemConfigQuery query)
{
var response = new BaseListResponse <SPGetConfig_Result>();
int count = 0;
try
{
response.Data = _systemConfigRepository.Filter(query, out count);
response.TotalItems = count;
response.PageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
response.PageSize = query.PageSize;
}
catch (Exception ex)
{
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
}
return(response);
}
public BaseListResponse <SPGetConfig_Result> Search([FromUri] SystemConfigQuery query)
{
return(shareService.FilterSystemConfig(query));
}
