-
Notifications
You must be signed in to change notification settings - Fork 2
/
CustomConnectionStringProvider.cs
37 lines (31 loc) · 1.66 KB
/
CustomConnectionStringProvider.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Web;
using System.Collections.Generic;
namespace BlazorAuth {
public class CustomConnectionStringProvider : IDataSourceWizardConnectionStringsProvider {
private string userName;
private Dictionary<string, string> connectionStrings = new Dictionary<string, string>();
public CustomConnectionStringProvider(string userName) {
this.userName = userName;
connectionStrings.Add("NorthwindConnectionString", @"XpoProvider=SQLite; Data Source=App_Data/nwind.db;");
connectionStrings.Add("CarsXtraSchedulingConnectionString", @"XpoProvider=SQLite;Data Source=App_Data/CarsDB.db;");
}
public Dictionary<string, string> GetConnectionDescriptions() {
var connections = new Dictionary<string, string>();
if (userName == "admin") {
connections.Add("NorthwindConnectionString", "Northwind Connection");
connections.Add("CarsXtraSchedulingConnectionString", "CarsXtraScheduling Connection");
} else if (userName == "user") {
connections.Add("CarsXtraSchedulingConnectionString", "CarsXtraScheduling Connection");
}
return connections;
}
public DataConnectionParametersBase GetDataConnectionParameters(string name) {
if (GetConnectionDescriptions().ContainsKey(name)) {
return new CustomStringConnectionParameters(connectionStrings[name]);
} else {
throw new System.ApplicationException("You are not authorized to use this connection.");
}
}
}
}