public JsonResult GetOpenMarketSLO(int reportId, DateTime startDate, DateTime endDate, string unit, string includeExpired) { var table = OpenMarketReportRepository.GetOpenMarketSLO(startDate, endDate, unit); var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLO"); var jtable = BuidJsonTable(table, columns); return(Json(jtable, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportExcelForSLO(int reportId, DateTime startDate, DateTime endDate, string unit, string includeExpired) { var table = OpenMarketReportRepository.GetOpenMarketSLO(startDate, endDate, unit); var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLO"); var jtable = BuidJsonTable(table, columns); var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName; reportName = Resources.Global.OpenMarketSLO; var totalColumns = new List <string>(); totalColumns.Add("IssueAmount"); var jP = new JsonExcelParameter { Table = jtable, TableName = reportName, Source = Resources.Global.Source, totalColumns = totalColumns, sumGroupColumnName = "Direction", isTotal = true }; return(new JsonTableGroupExcelResult(jP)); }