public List <SPGetApplicationLogging_Result> Filter(ApplicationLoggingQuery 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;
            DateTime fromDate   = query.FromDate;
            DateTime toDate     = query.ToDate;
            var      modules    = !string.IsNullOrEmpty(query.Module)?query.Module:"";

            start = (pageNumber - 1) * limit;
            int totalRow = 0;
            List <SPGetApplicationLogging_Result> result = new List <SPGetApplicationLogging_Result>();
            ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);

            result = _entities.SPGetApplicationLogging(fromDate, toDate, modules, Util.DetecVowel(keyword), start, limit, prTotalRow).ToList();
            count  = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
            return(result);
        }
 public BaseListResponse <SPGetApplicationLogging_Result> Search([FromUri] ApplicationLoggingQuery query)
 {
     return(shareService.FilterApplicationLogging(query));
 }
Example #3
0
        public BaseListResponse <SPGetApplicationLogging_Result> FilterApplicationLogging(ApplicationLoggingQuery query)
        {
            var response = new BaseListResponse <SPGetApplicationLogging_Result>();
            int count    = 0;

            try
            {
                response.Data       = _applicationLoggingRepository.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);
        }