public async Task <ActionResult> ReprintJournalDetails([FromQuery] int batch, [FromQuery] int org, [FromQuery] string source)
{
try
{
object[] FlatParams = new object[9];
FlatParams[0] = "@Batch";
FlatParams[1] = "int";
FlatParams[2] = batch;
FlatParams[3] = "@Org";
FlatParams[4] = "int";
FlatParams[5] = org;
FlatParams[6] = "@Source";
FlatParams[7] = "varchar";
FlatParams[8] = source;
object[] Grouping = new object[15];
string SortOrder = String.Empty;
string Filter = String.Empty;
if (_options.IncludeAuth)
{
var request1 = new RepGen96.GenerateReportRequest(_authInfo, "Report_Menu_Params", new object[] { "Journal_Report.rpx", -100, "pe_NL_rpt_Journal", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client96.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen96.ExportToPDFRequest(_authInfo, response1.GenerateReportResult);
request2.AuthenticationInformation = _authInfo;
var response2 = await _client96.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "journal_report.pdf"));
}
else
{
var request1 = new RepGen95.GenerateReportRequest("Report_Menu_Params", new object[] { "Journal_Report.rpx", -100, "pe_NL_rpt_Journal", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client95.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen95.ExportToPDFRequest(response1.GenerateReportResult);
var response2 = await _client95.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "journal_report.pdf"));
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message, ex);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> JournalReport()
{
try
{
object[] FlatParams = new object[0];
object[] Grouping = new object[15];
string SortOrder = String.Empty;
string Filter = String.Empty;
if (_options.IncludeAuth)
{
var request1 = new RepGen96.GenerateReportRequest(_authInfo, "Report_Menu_Params", new object[] { "Journal_Report.rpx", -100, "pe_NL_rpt_Journal", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client96.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen96.ExportToPDFRequest(_authInfo, response1.GenerateReportResult);
var response2 = await _client96.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "journal_report.pdf"));
}
else
{
var request1 = new RepGen95.GenerateReportRequest("Report_Menu_Params", new object[] { "Journal_Report.rpx", -100, "pe_NL_rpt_Journal", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client95.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen95.ExportToPDFRequest(response1.GenerateReportResult);
var response2 = await _client95.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "journal_report.pdf"));
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message, ex);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> DetailReport([FromQuery] int org, [FromQuery] string source, [FromQuery] string section, [FromQuery] string account, [FromQuery] string office, [FromQuery] string service, [FromQuery] int partner, [FromQuery] string dept, [FromQuery] DateTime start, [FromQuery] DateTime end)
{
try
{
object[] FlatParams = new object[30];
FlatParams[0] = "@OrgID";
FlatParams[1] = "int";
FlatParams[2] = org;
FlatParams[3] = "@Source";
FlatParams[4] = "varchar";
FlatParams[5] = source;
FlatParams[6] = "@Section";
FlatParams[7] = "varchar";
FlatParams[8] = section;
FlatParams[9] = "@Account";
FlatParams[10] = "varchar";
FlatParams[11] = account;
FlatParams[12] = "@Office";
FlatParams[13] = "varchar";
FlatParams[14] = office;
FlatParams[15] = "@Service";
FlatParams[16] = "varchar";
FlatParams[17] = service;
FlatParams[18] = "@Partner";
FlatParams[19] = "int";
FlatParams[20] = partner;
FlatParams[21] = "@Department";
FlatParams[22] = "varchar";
FlatParams[23] = dept;
FlatParams[24] = "@FromDate";
FlatParams[25] = "datetime";
FlatParams[26] = start;
FlatParams[27] = "@ToDate";
FlatParams[28] = "datetime";
FlatParams[29] = end;
object[] Grouping = new object[15];
string SortOrder = String.Empty;
string Filter = String.Empty;
if (_options.IncludeAuth)
{
var request1 = new RepGen96.GenerateReportRequest(_authInfo, "Report_Menu_Params", new object[] { "Journal_Report.rpx", -100, "pe_NL_rpt_Journal", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client96.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen96.ExportToPDFRequest(_authInfo, response1.GenerateReportResult);
var response2 = await _client96.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "Detail_Report.pdf"));
}
else
{
var request1 = new RepGen95.GenerateReportRequest("Report_Menu_Params", new object[] { "Detail_Report.rpx", -100, "pe_NL_Detail_Report", FlatParams, SortOrder, Filter, Grouping, _connOptions.EncryptedConnectionString }, "GL System", "-100", false, String.Empty);
var response1 = await _client95.GenerateReportAsync(request1);
if (!String.IsNullOrWhiteSpace(response1.Error))
{
throw new Exception(response1.Error);
}
var request2 = new RepGen95.ExportToPDFRequest(response1.GenerateReportResult);
var response2 = await _client95.ExportToPDFAsync(request2);
return(File(response2.ExportToPDFResult, "application/pdf", "Detail_Report.pdf"));
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message, ex);
return(BadRequest(ex.Message));
}
}