private static List <VwHoursEntered> GetData(HoursEnteredParams Params) { using var db = new ModelContext(); return(db.VwHoursEntered .Where(x => Params.UserName == null || Params.UserName == "All" || x.Username == Params.UserName) .Where(x => Params.ProjectTitle == null || Params.ProjectTitle == "All" || x.ProjectTitle == Params.ProjectTitle) .Where(x => Params.StartDate == null || x.WorkDate >= Params.StartDate.Value) .Where(x => Params.EndDate == null || x.WorkDate <= Params.EndDate.Value.AddDays(1)) .ToList()); }
public IActionResult Get(HoursEnteredParams Params) { return(base.Ok(GetData(Params))); }
public IActionResult GetExcel(HoursEnteredParams Params) { var data = GetData(Params); return(File(ExcelService.GenerateExcelWorkbook(data), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")); }
public async Task <HttpResponseMessage> GetHoursEnteredExcel(HoursEnteredParams para) { return(await http.PostAsJsonAsync("api/reports/hours-entered/excel", para)); }