public SearchResult <TimesheetMonthly> GetDataByFilterV2(TimesheetMonthlySearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "UserID"; } var filteredRecords = Db.GetTimesheetMonthlyV2(filter.UserID, filter.Month, filter.Year).Select(x => new TimesheetMonthly { Date = x.Date, FirstCheckIn = x.FirstCheckIn.Value.ToString("HH:mm"), FirstLocation = x.FirstLocation, LastCheckOut = x.LastCheckOut == null ? null : x.LastCheckOut.Value.ToString("HH:mm"), LastLocation = x.LastLocation, IsDiffDay = x.IsDiffDay, TotalTask = x.TotalTask }).ToList(); var displayedRecords = filteredRecords; var searchResult = new SearchResult <TimesheetMonthly>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = filteredRecords.Count(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }
public SearchResult <DateTime?> GetDataByFilter(TimesheetMonthlySearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "UserID"; } var filteredRecords = Db.GetTimesheetMonthly(filter.UserID, filter.Month, filter.Year).ToList(); var displayedRecords = filteredRecords; var searchResult = new SearchResult <DateTime?>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = filteredRecords.Count(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }