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);
}
