private void Login_Click(object sender, RoutedEventArgs e)
{
SQLCONN.Open();
SQLCMD = new SqlCommand("SELECT tildeltRettighed FROM Brugere WHERE brugernavn = '" + Bruger.Text + "' AND Kodeord = '" + adgangskode.Password + "'", SQLCONN);
SQLDR = SQLCMD.ExecuteReader();
if (SQLDR.HasRows)
{
SQLDR.Read();
if (SQLDR[0].ToString() == "Administrator")
{
Administrator Admin = new Administrator();
Admin.Show();
MessageBox.Show("Din rettighed er Admnistrator");
}
else if (SQLDR[0].ToString() == "Superbruger")
{
Superbruger SB = new Superbruger();
SB.Show();
MessageBox.Show("Din rettighed er Superbruger");
}
}
else
{
MessageBox.Show("Bruger findes ikke");
}
SQLCONN.Close();
}
private void button1_Click(object sender, EventArgs ex)
{
try //tests the code for any errors
{
SQLiteConnection Con = new SQLiteConnection(@"Data Source=.\UsersDB.db;Version=3");
SQLiteCommand SqlCmd = new SQLiteCommand("select * from Users where Username = '******' and [Password]='" + textBox2.Text + "'", Con); //selects all database entries that match the username and password entered
SQLiteDataAdapter SqlDA = new SQLiteDataAdapter(SqlCmd);
DataTable DT = new DataTable();
SqlDA.Fill(DT); //fills the "DT" datatable with the data selected
string cmbItemValue = comboBox1.SelectedItem.ToString(); //saves the usertype selected, from the usertype drop down menu, into "cmbItemValue"
if (DT.Rows.Count > 0) //if there is data in the datatable, the code will run
{
for (int i = 0; i < DT.Rows.Count; i++) //scans through the rows in the datatable
{
if (DT.Rows[i]["usertype"].ToString() == cmbItemValue) //if the usertype selected is in the datatable, the code will run
{
if (comboBox1.SelectedIndex == 0) //if you selected the "Bruger" usertype, the "Bruger.cs" window will pop up, and the current window will be hidden
{
Bruger f = new Bruger();
f.Show();
this.Hide();
}
else if (comboBox1.SelectedIndex == 1) //if you selected the "Superbruger" usertype, the "Superbruger.cs" window will pop up, and the current window will be hidden
{
Superbruger ff = new Superbruger();
this.Hide();
ff.Show();
}
else if (comboBox1.SelectedIndex == 2) //if you selected the "Administrator" usertype, the "Administrator.cs" window will pop up, and the current window will be hidden
{
Administrator fff = new Administrator();
this.Hide();
fff.Show();
}
}
break; //breaks out of the current scope
}
}
else //clears the boxes and shows a general error message, if a non-detectable error(i.e. human error) occurs
{
textBox1.Clear();
textBox2.Clear();
MessageBox.Show(" Error \n Login and/or Password were incorrect");
}
}
catch (Exception exc) { MessageBox.Show(exc.Message); } //shows the error message if the code has any errors
}