Example #1
0
        public int FetchCount()
        {
            CustomersDataContext customersDataContext = new CustomersDataContext();

            count = customersDataContext.GetCount(dateFrom, dateTo).ToList().First().Count.Value;
            return(count);
        }
Example #2
0
        public IList <Customer> FetchRange(int startIndex, int pageCount, out int overallCount)
        {
            CustomersDataContext customersDataContext = new CustomersDataContext();

            IList <Customer> customersResult;

            startIndex = startIndex + 1;               // SQL index starts at 1.
            int endIndex = startIndex + pageCount - 1; // GetCustomers returns items with indices startIndex through endIndex, inclusive.

            overallCount    = count;                   // In this case it's ok not to get the count again because we're assuming the data in the database is not changing.
            customersResult = customersDataContext.GetSortedFilteredCustomers(startIndex, endIndex, this.dateFrom, this.dateTo, this.sortField).ToList();

            return(customersResult);
        }