private static DashboardFederationDataSource CreateFederatedDataSource(DashboardSqlDataSource sqlDS, DashboardExcelDataSource excelDS, DashboardObjectDataSource objDS, DashboardJsonDataSource jsonDS) { DashboardFederationDataSource federationDataSource = new DashboardFederationDataSource("Federated Data Source"); Source sqlSource = new Source("sqlSource", sqlDS, "SQL Orders"); Source excelSource = new Source("excelSource", excelDS, ""); Source objectSource = new Source("objectSource", objDS, ""); SourceNode jsonSourceNode = new SourceNode(new Source("json", jsonDS, "")); // Join SelectNode joinQuery = sqlSource.From() .Select("OrderDate", "ShipCity", "ShipCountry") .Join(excelSource, "[excelSource.OrderID] = [sqlSource.OrderID]") .Select("CategoryName", "ProductName", "Extended Price") .Join(objectSource, "[objectSource.Country] = [excelSource.Country]") .Select("Country", "UnitPrice") .Build("Join query"); federationDataSource.Queries.Add(joinQuery); // Union and UnionAll UnionNode queryUnionAll = sqlSource.From().Select("OrderID", "OrderDate").Build("OrdersSqlite") .UnionAll(excelSource.From().Select("OrderID", "OrderDate").Build("OrdersExcel")) .Build("OrdersUnionAll"); queryUnionAll.Alias = "Union query"; UnionNode queryUnion = sqlSource.From().Select("OrderID", "OrderDate").Build("OrdersSqlite") .Union(excelSource.From().Select("OrderID", "OrderDate").Build("OrdersExcel")) .Build("OrdersUnion"); queryUnion.Alias = "UnionAll query"; federationDataSource.Queries.Add(queryUnionAll); federationDataSource.Queries.Add(queryUnion); // Transformation TransformationNode unfoldNode = new TransformationNode(jsonSourceNode) { Alias = "Unfold", Rules = { new TransformationRule { ColumnName = "Products", Alias = "Product", Unfold = true, Flatten = false } } }; TransformationNode unfoldFlattenNode = new TransformationNode(jsonSourceNode) { Alias = "Unfold and Flatten", Rules = { new TransformationRule { ColumnName = "Products", Unfold = true, Flatten = true } } }; federationDataSource.Queries.Add(unfoldNode); federationDataSource.Queries.Add(unfoldFlattenNode); return(federationDataSource); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboardSql.SetDashboardStorage(dashboardFileStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. //ASPxDashboardSql.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); // Create a data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Register an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumnsFromTable() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Set the configured data source storage. ASPxDashboardSql.SetDataSourceStorage(dataSourceStorage); ASPxDashboardSql.InitialDashboardId = "dashboardSql"; }
protected void Application_Start() { DashboardDesignerConfig.RegisterService(RouteTable.Routes); AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); ModelBinders.Binders.DefaultBinder = new DevExpress.Web.Mvc.DevExpressEditorsBinder(); DevExpress.Web.ASPxWebControl.CallbackError += Application_Error; DataBaseEditaleDashboardStorage dataBaseDashboardStorage = new DataBaseEditaleDashboardStorage(MVCDashboardDesigner.Properties.Settings.Default.DashboardStorageConnection); DashboardConfigurator.Default.SetDashboardStorage(dataBaseDashboardStorage); DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source"); SelectQuery customerReportsQuery = SelectQueryFluentBuilder .AddTable("CustomerReports") .SelectColumn("CompanyName") .SelectColumn("ProductName") .SelectColumn("OrderDate") .SelectColumn("ProductAmount") .Build("CustomerReportsQuery"); sqlDataSource.Queries.Add(customerReportsQuery); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); DashboardConfigurator.Default.ConfigureDataConnection += DataApi_ConfigureDataConnection; }
private void Form1_Load(object sender, EventArgs e) { DashboardSqlDataSource dataSource = CreateDataSource(); dashboardViewer1.Dashboard = CreateDashboard(dataSource); dashboardViewer1.SetMasterFilter("comboBoxDashboardItem1", "Internet Explorer"); }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); DashboardSqlDataSource xmlDataSource = new DashboardSqlDataSource("XML Data Source", "xmlConnection"); SelectQuery countriesQuery = SelectQueryFluentBuilder .AddTable("Countries") .SelectColumns("Country", "Latitude", "Longitude", "Year", "EnergyType", "Production", "Import") .Build("Countries"); xmlDataSource.Queries.Add(countriesQuery); DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection"); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("xmlDataSource1", xmlDataSource.SaveToXml()); dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); DashboardConfigurator.Default.ConfigureDataConnection += Default_ConfigureDataConnection; }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //DashboardConfigurator.Default.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx"); excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx"); excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceName.StartsWith("ods|")) { string[] names = e.DataSourceName.Split("|".ToCharArray()); DashboardSqlDataSource dataSource = dataSources.First(ds => ds.ComponentName == names[1]); SqlQuery query = dataSource.Queries.First(q => q.Name == names[2]); XElement dsXML = dataSource.SaveToXml(); SqlDataSource sqlDS = new SqlDataSource(); sqlDS.LoadFromXml(dsXML); sqlDS.ConnectionName = "Connection"; sqlDS.Fill(query.Name); ResultSet rSet = ((IListSource)sqlDS).GetList() as ResultSet; ResultTable rTable = rSet.Tables.First(t => t.TableName == query.Name); if (query.Name == "Invoices") { var dt = ConvertResultTableToDataTable(rTable); for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (((DateTime)dt.Rows[i]["OrderDate"]).Year < 2016) { dt.Rows.RemoveAt(i); } } e.Data = dt; } else { e.Data = rTable; } } }
private void Dashboard_Parameter() { try { Dashboard dashboard = new Dashboard(); DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; CustomSqlQuery salesPersonQuery = (CustomSqlQuery)dataSource.Queries[0]; salesPersonQuery.Parameters[0].Value = "ProcessMaterialStockStatus"; //salesPersonQuery.Parameters.Add(new QueryParameter("window_name", typeof(Expression), // new Expression("[Parameters.yearParameter] + '/01/01'"))); //salesPersonQuery.Parameters.Add(new QueryParameter("endDate", typeof(Expression), // new Expression("[Parameters.yearParameter] + '/12/31'"))); //salesPersonQuery.Sql. = // "select * from SalesPerson where OrderDate between @startDate and @endDate"; dashboardViewer1.Dashboard = dashboard; } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } }
protected void Page_Load(object sender, EventArgs e) { //DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); //ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); ASPxDashboard1.SetDashboardStorage(SessionDashboardStorage.Instance); ASPxDashboard1.CustomExport += (s, args) => { ChartConstantLinesExtension.CustomExport(args); }; // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); ASPxDashboard1.ConfigureItemDataCalculation += (s, args) => { args.CalculateAllTotals = true; }; // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
public CustomDataSourceStorage() { DashboardSqlDataSource sqlDataSource1 = new DashboardSqlDataSource(sqlDataSourceId1, "NorthwindConnectionString"); SelectQuery query1 = SelectQueryFluentBuilder .AddTable("Categories") .SelectAllColumnsFromTable() .Build("Categories"); sqlDataSource1.Queries.Add(query1); SelectQuery query2 = SelectQueryFluentBuilder .AddTable("Products") .SelectAllColumnsFromTable() .Build("Products"); sqlDataSource1.Queries.Add(query2); DashboardSqlDataSource sqlDataSource2 = new DashboardSqlDataSource(sqlDataSourceId2, "CarsXtraSchedulingConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("Cars") .SelectAllColumnsFromTable() .Build("Cars"); sqlDataSource2.Queries.Add(query); DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource(jsonDataSourceId); jsonDataSource.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); jsonDataSource.RootElement = "Customers"; documents[sqlDataSourceId1] = new XDocument(sqlDataSource1.SaveToXml()); documents[sqlDataSourceId2] = new XDocument(sqlDataSource2.SaveToXml()); documents[jsonDataSourceId] = new XDocument(jsonDataSource.SaveToXml()); }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); // Creates a new dashboard parameter. StaticListLookUpSettings staticSettings = new StaticListLookUpSettings(); staticSettings.Values = new string[] { "1994", "1995", "1996" }; DashboardParameter yearParameter = new DashboardParameter("yearParameter", typeof(string), "1995", "Select year:", true, staticSettings); dashboard.Parameters.Add(yearParameter); DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; CustomSqlQuery salesPersonQuery = (CustomSqlQuery)dataSource.Queries[0]; salesPersonQuery.Parameters.Add(new QueryParameter("startDate", typeof(Expression), new Expression("[Parameters.yearParameter] + '/01/01'"))); salesPersonQuery.Parameters.Add(new QueryParameter("endDate", typeof(Expression), new Expression("[Parameters.yearParameter] + '/12/31'"))); salesPersonQuery.Sql = "select * from SalesPerson where OrderDate between @startDate and @endDate"; dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; GridDashboardItem grid = (GridDashboardItem)dashboard.Items[0]; // Create a new dashboard parameter. StaticListLookUpSettings settings = new StaticListLookUpSettings(); settings.Values = new string[] { "0.01", "0.05", "0.1" }; DashboardParameter discountValue = new DashboardParameter("discountValue", typeof(double), 0.05, "Select discount:", true, settings); dashboard.Parameters.Add(discountValue); // Create a new calculated field and pass the created dashboard parameter // to a calculated field expression. CalculatedField isGreater = new CalculatedField(); isGreater.DataMember = "SalesPerson"; isGreater.Name = "IsGreater"; isGreater.Expression = "ToStr(Iif(Avg([Discount]) >= [Parameters.discountValue], 'TRUE', 'FALSE'))"; dataSource.CalculatedFields.Add(isGreater); grid.Columns.Add(new GridMeasureColumn(new Measure("IsGreater"))); dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); CustomSqlQuery sqlQuery = new CustomSqlQuery("Countries", "select * from Countries"); dataSource.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\countriesDB.mdb", "", ""); dataSource.Queries.Add(sqlQuery); ChoroplethMapDashboardItem choroplethMap = new ChoroplethMapDashboardItem(); choroplethMap.DataSource = dataSource; choroplethMap.DataMember = "Countries"; choroplethMap.Area = ShapefileArea.WorldCountries; choroplethMap.AttributeName = "NAME"; choroplethMap.AttributeDimension = new Dimension("Country"); ValueMap populationMap = new ValueMap(new Measure("Population")); choroplethMap.Maps.Add(populationMap); dashboard.Items.Add(choroplethMap); dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); CustomSqlQuery sqlQuery = new CustomSqlQuery("Cities", "select * from Cities"); dataSource.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\Cities.mdb", "", ""); dataSource.Queries.Add(sqlQuery); GeoPointMapDashboardItem geopointMap = new GeoPointMapDashboardItem(); geopointMap.DataSource = dataSource; geopointMap.DataMember = "Cities"; geopointMap.Area = ShapefileArea.WorldCountries; geopointMap.Latitude = new Dimension("Latitude"); geopointMap.Longitude = new Dimension("Longitude"); geopointMap.Value = new Measure("Population"); dashboard.Items.Add(geopointMap); dashboardViewer1.Dashboard = dashboard; }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddResponseCompression() .AddDevExpressControls() .AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); return(configurator); }); }
static void UpdateDataSourceParametersNames(IDashboardDataSource dataSource, string originalNamePattern, string copyNamePattern) { DashboardSqlDataSource sqlDataSource = dataSource as DashboardSqlDataSource; if (sqlDataSource != null) { UpdateSqlDataSourceParameters(sqlDataSource, originalNamePattern, copyNamePattern); } }
static void UpdateSqlDataSourceParameters(DashboardSqlDataSource sqlDataSource, string originalNamePattern, string copyNamePattern) { foreach (SqlQuery query in sqlDataSource.Queries) { foreach (QueryParameter parameter in query.Parameters) { UpdateParameterExpression(parameter, originalNamePattern, copyNamePattern); } } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1); services.AddDevExpressControls(); services.AddMvc() .AddDefaultReportingControllers() .AddDefaultDashboardController((configurator, serviceProvider) => { configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = FileProvider.GetFileInfo("Data/Sales.xlsx").PhysicalPath; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.DataLoading += (s, e) => { if (e.DataSourceName == "Object Data Source") { e.Data = Invoices.CreateData(); } }; }); services.ConfigureReportingServices(configurator => { configurator.ConfigureReportDesigner(designerConfigurator => { designerConfigurator.RegisterDataSourceWizardConfigFileConnectionStringsProvider(); }); }); services.AddSpaStaticFiles(configuration => { configuration.RootPath = "ClientApp/dist"; }); }
private IDashboardDataSource CreateSqlDataSource() { DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("MySqlDataSource"); SelectQuery selectQuery = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectColumns("CategoryName", "SalesPerson", "OrderDate", "ExtendedPrice") .Build("MyQuery"); sqlDataSource.Queries.Add(selectQuery); return(sqlDataSource); }
public static void ConfigureDataSource(DataSourceInMemoryStorage storage) { // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumnsFromTable() .Build("Sales Person"); sqlDataSource.Queries.Add(query); storage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); }
public Form1() { InitializeComponent(); dashboardDesigner1.CreateRibbon(); DataConnectionParametersBase connParameters = CreateConnectionParameters("MSAccess"); DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source 1", connParameters); sqlDataSource.Queries.Add(CreateQuery("fluent")); sqlDataSource.Fill(); dashboardDesigner1.Dashboard = CreateDashboard(sqlDataSource); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddCors(options => { options.AddPolicy("AllowAnyOrigin", builder => { builder.AllowAnyOrigin(); builder.AllowAnyHeader(); builder.AllowAnyMethod(); }); }) .AddMvc(); services.AddDevExpressControls(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); //DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); //configurator.SetDashboardStorage(dashboardFileStorage); configurator.SetDashboardStorage(serviceProvider.GetService <SessionDashboardStorage>()); configurator.CustomExport += (s, e) => { ChartConstantLinesExtension.CustomExport(e); }; configurator.ConfigureItemDataCalculation += (s, e) => { e.CalculateAllTotals = true; }; DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); return(configurator); }); services .AddDistributedMemoryCache() .AddSession(); services.TryAddSingleton <IHttpContextAccessor, HttpContextAccessor>(); services.AddTransient <SessionDashboardStorage>(); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddCors(options => { options.AddPolicy("CorsPolicy", builder => { builder.WithOrigins("http://localhost:4200"); builder.WithMethods(new String[] { "GET", "POST" }); builder.WithHeaders("Content-Type"); }); }) .AddResponseCompression() .AddDevExpressControls() .AddMvc() .AddDefaultDashboardController((configurator, serviceProvider) => { configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = FileProvider.GetFileInfo("Data/Sales.xlsx").PhysicalPath; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.DataLoading += (s, e) => { if (e.DataSourceName == "Object Data Source") { e.Data = Invoices.CreateData(); } }; }); }
private void BindDataSource(Dashboard dashboard, DashboardSqlDataSource dashboardSqlDataSource) { dashboard.DataSources.Add(dashboardSqlDataSource); foreach (var item in dashboard.Items) { DataDashboardItem dataItem = item as DataDashboardItem; if (dataItem != null) { dataItem.DataSource = dashboardSqlDataSource; dataItem.DataMember = dashboardSqlDataSource.Queries[0].Name; } } }
private static DashboardSqlDataSource CreateDataSource() { DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); dataSource.ConnectionParameters = new XmlFileConnectionParameters(@"..\..\Data\WebsiteStatisticsData.xml"); SelectQuery selectQuery = SelectQueryFluentBuilder .AddTable("Data") .SelectColumns("Browser", "BrowserDetails", "Date", "Count") .Build("Statistics"); dataSource.Queries.Add(selectQuery); return(dataSource); }
public static void ConfigureDataSource(DataSourceInMemoryStorage storage) { // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumnsFromTable() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); storage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); }
// This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { services .AddMvc() .AddDefaultDashboardController((configurator, serviceProvider) => { //var connection = new SqlConnection(ConnectionString); var dashboardStorage = new DataBaseEditaleDashboardStorage(); configurator.SetDashboardStorage(dashboardStorage); var conexao = new SqlConnectionStringBuilder(Configuration.GetConnectionString("BrickConnStr")); conexao.UserID = "usr_cdis_report"; conexao.Password = "******"; var parameters = new CustomStringConnectionParameters(conexao.ConnectionString); var sqlDataSource = new DashboardSqlDataSource("Fonte de dados padrão", parameters); var dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); /*const string defaultSourceName = "Fonte de dados padrão"; * const string connectionName = "mssql-connection"; * var sqlDataSource = new DashboardSqlDataSource(defaultSourceName, connectionName); * var dataSourceStorage = new DataSourceInMemoryStorage(); * dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml()); * configurator.SetDataSourceStorage(dataSourceStorage); * * configurator.ConfigureDataConnection += (s, e) => * { * if (e.ConnectionName == connectionName) * { * var conexao = new SqlConnectionStringBuilder(ConnectionString); * conexao.UserID = "usr_cdis_report"; * conexao.Password = "******"; * e.ConnectionParameters = new CustomStringConnectionParameters(conexao.ConnectionString); * } * };*/ //configurator.SetConnectionStringsProvider(new MyDataSourceWizardConnectionStringsProvider()); configurator.ConfigureDataConnection += (s, e) => { }; configurator.AllowExecutingCustomSql = true; DashboardConfigurator.PassCredentials = true; }); services.AddDevExpressControls(settings => settings.Resources = ResourcesType.ThirdParty | ResourcesType.DevExtreme); }
public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "sqliteConnection"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; DevExpress.DataAccess.Sql.SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); return(dataSourceStorage); }
private static DashboardSqlDataSource CreateSQLiteDataSource() { SQLiteConnectionParameters sqliteParams = new SQLiteConnectionParameters(); sqliteParams.FileName = @"Data\nwind.db"; DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQLite Data Source", sqliteParams); SelectQuery selectQuery = SelectQueryFluentBuilder .AddTable("Orders") .SelectAllColumnsFromTable() .Build("SQLite Orders"); sqlDataSource.Queries.Add(selectQuery); sqlDataSource.Fill(); return(sqlDataSource); }