public ICollection<string> getUserPermissions(string username, string password)
{
if(database.CheckLogin(username, password) == true)
{
database.setupConnectionParameters(username, password);
DataManager dataManager = new DataManager(database);
ICollection<string> roles = dataManager.getCurrentUserRoles();
roles.Add("Ogólne");
return roles;
}
else
{
return null;
}
}
public IntegratedView bindToView(DataGridView dataGrid)
{
DataManager dm = new DataManager(database);
string viewName = dataGrid.Name;
IntegratedView view = database.getView(viewName);
dataGrid.AutoGenerateColumns = false;
dataGrid.DataSource = view.Table;
foreach(SzpifColumn column in view.Columns.Values)
dataGrid.Columns.Add(column.createDataGridViewColumn());
// dataGrid.Columns[dataGrid.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
foreach (SzpifColumn column in view.Columns.Values)
if (column.CanUpdate && view.Table.Columns.Contains(column.Name) == false)
view.Table.Columns.Add(new DataColumn(column.Name));
if (views.ContainsKey(viewName)) views.Remove(viewName);
views.Add(viewName, view);
return view;
}
public void updateView(DataGridView dataGrid)
{
DataManager dm = new DataManager(database);
string viewName = dataGrid.Name;
database.updateView(viewName, (DataTable)dataGrid.DataSource);
}
public void setUp()
{
dm = new DataManager(SzpifDatabase.DataBase);
}
