/// <summary> /// Theoretical revenue report /// Check whether data is available for specified parameter /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="companyId"></param> /// <param name="userId"></param> /// <returns></returns> public ActionResult IsActualRevenueDataAvailable(string sDate, string eDate, int companyId) { ActualRevenueReportService actualRevenueReportService = new ActualRevenueReportService(); DateTime startDate = Convert.ToDateTime(sDate); DateTime endDate = Convert.ToDateTime(eDate); DateTime afterFiveYearDate = startDate.AddYears(5); afterFiveYearDate = afterFiveYearDate.AddDays(-1); if (endDate > afterFiveYearDate) { return(new HttpStatusCodeAndErrorResult(500, String.Format("Please enter valid 'End date', It should not be more than 5 years from Start Date"))); } bool isDataFound = actualRevenueReportService.IsActualRevenueReportDataAvailable(startDate, endDate, companyId); if (isDataFound) { return(new HttpStatusCodeResult(200)); } return(new HttpStatusCodeAndErrorResult(500, String.Format(Constants.DATA_NOT_FOUND))); }
/// <summary> /// Return Datatable /// </summary> /// <param name="startDate">start Date</param> /// <param name="endDate">end Date</param> /// <param name="companyId">company Id</param> /// <returns>Datatable</returns> public DataTable ExecuteActualReport(DateTime startDate, DateTime endDate, int companyId) { ActualRevenueReportService actualRevenueReportService = new ActualRevenueReportService(); var result = actualRevenueReportService.ExecuteActualReport(startDate, endDate, companyId); return(result); }