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;
}
static Customer()
{
SqlDataSource ds = new SqlDataSource("NWindConnectionString");
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Customers")
.SelectAllColumns()
.Build("Customers");
ds.Queries.Add(query);
ds.RebuildResultSchema();
ds.Fill();
ITable src = ds.Result["Customers"];
foreach (var row in src)
{
customers.Add(new Customer()
{
CustomerID = row.GetValue <string>("CustomerID"),
Address = row.GetValue <string>("Address"),
CompanyName = row.GetValue <string>("CompanyName"),
ContactName = row.GetValue <string>("ContactName"),
ContactTitle = row.GetValue <string>("ContactTitle"),
Country = row.GetValue <string>("Country"),
City = row.GetValue <string>("City"),
Fax = row.GetValue <string>("Fax"),
Phone = row.GetValue <string>("Phone"),
PostalCode = row.GetValue <string>("PostalCode"),
Region = row.GetValue <string>("Region")
});
}
}
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);
}
// 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);
configurator.ConfigureItemDataCalculation += (s, e) => {
e.CalculateAllTotals = true;
};
return(configurator);
});
}
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)
{
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";
}
void RelationshipInitialization()
{
SelectQuery categories = SelectQueryFluentBuilder.AddTable("Categories").SelectAllColumns().Build("Categories");
SelectQuery products = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumns().Build("Products");
DataSource.Queries.AddRange(new SqlQuery[] { categories, products });
DataSource.Relations.Add(new MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"));
}
static SelectQuery GenerateDefaultQuery()
{
return(SelectQueryFluentBuilder
.AddTable("Suppliers")
.SelectColumns("CompanyName", "ContactName", "City", "Country")
.Join("Products", DevExpress.Xpo.DB.JoinType.LeftOuter, "SupplierID", "SupplierID")
.SelectColumns("ProductName", "UnitPrice")
.Build("Query1"));
}
XtraReport CreateReport()
{
// Create a new report instance.
XtraReport report = new XtraReport();
// Create a data source.
SqlDataSource ds = new SqlDataSource(new XmlFileConnectionParameters("../../Cars.xml"));
// Create a query to access fields of the Cars data table.
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Cars")
.SelectColumns("ID", "Trademark", "Model", "Category", "Description")
.Build("MyQuery");
ds.Queries.Add(query);
// Make the data source structure displayed
// in the Field List of an End-User Report Designer.
ds.RebuildResultSchema();
// Assign the data source to the report.
report.DataSource = ds;
report.DataMember = "MyQuery";
// Add a detail band to the report.
DetailBand detailBand = new DetailBand();
report.Bands.Add(detailBand);
// Add a label to the detail band.
XRLabel label = new XRLabel {
WidthF = 300
};
label.Text = "[MyQuery.Trademark] [MyQuery.Model]";
label.LeftF = 30;
detailBand.Controls.Add(label);
detailBand.Height = (int)label.HeightF;
// Create a group header band and add it to the report.
GroupHeaderBand ghBand = new GroupHeaderBand();
report.Bands.Add(ghBand);
// Create a grouping criteria.
ghBand.GroupFields.Add(new GroupField("Category"));
// Display the grouping criteria in the group header.
XRLabel labelGroup = new XRLabel();
labelGroup.Text = "[MyQuery.Category]";
ghBand.Controls.Add(labelGroup);
ghBand.Height = (int)labelGroup.HeightF;
return(report);
}
public Dictionary <string, object> GetAvailableDataSources()
{
var dataSources = new Dictionary <string, object>();
dataSources.Add("Northwind", CreateDataSource("Northwind_Json", SelectQueryFluentBuilder.AddTable("Products").SelectAllColumnsFromTable().Build("Products")));
dataSources.Add("Countries", CreateDataSource("Countries_DevelopmentJson", SelectQueryFluentBuilder.AddTable("Regions").SelectAllColumnsFromTable().Build("Regions")));
dataSources.Add("Vehicles", CreateDataSource("Vehicles_InMemory", SelectQueryFluentBuilder.AddTable("Model").SelectAllColumnsFromTable().Build("Model")));
dataSources.Add("Cars", CreateDataSource("Cars_InMemory", SelectQueryFluentBuilder.AddTable("Cars").SelectAllColumnsFromTable().Build("Cars")));
return(dataSources);
}
protected override SqlQuery RunQueryBuilder(SqlQuery query)
{
string tableName = null;
int topRecords = 100;
// Analyze the query that is being edited (if any).
SelectQuery selectQuery = query as SelectQuery;
if (selectQuery != null && selectQuery.Tables.Count == 1 && selectQuery.Columns.Count == 1 && string.IsNullOrEmpty(selectQuery.FilterString) && selectQuery.Skip == 0)
{
var columns = selectQuery.Columns[0] as AllColumns;
if (columns != null && columns.Table == null)
{
tableName = selectQuery.Tables[0].Name;
topRecords = selectQuery.Top;
}
}
if (tableName == null && query != null)
{
ShowMessage("This query is too complex and cannot be displayed.");
return(null);
}
// Display a custom query builder form.
using (var form = new FrmQueryBuilder()) {
form.Initialize(DbTables.Keys.OrderBy(s => s));
if (tableName != null)
{
form.Selected = tableName;
form.TopRecords = topRecords;
}
if (form.ShowDialog(((Control)View).FindForm()) != DialogResult.OK)
{
return(null);
}
tableName = form.Selected;
topRecords = form.TopRecords;
}
// Generate a query based on user input.
if (string.IsNullOrEmpty(tableName))
{
return(null);
}
SqlQuery result = SelectQueryFluentBuilder
.AddTable(tableName)
.SelectAllColumns()
.Top(topRecords)
.Build(tableName);
// Make sure that the table columns have been loaded.
dbSchemaProvider.LoadColumns(Model.DataConnection, DBSchema.Tables.First(t => t.Name == tableName));
return(result);
}
Dictionary <string, object> GetAvailableDataSources()
{
var dataSources = new Dictionary <string, object>();
SqlDataSource ds = new SqlDataSource("Northwind_Connection");
var query = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumns().Build("Products");
ds.Queries.Add(query);
ds.RebuildResultSchema();
dataSources.Add("SqlDataSource", ds);
return(dataSources);
}
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);
}
// 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("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>();
}
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());
}
// 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 button1_Click(object sender, EventArgs e)
{
// Create a data source connection.
Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters("../../nwind.mdb", "", "");
SqlDataSource ds = new SqlDataSource(connectionParameters);
// Create a query and specify its SELECT expression.
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Products")
.SelectColumn("CategoryID")
.GroupBy("CategoryID")
.SelectExpression("StDev([Products].[UnitPrice])", "PriceDeviation")
.Build("Products");
//Add the query to the data source.
ds.Queries.Add(query);
// Fill the data source.
ds.Fill();
// Create a new report and bind it to the data source.
XtraReport report = new XtraReport();
report.DataSource = ds;
report.DataMember = "Products";
// Create a report layout.
DetailBand detailBand = new DetailBand();
detailBand.Height = 50;
report.Bands.Add(detailBand);
XRLabel labelCategory = new XRLabel();
labelCategory.DataBindings.Add("Text", report.DataSource, "Products.CategoryID", "Category ID: {0}");
labelCategory.TopF = 15;
detailBand.Controls.Add(labelCategory);
XRLabel labelDeviation = new XRLabel();
labelDeviation.DataBindings.Add("Text", report.DataSource, "Products.PriceDeviation", "Price Deviation: {0}");
labelDeviation.TopF = 30;
labelDeviation.WidthF = 500;
detailBand.Controls.Add(labelDeviation);
// Publish the report.
ReportPrintTool pt = new ReportPrintTool(report);
pt.ShowPreviewDialog();
}
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);
}
void configureQueryPageViewEx_SelectedTableChanged(object sender, SelectedTableChanged e)
{
result = null;
var dbTable = DBSchema.Tables.FirstOrDefault(t => string.Equals(t.Name, e.TableName));
if (dbTable != null)
{
schemaProvider.LoadColumns(Model.DataConnection, dbTable);
result = SelectQueryFluentBuilder.AddTable(e.TableName)
.SelectColumns(dbTable.Columns.Select(c => c.Name).ToArray())
.Build(e.TableName);
}
RaiseChanged();
}
public ActionResult Designer()
{
Models.ReportDesignerModel model = new Models.ReportDesignerModel();
// Create a SQL data source with the specified connection string.
SqlDataSource ds = new SqlDataSource("NWindConnectionString");
// Create a SQL query to access the Products data table.
SelectQuery query = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumnsFromTable().Build("Products");
ds.Queries.Add(query);
ds.RebuildResultSchema();
model.DataSources = new Dictionary <string, object>();
model.DataSources.Add("Northwind", ds);
return(View(model));
}
void BindToData()
{
// Create a SQL data source with the specified connection string.
SqlDataSource ds = new SqlDataSource("NWindConnectionString");
// Create a SQL query to access the Products data table.
SelectQuery query = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumnsFromTable().Build("Products");
ds.Queries.Add(query);
ds.RebuildResultSchema();
// Add the created data source to the list of default data sources.
ASPxReportDesigner1.DataSources.Add("Northwind", ds);
ASPxReportDesigner1.OpenReport("Report");
}
public static SqlDataSource CreateSqlDataSource()
{
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(".", "NorthWind", null, null, MsSqlAuthorizationType.Windows);
var sqlDataSource = new SqlDataSource(connectionParameters)
{
Name = "Sql_Categories"
};
var categoriesQuery = SelectQueryFluentBuilder.AddTable("Categories").
SelectAllColumnsFromTable().
Build("Categories");
sqlDataSource.Queries.Add(categoriesQuery);
sqlDataSource.RebuildResultSchema();
return(sqlDataSource);
}
Dictionary <string, object> GetAvailableDataSources()
{
//SqlConnection connection = new SqlConnection("data source=(localdb)/mssqllocaldb;initial catalog=aspnet-DXWebApplication1-20200900153700;integrated security=SSPI");
//connection.Open();
var dataSources = new Dictionary <string, object>();
SqlDataSource ds = new SqlDataSource("Northwind_Connection");
var productsQuery = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumns().Build("Products");
var customersQuery = SelectQueryFluentBuilder.AddTable("Customers").SelectAllColumns().Build("Customers");
ds.Queries.Add(productsQuery);
ds.Queries.Add(customersQuery);
ds.RebuildResultSchema();
dataSources.Add("SqlDataSource", ds);
return(dataSources);
}
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());
}
void SelectQueryCreation()
{
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Categories")
.SelectColumn("CategoryName")
.GroupBy("CategoryName")
.Join("Products", "CategoryID")
.SelectColumn("ProductName", AggregationType.Count, "ProductCount")
.SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending)
.GroupFilter("[ProductCount] > 7")
.Build("Categories");
DataSource.Queries.Add(query);
QueryParameterInitialization(query);
}
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);
}
public object GetReportDesignerModel([FromForm] string reportUrl)
{
Dictionary <string, object> dataSources = new Dictionary <string, object>();
SqlDataSource ds = new SqlDataSource("SevenR");
// Create a SQL query to access the Products data table.
SelectQuery query = SelectQueryFluentBuilder.AddTable("GN_EMPRE").SelectAllColumnsFromTable().Build("GN_EMPRE");
ds.Queries.Add(query);
ds.RebuildResultSchema();
dataSources.Add("Northwind", ds);
string modelJsonScript = new ReportDesignerClientSideModelGenerator(HttpContext.RequestServices).GetJsonModelScript(reportUrl, dataSources, "/DXXRD", "/DXXRDV", "/DXXQB");
return(new JavaScriptSerializer().Deserialize <object>(modelJsonScript));
}
public static SqlDataSource CreateSqlDataSource()
{
string rootPath = Path.GetDirectoryName(typeof(Form1).Assembly.Location);
SQLiteConnectionParameters connectionParameters =
new SQLiteConnectionParameters(Path.Combine(rootPath, "nwind.db"), null);
SqlDataSource sqlDataSource = new SqlDataSource(connectionParameters);
SelectQuery querySalesPerson = SelectQueryFluentBuilder
.AddTable("Customers")
.SelectAllColumnsFromTable()
.Build("Customers");
sqlDataSource.Queries.Add(querySalesPerson);
return(sqlDataSource);
}
