private Dashboard CreateDashboard() { Dashboard dashboard = new Dashboard(); DashboardObjectDataSource objectDataSource = new DashboardObjectDataSource("MyDataSource"); objectDataSource.DataSource = typeof(Data); objectDataSource.DataMember = "CreateData"; dashboard.DataSources.Add(objectDataSource); // Creates a Pie dashboard item that displays a percentage of quantity summary for top 3 sales persons. PieDashboardItem pies = new PieDashboardItem(); pies.DataSource = dashboard.DataSources[0]; Dimension salesPersonArgument = new Dimension("SalesPerson"); Measure quantity = new Measure("Quantity"); pies.Arguments.Add(salesPersonArgument); salesPersonArgument.TopNOptions.Enabled = true; salesPersonArgument.TopNOptions.Count = 3; salesPersonArgument.TopNOptions.Measure = quantity; pies.LabelPosition = PointLabelPosition.Inside; pies.Values.Add(quantity); // Creates a Grid dashboard item that displays sales persons and quantities. GridDashboardItem grid = new GridDashboardItem(); grid.DataSource = dashboard.DataSources[0]; grid.Columns.Add(new GridDimensionColumn(new Dimension("SalesPerson"))); grid.Columns.Add(new GridMeasureColumn(new Measure("Quantity"))); dashboard.Items.AddRange(pies, grid); return(dashboard); }
private object GetDataFmsDataSource(DashboardObjectDataSource dataSource, ObjectDataSourceFillParameters fillParameters) { if (fillParameters.DataFields == null || fillParameters.DataFields.Length == 0) { return(null); } // Invocar metodo de negocio. var request = HttpContext.Current.Request; var headers = request.Headers; var idIndicador = int.Parse(headers["filtro_id_indicador"]); var tipoIndicador = headers["filtro_tipo_indicador"]; var fechaInicio = DateTime.ParseExact(headers["filtro_fecha_inicio"], "dd/MM/yyyy", CultureInfo.InvariantCulture); var fechaFin = DateTime.ParseExact(headers["filtro_fecha_fin"], "dd/MM/yyyy", CultureInfo.InvariantCulture); var idPlataforma = headers["filtro_id_plataforma"]; var result = new DataTable(); var repo = new TabIndicadorRepository(); if (string.IsNullOrEmpty(tipoIndicador)) { return(result); } if (tipoIndicador == "U") { result = repo.ListarResultIndicator_Ind(idIndicador, fechaInicio, fechaFin); } return(result); }
private void Form1_Load(object sender, System.EventArgs e) { Dashboard dashboard = new Dashboard(); DashboardObjectDataSource dataSource = new DashboardObjectDataSource("Data Source 1"); dashboardViewer1.DataLoading += (s, ev) => { if (ev.DataSourceName == "Data Source 1") { ev.Data = Data.CreateData(); } }; dashboard.DataSources.Add(dataSource); PieDashboardItem pies = new PieDashboardItem(); pies.DataSource = dashboard.DataSources[0]; Dimension salesPersonArgument = new Dimension("SalesPerson"); Measure quantity = new Measure("Quantity"); pies.Arguments.Add(salesPersonArgument); salesPersonArgument.TopNOptions.Enabled = true; salesPersonArgument.TopNOptions.Count = 3; salesPersonArgument.TopNOptions.Measure = quantity; pies.Values.Add(quantity); GridDashboardItem grid = new GridDashboardItem(); grid.DataSource = dashboard.DataSources[0]; grid.Columns.Add(new GridDimensionColumn(new Dimension("SalesPerson"))); grid.Columns.Add(new GridMeasureColumn(new Measure("Quantity"))); dashboard.Items.AddRange(pies, grid); 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 .AddDevExpressControls() .AddControllersWithViews(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); var dataBaseDashboardStorage = new DataBaseEditaleDashboardStorage( Configuration.GetConnectionString("DashboardStorageConnection")); configurator.SetDashboardStorage(dataBaseDashboardStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); objDataSource.DataMember = "GetSalesData"; dataSourceStorage.RegisterDataSource("objectDataSource", objDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); return(configurator); }); }
private void btnCreate_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { Dashboard dashboard = new Dashboard(); DashboardObjectDataSource dataSource = new DashboardObjectDataSource(); dashboard.BeginUpdate(); dashboard.DataSources.Add(dataSource); dashboard.Items.Add(DashboardItemGenerator.GenerateCardItem(dataSource, "card1")); dashboard.Items.Add(DashboardItemGenerator.GenerateGridItem(dataSource, "grid1")); dashboard.Items.Add(DashboardItemGenerator.GeneratePieItem(dataSource, "pie1")); dashboard.Items.Add(DashboardItemGenerator.GenerateListBoxItem(dataSource, "list1")); TabContainerDashboardItem tabContainer = new TabContainerDashboardItem(); tabContainer.TabPages.Add(new DashboardTabPage() { Name = "Tab Page One", ComponentName = "page1" }); tabContainer.TabPages["page1"].AddRange(dashboard.Items["grid1"], dashboard.Items["pie1"]); DashboardTabPage secondTabPage = tabContainer.CreateTabPage(); secondTabPage.Name = "Tab Page Two"; secondTabPage.Add(dashboard.Items["list1"]); secondTabPage.ShowItemAsTabPage = true; dashboard.Items.Add(tabContainer); dashboard.DataLoading += Dashboard_DataLoading; dashboard.EndUpdate(); dashboardControl.Dashboard = dashboard; }
public object GetData(DashboardObjectDataSource dataSource, ObjectDataSourceFillParameters fillParameters) { if (fillParameters.DataFields == null || fillParameters.DataFields.Length == 0) { return(null); } List <SalesPersonData> data = DataGenerator.CreateSourceData(); DataTable table = new DataTable(); foreach (string field in fillParameters.DataFields) { table.Columns.Add(field, typeof(SalesPersonData).GetProperty(field).PropertyType); } for (int i = 0; i < data.Count; i++) { object[] row = new object[fillParameters.DataFields.Length]; for (int j = 0; j < fillParameters.DataFields.Length; j++) { row[j] = GetPropertyValue(data[i], fillParameters.DataFields[j]); } table.Rows.Add(row); } return(table.DefaultView); }
private ChartDashboardItem CreateChart(DashboardObjectDataSource dataSource) { // Creates a chart dashboard item and specifies its data source. ChartDashboardItem chart = new ChartDashboardItem(); chart.DataSource = dataSource; // Specifies the dimension used to provide data for arguments on a chart. chart.Arguments.Add(new Dimension("Sales Person", DateTimeGroupInterval.Year)); // Specifies the dimension that provides data for chart series. chart.SeriesDimensions.Add(new Dimension("OrderDate")); // Adds a new chart pane to the chart's Panes collection. chart.Panes.Add(new ChartPane()); // Creates a new series of the Bar type. SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar); // Specifies the measure that provides data used to calculate // the Y-coordinate of data points. salesAmountSeries.Value = new Measure("Extended Price"); // Adds created series to the pane's Series collection to display within this pane. chart.Panes[0].Series.Add(salesAmountSeries); chart.Panes.Add(new ChartPane()); SimpleSeries taxesAmountSeries = new SimpleSeries(SimpleSeriesType.StackedBar); taxesAmountSeries.Value = new Measure("Quantity"); chart.Panes[1].Series.Add(taxesAmountSeries); return(chart); }
public void DataExtractCreationTest() { DataTable table = new DataTable(); table.Columns.Add("IntColumn", typeof(int)); table.Columns.Add("StringColumn", typeof(string)); table.Rows.Add(1, "Row 1"); table.Rows.Add(2, "Row 2"); table.Rows.Add(3, "Row 3"); var reader = table.CreateDataReader(); using (DashboardObjectDataSource ods = new DashboardObjectDataSource()) { ods.DataSource = new DataReaderList(reader); using (DashboardExtractDataSource extractDataSource = new DashboardExtractDataSource()) { extractDataSource.ExtractSourceOptions.DataSource = ods; extractDataSource.FileName = Path.GetTempFileName(); extractDataSource.UpdateExtractFile(); IDashboardDataSourceInternal dsi = extractDataSource; var storage = dsi.GetStorage(null); Assert.Equal(3, storage.RowCount); } } }
public object GetData(DashboardObjectDataSource dataSource, ObjectDataSourceFillParameters fillParameters) { if (fillParameters.DataFields == null || fillParameters.DataFields.Length == 0) { return(null); } List <SalesPersonData> data = DataGenerator.Data; DataTable table = new DataTable(); foreach (string field in fillParameters.DataFields) { table.Columns.Add(field); } int NumberOfRecordsToRetrieveParameter = (int)(fillParameters.Parameters.FirstOrDefault(i => i.Name == "NumberOfRecords")?.Value); int NumberOfRecordsToRetrieve = NumberOfRecordsToRetrieveParameter <= data.Count ? NumberOfRecordsToRetrieveParameter : data.Count; for (int i = 0; i < NumberOfRecordsToRetrieve; i++) { object[] row = new object[fillParameters.DataFields.Length]; for (int j = 0; j < fillParameters.DataFields.Length; j++) { row[j] = GetPropertyValue(data[i], fillParameters.DataFields[j]); } table.Rows.Add(row); } return(table.DefaultView); }
protected override XDocument LoadDashboard(string dashboardID) { Dashboard dashboard = new Dashboard(); dashboard.LoadFromXDocument(base.LoadDashboard(dashboardID)); List <DashboardSqlDataSource> dataSources = dashboard.DataSources.OfType <DashboardSqlDataSource>().ToList(); HttpContext.Current.Session["ds" + dashboardID] = dataSources; foreach (var query in dataSources.SelectMany(ds => ds.Queries.Select(q => new { DataSource = ds, Query = q }))) { var odsId = "ods|" + query.DataSource.ComponentName + "|" + query.Query.Name; var ods = new DashboardObjectDataSource(odsId); ods.DataId = odsId; dashboard.DataSources.Add(ods); foreach (var item in dashboard.Items.OfType <DataDashboardItem>().Where(i => Object.ReferenceEquals(i.DataSource, query.DataSource) && i.DataMember == query.Query.Name)) { item.DataMember = ""; item.DataSource = ods; } foreach (var parameter in dashboard.Parameters.Select(p => p.LookUpSettings).OfType <DynamicListLookUpSettings>().Where(p => Object.ReferenceEquals(p.DataSource, query.DataSource) && p.DataMember == query.Query.Name)) { parameter.DataMember = ""; parameter.DataSource = ods; } } return(dashboard.SaveToXDocument()); }
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 Form1_Load(object sender, System.EventArgs e) { Dashboard dashboard = new Dashboard(); DashboardObjectDataSource objectDataSource = new DashboardObjectDataSource("Data Source 1"); objectDataSource.DataSource = typeof(Data); objectDataSource.DataMember = "CreateData"; dashboard.DataSources.Add(objectDataSource); // Creates a Pie dashboard item that displays share of sold units quantity per sales person. PieDashboardItem pies = new PieDashboardItem(); pies.DataSource = dashboard.DataSources[0]; Dimension salesPersonArgument = new Dimension("SalesPerson"); Measure quantity = new Measure("Quantity"); pies.Arguments.Add(salesPersonArgument); salesPersonArgument.TopNOptions.Enabled = true; salesPersonArgument.TopNOptions.Count = 3; salesPersonArgument.TopNOptions.Measure = quantity; pies.Values.Add(quantity); // Creates a Grid dashboard item that displays sales persons and corresponding quantities. GridDashboardItem grid = new GridDashboardItem(); grid.DataSource = dashboard.DataSources[0]; grid.Columns.Add(new GridDimensionColumn(new Dimension("SalesPerson"))); grid.Columns.Add(new GridMeasureColumn(new Measure("Quantity"))); dashboard.Items.AddRange(pies, grid); dashboardViewer1.Dashboard = dashboard; }
private Dashboard CreateSimpleDashboard() { Dashboard dashboard = new Dashboard(); DashboardObjectDataSource dataSource = new DashboardObjectDataSource(); dashboard.DataSources.Add(dataSource); GridDashboardItem gridItem = new GridDashboardItem() { ComponentName = "grid1" }; gridItem.DataSource = dataSource; gridItem.Columns.Add(new GridDimensionColumn(new Dimension("Country"))); gridItem.Columns.Add(new GridMeasureColumn(new Measure("Sales"))); PieDashboardItem pieItem = new PieDashboardItem() { ComponentName = "pie1" }; pieItem.DataSource = dataSource; pieItem.Values.Add(new Measure("Sales")); pieItem.Arguments.Add(new Dimension("Country")); dashboard.Items.AddRange(gridItem, pieItem); return(dashboard); }
private static void MigrateDatasourceTypes(DevExpress.DashboardCommon.Dashboard dashboard) { var objectDataSources = dashboard.DataSources.OfType <DashboardObjectDataSource>().ToArray(); foreach (var objectDataSource in objectDataSources) { var dashboardItems = dashboard.Items.OfType <DataDashboardItem>() .Where(item => item.DataSource == objectDataSource).ToArray(); if (objectDataSource.Constructor != null) { var typeName = objectDataSource.Constructor.Parameters.First().Value; var dataSource = new DashboardObjectDataSource { DataSourceType = XafTypesInfo.Instance.FindTypeInfo($"{typeName}").Type, Name = objectDataSource.Name, ComponentName = objectDataSource.ComponentName }; dashboard.DataSources.Remove(objectDataSource); dashboard.DataSources.Add(dataSource); foreach (var dataDashboardItem in dashboardItems) { dataDashboardItem.DataSource = dataSource; } } } }
public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("ObjectDataSource", typeof(ProductSales)); objDataSource.DataMember = "GetProductSales"; dataSourceStorage.RegisterDataSource("objectDataSource", objDataSource.SaveToXml()); return(dataSourceStorage); }
public object GetData(DashboardObjectDataSource dataSource, ObjectDataSourceFillParameters fillParameters) { if (dataSource.Name == DashboardUtilities.OBJECT_DATASOURCE_NAME) { return(GetDataFmsDataSource(dataSource, fillParameters)); } return(null); }
private DashboardObjectDataSource CreateDataSource() { DashboardObjectDataSource salesDataSource = new DashboardObjectDataSource(); salesDataSource.DataSource = typeof(SalesOverviewDataGenerator); salesDataSource.DataMember = "GetData"; salesDataSource.Fill(); return(salesDataSource); }
private static DashboardObjectDataSource CreateObjectDataSource() { DashboardObjectDataSource objectDataSource = new DashboardObjectDataSource(); objectDataSource.Name = "ObjectDS"; objectDataSource.DataSource = DataGenerator.Data; objectDataSource.Fill(); return(objectDataSource); }
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage) { // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataId = "objectDataSource"; storage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); configurator.DataLoading += DataLoading; }
/// <summary> /// Registers the object data source with the dashboard. /// </summary> /// <returns>The storage of the dashboard data source.</returns> public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataSource = typeof(SalesPersonData); dataSourceStorage.RegisterDataSource("objectDataSource1", objDataSource.SaveToXml()); return(dataSourceStorage); }
// 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"; }); }
// 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(); } }; }); }
protected void Application_Start(object sender, EventArgs e) { var dataBaseDashboardStorage = new DatabaseEditableDashboardStorage( ConfigurationManager.ConnectionStrings["DashboardStorageConnection"].ConnectionString); DashboardConfigurator.Default.SetDashboardStorage(dataBaseDashboardStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); objDataSource.DataMember = "GetSalesData"; dataSourceStorage.RegisterDataSource("objectDataSource", objDataSource.SaveToXml()); DashboardConfigurator.Default.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 objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); ASPxDashboard1.ServiceContainer.AddService(typeof(IObjectDataSourceCustomFillService), new CustomObjectDataSourceCustomFillService()); }
public XpandDataSourceStorage(IModelApplication application) { Dictionary <Type, string> typesCaptions = application.BOModel.ToDictionary(modelClass => modelClass.TypeInfo.Type, modelClass => modelClass.Caption); foreach (Type dashboardType in typesCaptions.Keys) { DashboardObjectDataSource dataSource = new DashboardObjectDataSource { DataSource = dashboardType }; string name = typesCaptions[dashboardType]; dataSource.Name = name; _dataSources.Add($"{dashboardType.FullName}", new XDocument(dataSource.SaveToXml())); } }
public frmOzgunRaporlar(List <object> veriListesi = null) { InitializeComponent(); if (veriListesi != null) { foreach (var veri in veriListesi) { DashboardObjectDataSource dataSource = new DashboardObjectDataSource(); dataSource.DataSource = veri; dataSource.Fill(); dashboardDesigner1.Dashboard.DataSources.Add(dataSource); } } }
public object GetData(DashboardObjectDataSource dataSource, ObjectDataSourceFillParameters fillParameters) { if (fillParameters.CtorParameters != null && fillParameters.CtorParameters.Count > 0) { ScriptDataSource scriptDataSource = new ScriptDataSource((string)fillParameters.CtorParameters.Single().Value) { Application = DataProvider.ContextApplication }; return(scriptDataSource.GetData(fillParameters.Parameters.ToDictionary(p => p.Name, p => p.Value))); } else { return(DefaultFillService.GetData(dataSource, fillParameters)); } }
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); }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardConfigurator.Default.SetDashboardStorage(new DashboardFileStorage(@"~/App_Data/")); var dataSourceStorage = new DataSourceInMemoryStorage(); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); objDataSource.DataSource = typeof(SalesPersonData); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); DashboardConfigurator.Default.SetObjectDataSourceCustomFillService(new CustomObjectDataSourceCustomFillService()); }
private GaugeDashboardItem CreateGauges(DashboardObjectDataSource dataSource) { GaugeDashboardItem gauges = new GaugeDashboardItem(); gauges.ViewType = GaugeViewType.CircularHalf; gauges.DataSource = dataSource; Gauge gauge = new Gauge(); gauge.ActualValue = new Measure("Extended Price", SummaryType.Sum); gauges.Gauges.Add(gauge); gauges.SeriesDimensions.Add(new Dimension("Sales Person")); return(gauges); }