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); }