public JsonResult GetOpenMarketSLF(int reportId, DateTime startDate, DateTime endDate, string unit)
{
var table = OpenMarketReportRepository.GetOpenMarketSLF(startDate, endDate, unit);
var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLF");
var jtable = BuidJsonTable(table, columns);
return(Json(jtable, JsonRequestBehavior.AllowGet));
}
public ActionResult ExportExcelForSLF(int reportId, DateTime startDate, DateTime endDate, string unit)
{
var table = OpenMarketReportRepository.GetOpenMarketSLF(startDate, endDate, unit);
var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLF");
var jtable = BuidJsonTable(table, columns);
var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName;
reportName = Resources.Global.OpenMarketSLF;
var jP = new JsonExcelParameter {
Table = jtable, TableName = reportName, Source = Resources.Global.Source
};
return(new JsonTableExcelResult(jP));
}