private static void GetLimitOverwriteExport(string strReportDate, string strCtpy)
{
string subject = "\"Limit Overwrite Report\"";
string strFileName = "LimitOverwrite_" + strReportDate.Replace("/", "-");
string[] columnheaders = { "\"Date\"", "\"Trader\"", "\"Approver\"", "\"Comment\"", "\"DMK NO\"", "\"Counterparty\"", "\"Product\"", "\"Instrument\"", "\"Notional\"", "\"Currency\"", "\"Utilization (PCE)\"", "\"Over Limit\"", "\"Over amount\"" };
StringBuilder stringBuilder = new StringBuilder();
var records = ReportUIP.GetLimitOverwriteExport(SessionInfo, strReportDate, strCtpy);
foreach (DealViewModel record in records)
{
AddComma(record.EngineDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.Trader, stringBuilder);
AddComma(record.LimitApprover, stringBuilder);
AddComma(record.Remark, stringBuilder);
AddComma(record.DMK_NO, stringBuilder);
AddComma(record.Counterparty, stringBuilder);
AddComma(record.Product, stringBuilder);
AddComma(record.Instrument, stringBuilder);
AddComma(record.Notional1.Value.ToString("#,##0"), stringBuilder);
AddComma(record.CCY1, stringBuilder);
AddComma(record.KKContribute.Value.ToString("#,##0"), stringBuilder);
AddComma(record.LimitOverwrite, stringBuilder);
AddComma(record.LimitOverAmount, stringBuilder, true);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(subject, columnheaders, stringBuilder, strFileName);
}
private static void GetRepoExport(string strReportDate, string strTitle, string strReportType, string strCtpy)
{
string strFileName = "Repo_" + (strReportType != "" ? "BOD_" : "Intraday_") + strReportDate.Replace("/", "-");
string[] columnheaders = { "\"Report Date\"", "\"CTPY\"", "\"Limit\"", "\"Limit Amt\""//, "\"Expiry\"", "\"OS\""
, "\"Available\"", "\"RRP\""
, "\"RP_GOV_0-5\"", "\"RP_GOV_5-10\"", "\"RP_GOV_10-20\"", "\"RP_GOV_20+\""
, "\"RP_S0E_0-5\"", "\"RP_SOE_5-10\"", "\"RP_SOE_10-20\"", "\"RP_SOE_20+\"" };
StringBuilder stringBuilder = new StringBuilder();
var records = ReportUIP.GetRepoExport(SessionInfo, strReportDate, strReportType, strCtpy);
foreach (RepoReportModel record in records)
{
AddComma(record.PROCESSING_DATE.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.SNAME, stringBuilder);
AddComma(record.LIMIT_LABEL, stringBuilder);
AddComma(record.AMOUNT.ToString("#,##0"), stringBuilder);
//AddComma(record.EXPIRE_DATE.ToString("dd-MMM-yyyy"), stringBuilder);
//AddComma(record.ORIGINAL_KK_CONTRIBUTE.ToString("#,##0"), stringBuilder);
AddComma(record.AVAILABLE.ToString("#,##0"), stringBuilder);
AddComma(record.REV_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_GOV_5_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_GOV_10_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_GOV_20_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_GOV_20s_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_SOE_5_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_SOE_10_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_SOE_20_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.REP_SOE_20s_AMOUNT.ToString("#,##0"), stringBuilder);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(strTitle, columnheaders, stringBuilder, strFileName);
}
private static void GetSCEDetailExport(string strReportDate, string strTitle, string strReportType, string strCtpy, string strProduct)
{
string strFileName = "SCEDetail_" + (strReportType != "" ? "BOD" : "Intraday") + "_" + strReportDate.Replace("/", "-");
string[] columnheaders = { "\"Report Date\"", "\"DMK NO\"", "\"OPICS NO\"", "\"Product\"", "\"Instrument\"", "\"Counterparty\"", "\"Notional\"", "\"Trade Date\"", "\"Effective Date\"", "\"Maturity Date\"", "\"Leg\"", "\"Seq\"", "\"Rate\"", "\"Flow Date\"", "\"Flow Amount\"", "\"Utilization\"" };
StringBuilder stringBuilder = new StringBuilder();
List <DealViewModel> records = ReportUIP.GetSCEDetailExport(SessionInfo, strReportDate, strCtpy, strProduct, strReportType);
foreach (DealViewModel record in records)
{
AddComma(record.EngineDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.DMK_NO, stringBuilder);
AddComma(record.OPICS_NO, stringBuilder);
AddComma(record.Product, stringBuilder);
AddComma(record.Instrument, stringBuilder);
AddComma(record.Counterparty, stringBuilder);
AddComma(record.Notional1.HasValue ? record.Notional1.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.TradeDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.EffectiveDate.HasValue ? record.EffectiveDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.MaturityDate.HasValue ? record.MaturityDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.Leg.ToString(), stringBuilder);
AddComma(record.Seq.ToString(), stringBuilder);
AddComma(record.CashflowRate.HasValue ? record.CashflowRate.Value.ToString("#,##0.0000") : string.Empty, stringBuilder);
AddComma(record.CashflowDate.HasValue ? record.CashflowDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.CashflowAmount.HasValue ? record.CashflowAmount.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.KKContribute.Value.ToString("#,##0"), stringBuilder);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(strTitle, columnheaders, stringBuilder, strFileName);
}
private static void GetPCEDetailExport(string strReportDate, string strTitle, string strReportType, string strCtpy, string strProduct)
{
string strFileName = "PCEDetail_" + (strReportType != "" ? "BOD" : "Intraday") + "_" + strReportDate.Replace("/", "-");
string[] columnheaders = { "\"Report Date\"", "\"DMK NO\"", "\"OPICS NO\"", "\"Source\"", "\"Product\"", "\"Portfolio\"", "\"Trade Date\"", "\"Effective Date\"", "\"Maturity Date\"", "\"Instrument\"", "\"Counterparty\"", "\"Country\"", "\"Leg 1\"", "\"Notional1\"", "\"CCY1\"", "\"Leg 2\"", "\"Notional2\"", "\"CCY2\"", "\"PCCF\"", "\"Contribute\"", "\"CSA\"" };
StringBuilder stringBuilder = new StringBuilder();
List <DealViewModel> records = ReportUIP.GetPCEDetailExport(SessionInfo, strReportDate, strCtpy, strProduct, strReportType);
foreach (DealViewModel record in records)
{
AddComma(record.EngineDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.DMK_NO, stringBuilder);
AddComma(record.OPICS_NO, stringBuilder);
AddComma(record.Source, stringBuilder);
AddComma(record.Product, stringBuilder);
AddComma(record.Portfolio, stringBuilder);
AddComma(record.TradeDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.EffectiveDate.HasValue ? record.EffectiveDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.MaturityDate.HasValue ? record.MaturityDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.Instrument, stringBuilder);
AddComma(record.Counterparty, stringBuilder);
AddComma(record.Country, stringBuilder);
AddComma(record.FixedFloat1, stringBuilder);
AddComma(record.Notional1.HasValue ? record.Notional1.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.CCY1, stringBuilder);
AddComma(record.FixedFloat2, stringBuilder);
AddComma(record.Notional2.HasValue ? record.Notional2.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.CCY2, stringBuilder);
AddComma(record.KKPCCF.HasValue ? record.KKPCCF.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.KKContribute.HasValue ? record.KKContribute.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.CSA, stringBuilder);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(strTitle, columnheaders, stringBuilder, strFileName);
}
private static void GetLimitAuditExport(string strReportDate, string strReportDateto, string strCtpy, string strCountry, string strEvent)
{
string subject = "\"Limit Audit Report\"";
string strFileName = "LimitAudit_" + strReportDate.Replace("/", "-") + "to" + strReportDateto.Replace("/", "-");
string[] columnheaders = { "\"Log Date\"", "\"Entity\"", "\"Limit Type\"", "\"User\"", "\"Detail\"" };
StringBuilder stringBuilder = new StringBuilder();
var records = ReportUIP.GetLimitAuditExport(SessionInfo, strReportDate, strReportDateto, strCtpy, strCountry, strEvent);
foreach (LimitAuditReportModel record in records)
{
AddComma(record.LOG_DATE.ToString("dd-MMM-yyyy HH:mm"), stringBuilder);
AddComma(record.ENTITY, stringBuilder);
AddComma(record.LIMIT, stringBuilder);
AddComma(record.USER, stringBuilder);
AddComma(record.DETAIL, stringBuilder, true);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(subject, columnheaders, stringBuilder, strFileName);
}
private static void GetSCEExport(string strReportDate, string strTitle, string strReportType, string strCtpy, string strStatus)
{
string strFileName = "SCE_" + (strReportType != "" ? "BOD" : "Intraday") + "_" + strReportDate.Replace("/", "-");
string[] columnheaders = { "\"Report Date\"", "\"Counterparty\"", "\"Expired Date\"", "\"Limit Amount\"", "\"Temp Amount\"", "\"Utilization\"", "\"Utilization Date\"", "\"Available\"", "\"Status\"" };
StringBuilder stringBuilder = new StringBuilder();
List <LimitCheckModel> records = ReportUIP.GetSCEExport(SessionInfo, strReportDate, strCtpy, strReportType, strStatus);
foreach (LimitCheckModel record in records)
{
AddComma(record.PROCESSING_DATE.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.SNAME, stringBuilder);
AddComma(record.EXPIRE_DATE.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.GEN_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.TEMP_AMOUNT.ToString("#,##0"), stringBuilder);
AddComma(record.ORIGINAL_KK_CONTRIBUTE.ToString("#,##0"), stringBuilder);
AddComma(record.FLOW_DATE.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.AVAILABLE.ToString("#,##0"), stringBuilder);
AddComma(record.STATUS, stringBuilder, true);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(strTitle, columnheaders, stringBuilder, strFileName);
}
public static object GetPCEReport(string strReportDate, string strReportType, string strCtpy, string strLimit, string strStatus, int jtStartIndex, int jtPageSize)
{
return(ReportUIP.GetPCEReport(SessionInfo, strReportDate, strCtpy, strLimit, strReportType, strStatus, jtStartIndex, jtPageSize));
}
public static object GetLimitAuditReport(string strLogDatefrom, string strLogDateto, string strCtpy, string strCountry, string strEvent, int jtStartIndex, int jtPageSize)
{
return(ReportUIP.GetLimitAuditReport(SessionInfo, strLogDatefrom, strLogDateto, strCtpy, strCountry, strEvent, jtStartIndex, jtPageSize));
}
public static object GetLimitOverwriteReport(string strReportDate, string strCtpy, int jtStartIndex, int jtPageSize)
{
return(ReportUIP.GetLimitOverwriteReport(SessionInfo, strReportDate, strCtpy, jtStartIndex, jtPageSize));
}
public static object GetSCEDetailReport(string strReportDate, string strReportType, string strCtpy, string strProduct, int jtStartIndex, int jtPageSize)
{
return(ReportUIP.GetSCEDetailReport(SessionInfo, strReportDate, strCtpy, strProduct, strReportType, jtStartIndex, jtPageSize));
}
private static void GetDealViewExport(string strDMKNo
, string strOPICNo
, string strProduct
, string strCtpy
, string strPortfolio
, string strTradeDate
, string strEffDate
, string strMatDate
, string strInstrument
, string strUser
, string strStatus
, string strOverStatus
, string strProcDate
, string strSettleStatus)
{
string subject = string.Empty;
string strFileName = "DealReport";
string[] columnheaders = { "\"LimitOverwrite\"", "\"LimitApprover\"", "\"Entry Date\"",
"\"DMK NO\"", "\"OPICS NO\"", "\"Trade Date\"",
"\"Effective Date\"", "\"Instrument\"", "\"Limit End Date\"",
"\"B/S\"", "\"Product\"", "\"Portfolio\"",
"\"CTPY\"", "\"Notional1\"", "\"Ccy1\"", "\"PayRec1\"",
"\"FixedFloat1\"", "\"Freq1\"", "\"Fixing1\"", "\"Rate1\"",
"\"SwapPoint1\"", "\"Notional2\"", "\"Ccy2\"", "\"PayRec2\"",
"\"FixedFloat2\"", "\"Freq2\"", "\"Fixing2\"", "\"Rate2\"",
"\"SwapPoint2\"", "\"Trader\"", "\"OpicsTrader\"", "\"Status\"",
"\"PCE Amount\"", "\"SET\"", "\"TBMA\"", "\"Comment\"" };
StringBuilder stringBuilder = new StringBuilder();
List <DealViewModel> records = ReportUIP.GetDealViewExport(SessionInfo
, strDMKNo
, strOPICNo
, strProduct
, strCtpy
, strPortfolio
, strTradeDate
, strEffDate
, strMatDate
, strInstrument
, strUser
, strStatus
, strOverStatus
, strProcDate
, strSettleStatus);
foreach (DealViewModel record in records)
{
AddComma(record.LimitOverwrite, stringBuilder);
AddComma(record.LimitApprover, stringBuilder);
AddComma(record.EntryDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.DMK_NO, stringBuilder);
AddComma(record.OPICS_NO, stringBuilder);
AddComma(record.TradeDate.ToString("dd-MMM-yyyy"), stringBuilder);
AddComma(record.EffectiveDate.HasValue ? record.EffectiveDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.Instrument, stringBuilder);
AddComma(record.MaturityDate.HasValue ? record.MaturityDate.Value.ToString("dd-MMM-yyyy") : string.Empty, stringBuilder);
AddComma(record.BuySell, stringBuilder);
AddComma(record.Product, stringBuilder);
AddComma(record.Portfolio, stringBuilder);
AddComma(record.Counterparty, stringBuilder);
AddComma(record.Notional1.HasValue ? record.Notional1.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.CCY1, stringBuilder);
AddComma(record.PayRec1, stringBuilder);
AddComma(record.FixedFloat1, stringBuilder);
AddComma(record.Freq1, stringBuilder);
AddComma(record.Fixing1.HasValue ? record.Fixing1.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.Rate1.HasValue ? record.Rate1.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.SwapPoint1.HasValue ? record.SwapPoint1.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.Notional2.HasValue ? record.Notional2.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.CCY2, stringBuilder);
AddComma(record.PayRec2, stringBuilder);
AddComma(record.FixedFloat2, stringBuilder);
AddComma(record.Freq2, stringBuilder);
AddComma(record.Fixing2.HasValue ? record.Fixing2.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.Rate2.HasValue ? record.Rate2.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.SwapPoint2.HasValue ? record.SwapPoint2.Value.ToString("#,##0.00") : string.Empty, stringBuilder);
AddComma(record.Trader, stringBuilder);
AddComma(record.OpicsTrader, stringBuilder);
AddComma(record.Status, stringBuilder);
AddComma(record.KKContribute.HasValue ? record.KKContribute.Value.ToString("#,##0") : string.Empty, stringBuilder);
AddComma(record.SettlementLimit, stringBuilder);
AddComma(record.TBMA_SENT, stringBuilder);
AddComma(record.Remark, stringBuilder);
stringBuilder.Append(Environment.NewLine);
}
WriteCSVFile(subject, columnheaders, stringBuilder, strFileName);
}