// This method gets called by the runtime. Use this method to add services to the container.
// For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940
public void ConfigureServices(IServiceCollection services)
{
services
.AddMvc()
.AddDefaultDashboardController((configurator, serviceProvider) =>
{
//var connection = new SqlConnection(ConnectionString);
var dashboardStorage = new DataBaseEditaleDashboardStorage();
configurator.SetDashboardStorage(dashboardStorage);
var conexao = new SqlConnectionStringBuilder(Configuration.GetConnectionString("BrickConnStr"));
conexao.UserID = "usr_cdis_report";
conexao.Password = "******";
var parameters = new CustomStringConnectionParameters(conexao.ConnectionString);
var sqlDataSource = new DashboardSqlDataSource("Fonte de dados padrão", parameters);
var dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml());
configurator.SetDataSourceStorage(dataSourceStorage);
/*const string defaultSourceName = "Fonte de dados padrão";
* const string connectionName = "mssql-connection";
* var sqlDataSource = new DashboardSqlDataSource(defaultSourceName, connectionName);
* var dataSourceStorage = new DataSourceInMemoryStorage();
* dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml());
* configurator.SetDataSourceStorage(dataSourceStorage);
*
* configurator.ConfigureDataConnection += (s, e) =>
* {
* if (e.ConnectionName == connectionName)
* {
* var conexao = new SqlConnectionStringBuilder(ConnectionString);
* conexao.UserID = "usr_cdis_report";
* conexao.Password = "******";
* e.ConnectionParameters = new CustomStringConnectionParameters(conexao.ConnectionString);
* }
* };*/
//configurator.SetConnectionStringsProvider(new MyDataSourceWizardConnectionStringsProvider());
configurator.ConfigureDataConnection += (s, e) =>
{
};
configurator.AllowExecutingCustomSql = true;
DashboardConfigurator.PassCredentials = true;
});
services.AddDevExpressControls(settings => settings.Resources = ResourcesType.ThirdParty | ResourcesType.DevExtreme);
}
public static void RegisterService(RouteCollection routes)
{
routes.MapDashboardRoute("api/dashboard", "DefaultDashboard");
var dataBaseDashboardStorage = new DataBaseEditaleDashboardStorage(
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);
}
