Beispiel #1
0
        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));
            }
        }
Beispiel #2
0
        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));
            }
        }
Beispiel #3
0
        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));
            }
        }