void IDataSourceWizardConnectionStringsStorage.SaveDataConnectionParameters(string name, DataConnectionParametersBase connectionParameters, bool saveCredentials)
{
var storage = GetOrCreateStorage();
storage[name] = connectionParameters;
SaveToSession(storage);
}
private ConnectionWrapper InitConnection(string connectionName, DataConnectionParametersBase connectionParameters)
{
ConnectionWrapper cw = ConnectionWrapper.Create();
cw.ConnectionName = connectionName;
cw.ConnectionParameters = connectionParameters;
this.DataConnections.Add(cw);
return(cw);
}
public Form1()
{
InitializeComponent();
dashboardDesigner1.CreateRibbon();
DataConnectionParametersBase connParameters = CreateConnectionParameters("MSAccess");
DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source 1", connParameters);
sqlDataSource.Queries.Add(CreateQuery("fluent"));
sqlDataSource.Fill();
dashboardDesigner1.Dashboard = CreateDashboard(sqlDataSource);
}
public IDashboardDataExtract ConfigureDataConnection(DataConnectionParametersBase dataConnectionParameters)
{
if (dataConnectionParameters is ExtractDataSourceConnectionParameters extractParameters &&
Guid.TryParse(extractParameters.FileName, out var id))
{
IDashboardDataExtract extract = GetDataExtract(id);
if (extract != null)
{
extract.ConfigureConnectionParameters(Application, extractParameters);
}
return(extract);
}
return(null);
}
static string GetConnectionString(DataConnectionParametersBase connectionPars)
{
CustomStringConnectionParameters customConnectionPars = connectionPars as CustomStringConnectionParameters;
if (customConnectionPars != null)
{
return(customConnectionPars.ConnectionString);
}
JsonSourceConnectionParameters jsonConnectionPars = connectionPars as JsonSourceConnectionParameters;
if (jsonConnectionPars != null)
{
if (jsonConnectionPars.JsonSource == null)
{
throw new Exception();
}
JsonDataConnection jsonConnection = new JsonDataConnection(jsonConnectionPars.JsonSource);
return(jsonConnection.CreateConnectionString());
}
throw new Exception();
}
public CustomSqlDataConnection(string name, DataConnectionParametersBase connectionParameters) : base(name, connectionParameters)
{
}
public bool Validate(DataConnectionParametersBase connectionParameters, string sql, ref string message)
{
// Add your custom validation logic here.
// The method should return true if the query is valid and false otherwise.
return(false);
}
