public ReportSchema GetReportSchema(Guid reportSessionID, int reportID) { var reportSchema = new ReportSchema(); ObjectParameter reportName = new ObjectParameter("reportName", typeof(string)); var reportParameters = dbContext.GetReportParameters(reportSessionID, reportID, reportName); List <SqlParameter> paramList = new List <SqlParameter>(); var report = dbContext.tbl_PM_reportMaster.Where(t => t.reportID == reportID).FirstOrDefault(); foreach (var reportParam in reportParameters) { var param = new SqlParameter("@" + reportParam.reportParamName, reportParam.inputType); param.Value = reportParam.reportParamValue; if (reportParam.reportParamName == "LoggedInUser" || reportParam.reportParamName == "LoggedInEmployee") { param.Value = Membership.GetUser().UserName; } paramList.Add(param); } reportSchema.Name = report.reportName; reportSchema.ProcName = report.rptSPName; reportSchema.FileName = report.rptFileName; reportSchema.ProcInputItemList = paramList; return(reportSchema); }
public HorizontalReportSchema <TSourceEntity> BuildSchema() { return(ReportSchema <TSourceEntity> .CreateHorizontal( this.CellsProviders .Select( r => new ReportSchemaCellsProvider <TSourceEntity>( r.Provider, r.CellProperties.ToArray(), r.HeaderProperties.ToArray(), r.CellProcessors.ToArray(), r.HeaderProcessors.ToArray())) .ToArray(), this.GlobalProperties.ToArray(), this.TableProperties.ToArray(), this.ComplexHeaders.ToArray(), this.ComplexHeadersProperties .ToDictionary(x => x.Key, x => x.Value.ToArray()), this.headerProviders .Select( r => new ReportSchemaCellsProvider <TSourceEntity>( r.Provider, r.CellProperties.ToArray(), r.HeaderProperties.ToArray(), r.CellProcessors.ToArray(), r.HeaderProcessors.ToArray())) .ToArray(), this.CommonComplexHeadersProperties.ToArray())); }
public IActionResult GetSchema(ReportRequest request) { var client = new SAWSessionServiceSoapClient(SAWSessionServiceSoapClient.EndpointConfiguration.SAWSessionServiceSoap, _config.GetValue <string>("SessionServiceUrl")); //var session = client.logonAsync("oracle.admin", "Burger01!").Result; var session = client.logonAsync("tperluss", "7Xo34%GN1XTZ94TI4cMT").Result; var svc = new XmlViewServiceSoapClient(XmlViewServiceSoapClient.EndpointConfiguration.XmlViewServiceSoap, _config.GetValue <string>("XmlServiceUrl")); request.ReportPath = HttpUtility.UrlDecode(request.ReportPath); var report = new ReportRef { reportPath = request.ReportPath }; var output = svc.executeXMLQueryAsync(report, XMLQueryOutputFormat.SAWRowsetSchema, new XMLQueryExecutionOptions(), new ReportParams(), session.sessionID).Result; var schema = Deserialize <rowsetschema>([email protected]("http://www.w3.org/2001/XMLSchema", "http://www.w3.org/2001/WB")); var resp = new ReportSchema { Columns = new List <ColumnSchema>(), ReportPath = request.ReportPath }; schema.schema.complexType.sequence.ToList().ForEach(a => { resp.Columns.Add(new ColumnSchema { ColumnId = a.columnID, IsDoubleColumn = a.isDoubleColumn, MaxOccurs = a.maxOccurs, MinOccurs = a.minOccurs, Name = a.name, TableHeading = a.tableHeading, ColumnHeading = a.columnHeading, Type = a.type.Replace("xsd:", ""), SqlType = a.type1 }); }); return(Ok(resp)); }
public GraphQlController(ReportSchema schema, IDocumentExecuter de) { //this.blogService = blogService; _reportSchema = schema; _de = de; }