Пример #1
0
        /// <summary>
        /// Provide combined summary of WO/WA status
        /// </summary>
        /// <param name="search">Search text criteria</param>
        /// <param name="orderDescending">Flag indicating whether results are sorted in descending order</param>
        /// <param name="displayStart">Record to start displaying (used for pagination)</param>
        /// <param name="displayLength">Number of records to display</param>
        /// <returns>WO/WA Summary table of status counts for a given day</returns>
        public dataTableResult <WOWASummary> CombinedSummary(string search,
                                                             bool orderDescending,
                                                             int displayStart,
                                                             int displayLength)
        {
            var result = new dataTableResult <WOWASummary>();

            var q = repo.GetCombinedSummary("", true, 0, 1);

            if (orderDescending)
            {
                q = q.OrderByDescending(p => p.sortableDate);
            }
            else
            {
                q = q.OrderBy(p => p.sortableDate);
            }

            result.filteredCount = q.Count();
            result.query         = q.Skip <WOWASummary>((int)displayStart).Take((int)displayLength);
            result.totalCount    = repo.GetAllQ().Count();
            return(result);
        }