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);
}
