public async Task <IHttpActionResult> GetPlannedVsActual(string startDate = null, string endDate = null) { if (string.IsNullOrEmpty(startDate)) { if (DateTime.Today.Day >= 5) { startDate = DateTime.Today.ToString("yyyy-MM-ddTHH:mm:ssZ"); } else { startDate = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-ddTHH:mm:ssZ"); } } WorkLogBL wl = new WorkLogBL(); List <WorkLogManagement> lstData = wl.GetWorkLogByDates(Common.GetStartDate(startDate), Common.GetEndDate(startDate), true); if (lstData != null && lstData.Any()) { var data = (from taskLog in lstData select new PlannedVsActual() { WorkItemNo = taskLog.WorkItemNo.ToString(), PlannedEffort = taskLog.Effort, ActualEffort = taskLog.Tasks.Where(q => q.WorkLogID == taskLog.Id).Sum(q => q.ActualEffort) }).ToList(); return(Ok(data)); } return(null); }
public async Task <IHttpActionResult> WorkLogByDates(string date) { WorkLogBL wl = new WorkLogBL(); return(Ok(wl.GetWorkLogByDates(Common.GetStartDate(date), Common.GetEndDate(date)))); }
public async Task <IHttpActionResult> All() { WorkLogBL wl = new WorkLogBL(); return(Ok(wl.GetAllWorkLog())); }