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));
}
/// <summary>
/// Get data used by open market report
/// </summary>
/// <returns></returns>
public IEnumerable <OpenMarketRepo> GetOpenMarketRepo(DetailDataReportParams reportPara, GlobalValueParams globalValues)
{
IEnumerable <OpenMarketRepo> openMarketRepo = OpenMarketReportRepository.GetOpenMarketRepo(reportPara);
IEnumerable <OpenMarketRepo> repoRet = SetOptionType(reportPara, openMarketRepo, globalValues);
return(repoRet);
}
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));
}
public JsonResult GetOpenMarketOperation(int reportId, string type, DateTime startDate, DateTime endDate, string unit, bool includeExpired, string categoryType)
{
var table = OpenMarketReportRepository.GetOpenMarketOperation(type, startDate, endDate, unit, includeExpired?1:0);
if (categoryType == "OperationTerm")
{
var dv = table.DefaultView;
dv.Sort = "TERM";
table = dv.ToTable();
}
var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "Operation");
var jtable = BuidJsonTable(table, columns);
return(Json(jtable, JsonRequestBehavior.AllowGet));
}
private ImmaturityAmount GetImmaturityAmount(DateTime queryDate, string unit)
{
var table = OpenMarketReportRepository.GetImmaturityAmount(queryDate);
var row = table.Rows[0];
var amount = new ImmaturityAmount()
{
All = SwitchAmountUnit(unit, double.Parse(row["total"].ToString())),
CBankBill = SwitchAmountUnit(unit, double.Parse(row["cbb"].ToString())),
FMD = SwitchAmountUnit(unit, double.Parse(row["fmd"].ToString())),
Repo = SwitchAmountUnit(unit, double.Parse(row["rp"].ToString())),
ReverseRepo = SwitchAmountUnit(unit, double.Parse(row["rrp"].ToString())),
Mlf = SwitchAmountUnit(unit, double.Parse(row["mlf"].ToString()))
};
return(amount);
}
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));
}
public ActionResult ExportExcelForOperation(int reportId, string type, DateTime startDate, DateTime endDate, string unit, bool includeExpired, string category)
{
var table = OpenMarketReportRepository.GetOpenMarketOperation(type, startDate, endDate, unit, includeExpired?1:0);
if (category == "OperationTerm")
{
var dv = table.DefaultView;
dv.Sort = "TERM";
table = dv.ToTable();
}
var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "Operation");
var jtable = BuidJsonTable(table, columns);
var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName;
var totalColumns = new List <string>();
totalColumns.Add("Amount");
totalColumns.Add("Volume");
var jP = new JsonExcelParameter {
Table = jtable, TableName = reportName, Source = Resources.Global.Source, totalColumns = totalColumns, sumGroupColumnName = category, isTotal = true
};
return(new JsonTableGroupExcelResult(jP));
}
