public GARITS()
{
InitializeComponent();
permissions = new Permissions();
try
{
settingsFile = new SettingsFile();
db = new Database(settingsFile.getSetting("dbserver"), settingsFile.getSetting("dbname"), settingsFile.getSetting("dbuser"), settingsFile.getSetting("dbpassword"));
db.Connect();
permissions.readPermissions(db);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Environment.Exit(1);
}
permissions.AddComponent(administrationToolStripMenuItem, "Administration Menu Item");
}
public Administration(Database db)
{
InitializeComponent();
database = db;
MySqlDataAdapter MyDA = new MySqlDataAdapter();
string sqlDept = "SELECT users.userID as 'ID', users.username as 'Username', roles.rolename as 'Role', users.firstname as 'Firstname', users.surname as 'Surname', users.active as 'Active' FROM USERS, ROLES WHERE users.roleid = roles.roleid AND users.deleted <> 1 AND users.username <> 'root'";
MyDA.SelectCommand = new MySqlCommand(sqlDept, db.sqlConn);
DataTable table = new DataTable();
MyDA.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
//DataGridView dgView = new DataGridView();
dataGridView1.DataSource = bSource;
for (int i = 1; i < dataGridView1.Columns.Count; i++)
dataGridView1.Columns[i].ReadOnly = true;
selectionCombo.SelectedIndex = 0;
}
