public IQueryable <AgencyReportingHcRow> GetAgencyReportingData(CC.Data.ccEntities db, CC.Data.Services.IPermissionsBase permissions)
{
db.CommandTimeout = 600;
var q = db.Over105HcHours(this.SelectedRegionId,
this.SelectedAgencyGroupId,
this.SelectedYear,
this.sSearch,
this.iDisplayLength == int.MaxValue ? int.MaxValue : this.iDisplayLength + 1,
this.iDisplayStart,
permissions.User.Id).Select(g => new AgencyReportingHcRow
{
AgencyGroupId = g.AgencyGroupId,
AgencyGroupName = g.AgencyGroupName,
Year = g.Year,
Month = g.Month,
ClientId = g.ClientId,
ReportedHours = g.ReportedHours,
GovHours = g.GovHours,
TotalHours = g.TotalHours,
RegionId = g.RegionId,
ReportedDate = g.ReportDate,
Week = g.Week
}).Where(f => f.TotalHours > 105).OrderBy(f => f.ReportedDate).ToList();
return(q.AsQueryable());
}
