/// <summary>TBD</summary>
 /// <param name="customerId">TBD</param>
 /// <param name="results">TBD</param>        
 public void GetWebResponse(string companyId, string customerId, out byte[] results)
 {
     SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005();
     SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService();
     reportingService.Credentials = CredentialCache.DefaultCredentials;
     reportExecService.Credentials = CredentialCache.DefaultCredentials;
     results = null;
     string historyId = null;
     string _historyId = null;
     string deviceInfo = null;
     string format = "EXCEL";
     string encoding = string.Empty;
     string mimeType = string.Empty;
     string extension = string.Empty;
     string[] streamIDs = null;
     string reportName = "/TOD - Custom Reports/Billing Credits and Payments by Account";
     bool _forRendering = false;
     SSRS_Reporting.Warning[] warnings = null;
     SSRS_Reporting.ParameterValue[] _values = null;
     SSRS_Reporting.DataSourceCredentials[] _credentials = null;
     SSRS_Reporting.ReportParameter[] _parameters = null;
     try
     {
         _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials);
         SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId);
         SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[_parameters.Length];
         if (_parameters.Length > 0)
         {
             parameters[0] = new SSRS_Reporting.ParameterValue();
             parameters[0].Label = "companyId";
             parameters[0].Name = "companyId";
             parameters[0].Value = companyId;
             parameters[1] = new SSRS_Reporting.ParameterValue();
             parameters[1].Label = "lookupType";
             parameters[1].Name = "lookupType";
             parameters[1].Value = lookupType.Value;
             parameters[2] = new SSRS_Reporting.ParameterValue();
             parameters[2].Label = "searchText";
             parameters[2].Name = "searchText";
             parameters[2].Value = searchText.Value;
             parameters[3] = new SSRS_Reporting.ParameterValue();
             parameters[3].Label = "customerId";
             parameters[3].Name = "customerId";
             parameters[3].Value = customerId;
         }
         SSRS_Reporting.ExecutionInfo execInfo = reportExecService.SetExecutionParameters(parameters, "en-us");
         results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
     }
     catch (Exception ex)
     {
         WebCommon.LogExceptionInfo(ex);
     }
 }
Ejemplo n.º 2
0
 /// <summary>TBD</summary>
 /// <param name="invoiceNumber">TBD</param>
 /// <param name="results">TBD</param>
 public void GetWebResponse(string invoiceNumber, int companyId, out byte[] results)
 {
     SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005();
     SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService();
     reportingService.Credentials = CredentialCache.DefaultCredentials;
     reportExecService.Credentials = CredentialCache.DefaultCredentials;
     results = null;
     string historyId = null;
     string _historyId = null;
     string deviceInfo = null;
     string format = "PDF";
     string encoding = string.Empty;
     string mimeType = string.Empty;
     string extension = string.Empty;
     string[] streamIDs = null;
     string reportName = (companyId == 1 ? "/SDS_Test/_wip/InvoiceReprint_WIP" : "/SDS_Test/_wip/InvoiceReprintCanada_WIP");
     bool _forRendering = false;
     SSRS_Reporting.Warning[] warnings = null;
     SSRS_Reporting.ParameterValue[] _values = null;
     SSRS_Reporting.DataSourceCredentials[] _credentials = null;
     SSRS_Reporting.ReportParameter[] _parameters = null;
     try
     {
         _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials);
         SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId);
         SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[1];
         if (_parameters.Length > 0)
         {
             parameters[0] = new SSRS_Reporting.ParameterValue();
             parameters[0].Label = "invoiceNumber";
             parameters[0].Name = "invoiceNumber";
             parameters[0].Value = invoiceNumber;
         }
         reportExecService.SetExecutionParameters(parameters, "en-us");
         results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
         //Response.Clear();
         //Response.ContentType = "application/octet-stream";
         //Response.AddHeader("content-disposition", "attachment; filename=test.PDF");
         //Response.Write(results);
         //Response.Flush();
     }
     catch (Exception ex)
     {
         WebCommon.LogExceptionInfo(ex);
     }
 }
        /// <summary>TBD</summary>
        /// <param name="customerId">TBD</param>
        /// <param name="results">TBD</param>        
        public void GetWebResponse(string contractNumber, out byte[] results)
        {
            SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005();
            SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService();
            reportingService.Credentials = CredentialCache.DefaultCredentials;
            reportExecService.Credentials = CredentialCache.DefaultCredentials;
            results = null;
            string historyId = null;
            string _historyId = null;
            string deviceInfo = null;
            string format = "EXCEL";
            string encoding = string.Empty;
            string mimeType = string.Empty;
            string extension = string.Empty;
            string[] streamIDs = null;
            string reportName = "/TOD - Custom Reports/ContractSummary_PostingSchedule";
            bool _forRendering = false;
            SSRS_Reporting.Warning[] warnings = null;
            SSRS_Reporting.ParameterValue[] _values = null;
            SSRS_Reporting.DataSourceCredentials[] _credentials = null;
            SSRS_Reporting.ReportParameter[] _parameters = null;
            try
            {
                _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials);
                SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId);
                SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[_parameters.Length];
                if (_parameters.Length > 0)
                {
                    parameters[0] = new SSRS_Reporting.ParameterValue();
                    parameters[0].Label = "contractNumber";
                    parameters[0].Name = "contractNumber";
                    parameters[0].Value = contractNumber;

                }
                SSRS_Reporting.ExecutionInfo execInfo = reportExecService.SetExecutionParameters(parameters, "en-us");
                results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
            }
            catch (Exception ex)
            {
                WebCommon.LogExceptionInfo(ex);
            }
        }