protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); using (Workbook workbook = new Workbook()) { Directory .EnumerateFiles(HostingEnvironment.MapPath(@"~/App_Data/ExcelFiles/"), "*.xlsx") .SelectMany(file => { workbook.LoadDocument(file); return(workbook.Worksheets.Select(sheet => { var dataSourceId = string.Format("{0} - {1}", Path.GetFileNameWithoutExtension(file), sheet.Name); var excelDataSource = new DashboardExcelDataSource(dataSourceId); excelDataSource.ConnectionName = dataSourceId; excelDataSource.FileName = file; var worksheetSettings = new ExcelWorksheetSettings() { WorksheetName = sheet.Name }; excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings); return new { Name = excelDataSource.Name, Xml = excelDataSource.SaveToXml() }; })); }) .ToList() .ForEach(ds => dataSourceStorage.RegisterDataSource(ds.Name, ds.Xml)); } ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
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); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); ASPxDashboard1.AllowExecutingCustomSql = true; ASPxDashboard1.EnableCustomSql = true; ASPxDashboard1.WorkingMode = WorkingMode.Viewer; }
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); }
protected void Page_Load(object sender, EventArgs e) { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("extractDataSource", CreateExtractDataSource().SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { // Button BackButton = (Button)Master.FindControl("back"); // BackButton.Enabled = false; // BackButton.Visible = false; ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); string uname = HttpContext.Current.User.Identity.Name; conn = new SqlConnection("server=10.100.100.25\\SPLAHOST;Database=graphs;Integrated Security=false;User ID=petpakn;Password=net123321!;"); conn.Open(); // Create SqlCommand to select pwd field from users table given supplied userName. cmd = new SqlCommand($"select userRole from Users where uname='{uname}'", conn); /// Intepolation or the F string. C# > 5.0 // Execute command and fetch pwd field into lookupPassword string. var sdr = cmd.ExecuteScalar(); var user = sdr.ToString(); if (user == "SuperAdmin") { ASPxDashboard1.WorkingMode = WorkingMode.Designer; } else { ASPxDashboard1.WorkingMode = WorkingMode.Viewer; } }
protected void Page_Load(object sender, EventArgs e) { //DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data"); //ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DashboardFileStorage dashboard = new DashboardFileStorage(GetVirtualPath(Server.MapPath("~/Dashboards"))); ASPxDashboard1.SetDashboardStorage(dashboard); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage storage = new DashboardFileStorage(dashboardsPath); ASPxDashboard1.SetDashboardStorage(storage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource(DataSourceGenerator.CreateNWindDataSource().SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection"); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("olapDataSource", olapDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("extractDataSource", CreateExtractDataSource().SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); if (!File.Exists(extractFileName)) { using (var ds = CreateExtractDataSource()) { ds.UpdateExtractFile(); } } }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); ASPxDashboard1.ServiceContainer.AddService(typeof(IObjectDataSourceCustomFillService), new CustomObjectDataSourceCustomFillService()); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage newDashboardStorage = new DashboardFileStorage(HostingEnvironment.MapPath(@"~/App_Data/Dashboards")); ASPxDashboard1.SetDashboardStorage(newDashboardStorage); ASPxDashboard1.SetConnectionStringsProvider(new ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardExtractDataSource extractDataSource = new DashboardExtractDataSource("Extract Data Source"); extractDataSource.ConnectionName = "edsSales"; dataSourceStorage.RegisterDataSource("extractDataSource", extractDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataId = "odsSales"; objDataSource.DataSource = typeof(SalesPersonData); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); ASPxDashboard1.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(); // Configures an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("Orders") .SelectAllColumnsFromTable() .Build("SQL Orders"); sqlDataSource.Queries.Add(query); // Configures an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataId = "odsInvoices"; // Configures an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.ConnectionName = "excelSales"; excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/SalesPerson.xlsx"); excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Data")); // Configures a JSON data source. DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource("JSON Data Source"); jsonDataSource.ConnectionName = "jsonCategories"; Uri fileUri = new Uri(HostingEnvironment.MapPath(@"~/App_Data/Categories.json"), UriKind.RelativeOrAbsolute); jsonDataSource.JsonSource = new UriJsonSource(fileUri); // Registers a Federated data source. dataSourceStorage.RegisterDataSource("federatedDataSource", CreateFederatedDataSource(sqlDataSource, excelDataSource, objDataSource, jsonDataSource).SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); // Creates an Excel data source and selects the specific cell range from the SalesPerson worksheet. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.ConnectionName = "xlsProducts"; excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/ExcelDataSource.xlsx"); ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings("SalesPerson", "A1:L2000"); excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings); // Specifies the fields that will be available for the created data source. IExcelSchemaProvider schemaProvider = excelDataSource.GetService(typeof(IExcelSchemaProvider)) as IExcelSchemaProvider; FieldInfo[] availableFields = schemaProvider.GetSchema(excelDataSource.FileName, null, ExcelDocumentFormat.Xlsx, excelDataSource.SourceOptions, System.Threading.CancellationToken.None); List <string> fieldsToSelect = new List <string>() { "CategoryName", "ProductName", "Country", "Quantity", "Extended Price" }; foreach (FieldInfo field in availableFields) { if (fieldsToSelect.Contains(field.Name)) { excelDataSource.Schema.Add(field); } else { field.Selected = false; excelDataSource.Schema.Add(field); } } // Adds the created data source to the data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource dataSource = new DashboardObjectDataSource("Data"); dataSource.DataId = "odsSales"; dataSource.ComponentName = "objData"; dataSource.DataSource = typeof(ViewModel); dataSource.DataMember = "CreateData"; dataSourceStorage.RegisterDataSource(dataSource.ComponentName, dataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "access97Connection"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { try { Session["RegistrarAsignacion"] = ""; DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); if (User.IsInRole("Desarrollo")) { ASPxDashboard1.WorkingMode = WorkingMode.Viewer; } // Uncomment this string to allow end users to create new data sources based on predefined connection strings. ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); //ASPxDashboard1.OpenDashboard("dashboard1.xml"); } catch (Exception Ex) { FG.Controlador_Error(Ex, Page.Response); } }
protected void Page_Load(object sender, EventArgs e) { #region #DashboardStorage DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); #endregion #DashboardStorage #region #DataSourceStorage DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "sqlConnection"); SelectQuery countriesQuery = SelectQueryFluentBuilder .AddTable("Countries") .SelectColumns("Country", "Latitude", "Longitude", "Year", "EnergyType", "Production", "Import") .Build("Countries"); sqlDataSource.Queries.Add(countriesQuery); DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection"); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml()); dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); #endregion #DataSourceStorage }
protected void ASPxDashboard1_Load(object sender, EventArgs e) { return; /*********************** config this ****************************************/ Dashboard dashboard = new Dashboard(); dashboard.LoadFromXDocument(System.Xml.Linq.XDocument.Load( Server.MapPath("~/App_Data/Dashboards/Terminales_Ventas.xml"))); //Change Dashboard Data // default values // dashboard.Parameters["Ano"].Value = DateTime.Now.Year; // dashboard.Parameters["Mes"].Value = DateTime.Now.Month; // option 1: change query in xml // option 2: change query in data provider // >>> set dashboard source // https://documentation.devexpress.com/Dashboard/117050/Examples/Web-Dashboard-Examples/How-to-Connect-the-Web-Dashboard-to-an-SQL-Database ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument()); // <<< set dashboard source }
protected void Page_Load(object sender, EventArgs e) { Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(HostingEnvironment.MapPath(@"~/App_Data/Dashboard.xml")); PivotDashboardItem pivot1 = (PivotDashboardItem)dashboard.Items[0]; DashboardOlapDataSource olapDataSource = (DashboardOlapDataSource)dashboard.DataSources[0]; string fieldYearName = "[Date].[Calendar].[Calendar Year]"; string year2001 = "[Date].[Calendar].[Calendar Year].&[2001]"; string year2002 = "[Date].[Calendar].[Calendar Year].&[2002]"; string fieldCountryName = "[Customer].[Country].[Country]"; string countryCanada = "[Customer].[Country].&[Canada]"; DynamicListLookUpSettings settings = new DynamicListLookUpSettings(); settings.DataSource = olapDataSource; settings.ValueMember = fieldCountryName; DashboardParameter parameter1 = new DashboardParameter("Parameter1", typeof(string), countryCanada, "Category", true, settings); dashboard.Parameters.Add(parameter1); CriteriaOperator filterCriteria = GroupOperator.And( new BinaryOperator(new OperandProperty(fieldCountryName), new OperandParameter(parameter1.Name), BinaryOperatorType.Equal), new NotOperator(new InOperator(new OperandProperty(fieldYearName), new ConstantValue[] { new ConstantValue(year2001), new ConstantValue(year2002) }))); pivot1.FilterString = filterCriteria.ToString(); ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument()); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDashboardStorage(new DashboardFileStorage("~/App_Data/Dashboards")); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDashboardStorage(new CustomDashboardFileStorage(Server.MapPath("~/App_Data/Dashboards/"))); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDashboardStorage(SessionDashboardStorage.Instance); //ASPxDashboard1.SetDashboardStorage(new DashboardFileStorage("~/App_Data/Dashboards")); // Uncomment this line to use the App_Data/Dashboards folder to store dashboards. }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDataSourceStorage(CreateDataSourceStorage()); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.AllowExportDashboard = false; ASPxDashboard1.SetDashboardStorage(fileStorage); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDashboardStorage(dashboardStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage storage = new DashboardFileStorage("~/App_Data"); ASPxDashboard1.SetDashboardStorage(storage); }
protected void Page_Load(object sender, EventArgs e) { ASPxDashboard1.SetDashboardStorage(new SessionDashboardStorage(new string[] { "dashboard1" }, string.Format(@"~/App_Data/Dashboards/"))); //ASPxDashboard1.SetDashboardStorage(new DashboardFileStorage("~/App_Data/Dashboards")); // Uncomment this line to use the App_Data/Dashboards folder to store dashboards. }