public static void ExportPDF(string reportFileName, DataTable dataSource, string reportDataSourceName, string pdfFileName)
{
using (FileStream fileStream = new FileStream(pdfFileName, FileMode.Create))
{
PDFHelper.ExportPDF(reportFileName, dataSource, reportDataSourceName, fileStream);
}
}
private static void CreateLedger(object state)
{
LedgerArgument ledgerArgument = (LedgerArgument)state;
Token token = ledgerArgument.Token;
string sql = "EXEC P_RptLedger @xmlAccounts=\'" + XmlTransform.Transform(ledgerArgument.IDs, ',', "Accounts", "Account", "ID") + "\',@tradeDayBegin=\'"
+ ledgerArgument.DateFrom + "\',@tradeDayTo=\'" + ledgerArgument.DateTo + "\',@language=\'" + ledgerArgument.Version + "\',@userID=\'" + ledgerArgument.Token.UserID.ToString() + "\'";
try
{
DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, LedgerReportTimeout);
try
{
TradingConsoleServer tradingConsoleServer = ledgerArgument.TradingConsoleServer;
tradingConsoleServer.SaveLedger(token, "", ledgerArgument.IDs);
}
catch
{
}
if (dataSet.Tables.Count > 0)
{
string filepath = Path.Combine(SettingManager.Default.PhysicPath, ledgerArgument.Rdlc); //this.Server.MapPath(ledgerArgument.Rdlc);
byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]);
AsyncResultManager asyncResultManager = ledgerArgument.AsyncResultManager;
asyncResultManager.SetResult(ledgerArgument.AsyncResult, reportContent);
CommandManager.Default.AddCommand(new AsyncCommand(0, ledgerArgument.AsyncResult));
}
}
catch (System.Exception ex)
{
CommandManager.Default.AddCommand(new AsyncCommand(0, ledgerArgument.AsyncResult, true, ex));
_Logger.Error(ex);
}
}
private static void CreateAccountSummary(object state)
{
AccountSummaryArgument accountSummaryArgument = (AccountSummaryArgument)state;
Token token = accountSummaryArgument.Token;
string sql = "EXEC P_RptAccountSummary @xmlAccounts=\'" + XmlTransform.Transform(accountSummaryArgument.AccountIds, ',', "Accounts", "Account", "ID") + "\',@tradeDayFrom=\'"
+ accountSummaryArgument.FromDay + "\',@tradeDayTo=\'" + accountSummaryArgument.ToDay + "\',@language=\'" + accountSummaryArgument.Version + "\',@userID=\'" + accountSummaryArgument.Token.UserID.ToString() + "\', @skipNoTransactionAccount=0";
try
{
DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, LedgerReportTimeout);
if (dataSet.Tables.Count > 0)
{
string filepath = Path.Combine(SettingManager.Default.PhysicPath, accountSummaryArgument.Rdlc);
//this.Server.MapPath(accountSummaryArgument.Rdlc);
byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]);
AsyncResultManager asyncResultManager = accountSummaryArgument.AsyncResultManager;
asyncResultManager.SetResult(accountSummaryArgument.AsyncResult, reportContent);
CommandManager.Default.AddCommand(new AsyncCommand(0, accountSummaryArgument.AsyncResult));
}
}
catch (System.Exception ex)
{
CommandManager.Default.AddCommand(new AsyncCommand(0, accountSummaryArgument.AsyncResult, true, ex));
_Logger.Error(ex);
}
}
public static void ExportPDF(string reportFileName, DataTable dataSource, string reportDataSourceName, Stream fileStream)
{
LocalReport localReport = PDFHelper.CreateLocalReport(reportFileName, dataSource, reportDataSourceName);
PDFHelper.ExportPDF(localReport, fileStream);
}
public static void ExportPDF(string reportFileName, DataTable dataSource, Stream fileStream)
{
PDFHelper.ExportPDF(reportFileName, dataSource, "Default", fileStream);
}
public static void ExportPDF2(string reportFileName, DataTable dataSource, string pdfFileName)
{
PDFHelper.ExportPDF(reportFileName, dataSource, "Default", pdfFileName);
}
public static byte[] ExportPDF(string reportFileName, DataTable dataSource)
{
return(PDFHelper.ExportPDF(reportFileName, dataSource, "Default"));
}
private static void CreateStatement(object state)
{
StatementArg statementArg = (StatementArg)state;
Token token = statementArg.Token;
string sql = string.Empty;
if (statementArg.Rdlc.ToLower().Contains("statement_mc"))
{
sql = "EXEC P_RptStatement_RC2 ";
}
else
{
switch (statementArg.StatementReportType)
{
case 0:
sql = "EXEC P_RptStatement_RC2 ";
break;
case 1:
sql = "EXEC P_RptStatement2_RC2 ";
break;
case 2:
sql = "EXEC P_RptStatement4_RC2 ";
break;
case 3:
sql = "EXEC P_RptStatement5_RC2 ";
break;
}
}
sql += "@xmlAccounts=" + "\'" + XmlTransform.Transform(statementArg.IDs, ',', "Accounts", "Account", "ID")
+ "\',@tradeDayBegin=\'" + statementArg.DayBegin + "\',@tradeDayTo=\'" + statementArg.DayTo + "\',@language=\'" + statementArg.Version + "\',@userID=\'" + statementArg.Token.UserID.ToString() + "\'";
try
{
DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, StatementReportTimeout);
try
{
TradingConsoleServer tradingConsoleServer = statementArg.TradingConsoleServer;
tradingConsoleServer.SaveStatement(token, "", statementArg.IDs);
}
catch
{
}
if (dataSet.Tables.Count > 0)
{
string filepath = Path.Combine(SettingManager.Default.PhysicPath, statementArg.Rdlc); // this.Server.MapPath(statementArg.Rdlc);
Console.WriteLine(filepath);
if (statementArg.Rdlc.ToLower().Contains("statement_mc") && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
if (!(bool)dataSet.Tables[0].Rows[0]["IsMultiCurrency"])
{
filepath = filepath.ToLower().Replace("rptStatement_mc.rdlc", "RptStatement.rdlc");
}
}
byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]);
AsyncResultManager asyncResultManager = statementArg.AsyncResultManager;
asyncResultManager.SetResult(statementArg.AsyncResult, reportContent);
CommandManager.Default.AddCommand(new AsyncCommand(0, statementArg.AsyncResult));
}
}
catch (System.Exception ex)
{
CommandManager.Default.AddCommand(new AsyncCommand(0, statementArg.AsyncResult, true, ex));
_Logger.Error(ex);
}
}
