/// <summary>
///
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IQueryable <WorkAssignmentSummary> GetSummary(string search)
{
IQueryable <WorkAssignment> query = waRepo.GetAllQ();
if (!string.IsNullOrEmpty(search))
{
IndexViewBase.filterOnDatePart(search, ref query);
}
var sum_query = from wa in query
group wa by new
{
dateSoW = TimeZoneInfo
.ConvertTimeFromUtc(wa.workOrder.dateTimeofWork, _clientTimeZoneInfo).Date,
wa.workOrder.statusID
} into dayGroup
select new WorkAssignmentSummary
{
date = dayGroup.Key.dateSoW,
status = dayGroup.Key.statusID,
count = dayGroup.Count()
};
return(sum_query);
}
/// <summary>
///
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IQueryable <WorkAssignmentSummary> GetSummary(string search)
{
IQueryable <WorkAssignment> query = waRepo.GetAllQ();
if (!string.IsNullOrEmpty(search))
{
IndexViewBase.filterOnDatePart(search, ref query);
}
var sum_query = from wa in query //LINQ
group wa by new
{
dateSoW = DbFunctions
.TruncateTime(wa.workOrder.dateTimeofWork),
wa.workOrder.statusID
} into dayGroup
select new WorkAssignmentSummary()
{
date = dayGroup.Key.dateSoW,
status = dayGroup.Key.statusID,
count = dayGroup.Count()
};
return(sum_query);
}