private void timer1_Tick_1(object sender, EventArgs e)
{
Rechte_Load();
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM motd");
while (reader.Read())
{
richTextBox1.Text = reader[0].ToString();
}
reader.Close();
bool red = false;
reader = x.readerSQL("SELECT status from AusbildungsTermine WHERE prüfling='" + username + "' AND status=1");
while (reader.Read())
{
if (reader.GetString("status") == "1")
{
red = true;
}
}
reader.Close();
x.closeConnection();
if (red)
{
button3.BackColor = Color.Red;
}
else
{
button3.ResetBackColor();
button3.UseVisualStyleBackColor = true;
}
}
public Verwaltung_Manage()
{
InitializeComponent();
jetzt = DateTime.Now;
RegistryKey key = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\LSMC-DienstApp");
db1.openConnection();
var result = db1.readerSQL("SELECT rang FROM User WHERE apikey = '" + key.GetValue("API") + "'");
result.Read();
Brang = Convert.ToInt32(result[0]);
db1.closeConnection();
}
private void fahrzeugKontrolle_Load(object sender, EventArgs e)
{
label1.Text = "Fahrzeug: " + nummer;
dataGridView1.ColumnCount = 3;
dataGridView1.Columns[0].Name = "ID";
dataGridView1.Columns[1].Name = "Name";
dataGridView1.Columns[2].Name = "Beladung";
dataGridView1.Columns[1].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Beladung");
while (reader.Read())
{
List <string> tmp = new List <string>();
string name = reader.GetString("itemname");
string id = reader.GetString("id");
string anzahl = reader.GetString("anzahl");
tmp.Add(id);
tmp.Add(name);
tmp.Add(anzahl);
items.Add(tmp);
dataGridView1.Rows.Add(id, name + " (" + anzahl + ")", "");
}
reader.Close();
reader = x.readerSQL("SELECT beladung FROM Fahrzeuge WHERE nummer = " + nummer);
while (reader.Read())
{
string beladung = "";
string[] temp = reader[0].ToString().Split(';');
foreach (string s in temp)
{
string[] tmp = s.Split(':');
foreach (DataGridViewRow row in dataGridView1.Rows)
{
//MessageBox.Show(row.Cells[0].Value.ToString());
if (row.Cells[0].Value.ToString() == tmp[0])
{
row.Cells[2].Value = tmp[1];
}
}
}
}
reader.Close();
x.closeConnection();
}
private void Insert_Pruefungen()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT * FROM Pruefungsliste");
pruefungenlist = new List <List <string> >();
while (res.Read())
{
if (res[3].ToString() != "0")
{
List <string> temp = new List <string>();
pruefungen.Items.Add(res[1]);
temp.Add(res[1].ToString()); // 0 = Name
temp.Add(res[2].ToString()); // 1 = Anzahlpersonen
temp.Add(res[3].ToString()); // Aktiv
temp.Add(res[4].ToString()); // Sonderbemerkgung
pruefungenlist.Add(temp);
}
}
res.Close();
abfragemitarbeiter.closeConnection();
}
public void Uebersicht()
{
// dGVerwaltung.Enabled = false;
dGVerwaltung.Rows.Clear();
dbConnection Auslesen = new dbConnection();
Auslesen.openConnection();
var A = Auslesen.readerSQL("SELECT * FROM User WHERE uninvite != '2' ORDER BY rang DESC, beitritt ASC");
var rowcount = 0;
while (A.Read())
{
this.dGVerwaltung.Rows.Add(A[1], A[2], A[3], A[4], A[5], "", A[6]);
// Wenn eine Kündigung vorgeschlagen wurde
if (Convert.ToInt32(A[12]) == 1)
{
dGVerwaltung.Rows[rowcount].Cells[7].Value = "Uninvite";
dGVerwaltung.Rows[rowcount].Cells[7].Style.BackColor = Color.Red;
dGVerwaltung.Rows[rowcount].Cells[7].Style.ForeColor = Color.White;
dGVerwaltung.Rows[rowcount].Cells[8].Value = "X";
dGVerwaltung.Rows[rowcount].Cells[8].Style.BackColor = Color.Cyan;
}
rowcount++;
}
Auslesen.closeConnection();
}
private void urlaubslisteToolStripMenuItem_Click(object sender, EventArgs e)
{
fenster = 6;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "Name";
dataGridView1.Columns[1].Name = "Abwesend ab";
dataGridView1.Columns[2].Name = "Abwesend bis";
dataGridView1.Columns[3].Name = "Begründung";
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Urlaub");
while (reader.Read())
{
dataGridView1.Rows.Add(reader.GetString("name"), reader.GetString("von"), reader.GetString("bis"), reader.GetString("begründung"));
}
reader.Close();
x.closeConnection();
}
private void archivToolStripMenuItem1_Click(object sender, EventArgs e)
{
fenster = 5;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ColumnCount = 5;
dataGridView1.Columns[0].Name = "ID";
dataGridView1.Columns[1].Name = "Name";
dataGridView1.Columns[2].Name = "Link";
dataGridView1.Columns[3].Name = "Gefehlt";
dataGridView1.Columns[4].Name = "Woche";
dataGridView1.Columns[1].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dataGridView1.Columns[2].HeaderCell.Style.Padding = new Padding(30, 0, 50, 0);
dataGridView1.Columns[3].HeaderCell.Style.Padding = new Padding(80, 0, 50, 0);
dbConnection x = new dbConnection();
x.openConnection();
var readMitarbeiter = x.readerSQL("SELECT * from FahrzeugbeladungArchiv");
while (readMitarbeiter.Read())
{
dataGridView1.Rows.Add(readMitarbeiter[0].ToString(), readMitarbeiter[1].ToString(), readMitarbeiter[2].ToString(), readMitarbeiter[3].ToString(), readMitarbeiter[4].ToString());
}
readMitarbeiter.Close();
x.closeConnection();
}
private void mittelschwerVergehen()
{
sanktionen.Clear();
comboBox1.Items.Clear();
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Strafkatalog WHERE Typ=3");
while (reader.Read())
{
List <string> tmp = new List <string>();
tmp.Add(reader.GetString("id"));
tmp.Add(reader.GetString("Vergehen"));
tmp.Add(reader.GetString("Punkte"));
string[] money = reader.GetString("Geld").Split(';');
tmp.Add(money[0]);
tmp.Add(money[1]);
tmp.Add(money[2]);
tmp.Add(money[3]);
sanktionen.Add(tmp);
comboBox1.Items.Add(reader.GetString("Vergehen"));
}
reader.Close();
x.closeConnection();
}
private void sanktionenArchiv()
{
fenster = 4;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "ID";
dataGridView1.Columns[1].Name = "Name";
dataGridView1.Columns[2].Name = "SanktionsID";
dataGridView1.Columns[3].Name = "Datum";
dataGridView1.Columns[1].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dataGridView1.Columns[2].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT id,Vergehen FROM Strafkatalog");
while (reader.Read())
{
List <string> tmp = new List <string>();
tmp.Add(reader.GetString("id"));
tmp.Add(reader.GetString("Vergehen"));
sanktionen.Add(tmp);
}
reader.Close();
reader = x.readerSQL("SELECT * FROM Sanktionen WHERE aktiv = 3");
while (reader.Read())
{
string name = reader.GetString("username");
string sanktionsid = reader.GetString("sanktion");
string datum = reader.GetString("datum");
string sanktion = sanktionen[Suche_Sanktion(sanktionsid)][1];
dataGridView1.Rows.Add(reader.GetString("id"), name, sanktion, datum);
}
reader.Close();
x.closeConnection();
}
private void Ausbildung_Prüfungsverwaltung_Load(object sender, EventArgs e)
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Pruefungsliste");
while (reader.Read())
{
comboBox1.Items.Add(reader[1].ToString());
List <string> tmp = new List <string>();
tmp.Add(reader[0].ToString()); //ID
tmp.Add(reader[1].ToString()); // Name
tmp.Add(reader[2].ToString()); // Personenanzahl
tmp.Add(reader[3].ToString()); // Aktiv
tmp.Add(reader[4].ToString()); // sonderbemerkung
prüfungen.Add(tmp);
}
reader.Close();
reader = x.readerSQL("SELECT * FROM Schulungsliste");
while (reader.Read())
{
comboBox2.Items.Add(reader[1].ToString());
List <string> tmp = new List <string>();
tmp.Add(reader[0].ToString()); //ID
tmp.Add(reader[1].ToString()); // Name
tmp.Add(reader[2].ToString()); // Aktiv
schulungen.Add(tmp);
}
reader.Close();
reader = x.readerSQL("SELECT * FROM FSTListe");
while (reader.Read())
{
List <string> tmp = new List <string>();
tmp.Add(reader[0].ToString()); //ID
tmp.Add(reader[1].ToString()); // Name
tmp.Add(reader[2].ToString()); // Aktiv
fsts.Add(tmp);
}
reader.Close();
x.closeConnection();
}
private void mdwListe_Load(object sender, EventArgs e)
{
CultureInfo CUI = CultureInfo.CurrentCulture;
int kw = CUI.Calendar.GetWeekOfYear(DateTime.Now, CUI.DateTimeFormat.CalendarWeekRule, CUI.DateTimeFormat.FirstDayOfWeek);
dbConnection x = new dbConnection();
x.openConnection();
var dict = new Dictionary <string, int>();
var reader = x.readerSQL("SELECT username,rang FROM User");
while (reader.Read())
{
if (int.Parse(reader[1].ToString()) < 10)
{
dict.Add(reader[0].ToString(), 0);
}
}
reader.Close();
reader = x.readerSQL("SELECT * FROM mdw WHERE kw=" + kw);
while (reader.Read())
{
int v1, v2, v3;
dict.TryGetValue(reader.GetString("vorschlag1"), out v1);
dict[reader.GetString("vorschlag1")] = v1 + 1;
dict.TryGetValue(reader.GetString("vorschlag2"), out v2);
dict[reader.GetString("vorschlag2")] = v2 + 1;
dict.TryGetValue(reader.GetString("vorschlag3"), out v3);
dict[reader.GetString("vorschlag3")] = v3 + 1;
}
reader.Close();
x.closeConnection();
dict.Remove("");
var sortedDict = (from entry in dict orderby entry.Value descending select entry).ToDictionary(pair => pair.Key, pair => pair.Value).Take(10);
foreach (KeyValuePair <string, int> entry in sortedDict)
{
listBox1.Items.Add(entry.Key + ": " + entry.Value);
}
}
public void Uebersicht()
{
dG.Rows.Clear();
dbConnection Auslesen = new dbConnection();
Auslesen.openConnection();
var A = Auslesen.readerSQL("SELECT id, userid, rang, beitritt, austritt, entlassen, gemeldet, dokumente, wiedereingestellt, blacklist, bemerkung FROM Archiv");
var zaehler = 0;
while (A.Read())
{
dG.Rows.Add();
dG.Rows[zaehler].Cells[0].Value = A[0];
dG.Rows[zaehler].Cells[1].Value = A[1];
dG.Rows[zaehler].Cells[2].Value = A[2];
dbConnection Auslesenname = new dbConnection();
Auslesenname.openConnection();
var N = Auslesenname.readerSQL("SELECT username FROM User WHERE id = '" + A[1] + "'");
while (N.Read())
{
dG.Rows[zaehler].Cells[3].Value = N[0];
}
dG.Rows[zaehler].Cells[4].Value = A[3];
dG.Rows[zaehler].Cells[5].Value = A[4];
dG.Rows[zaehler].Cells[6].Value = Ausgabejanein(Convert.ToInt32(A[5]));
//Gemeldet
DateTime B = Convert.ToDateTime(A[3]);
DateTime Au = Convert.ToDateTime(A[4]);
TimeSpan sp = Au - B;
if (Convert.ToInt32(A[6]) == 0)
{
if (Convert.ToInt32(A[2]) == 0 && Convert.ToInt32(sp.Days) >= 15 && Convert.ToInt32(sp.Days) <= 30)
{
dG.Rows[zaehler].Cells[7].Style.BackColor = Color.Red;
dG.Rows[zaehler].Cells[7].Style.ForeColor = Color.White;
}
if (Convert.ToInt32(A[2]) != 0 && Convert.ToInt32(sp.Days) <= 30)
{
dG.Rows[zaehler].Cells[7].Style.BackColor = Color.Red;
dG.Rows[zaehler].Cells[7].Style.ForeColor = Color.White;
}
}
dG.Rows[zaehler].Cells[7].Value = Ausgabejanein(Convert.ToInt32(A[6]));
dG.Rows[zaehler].Cells[8].Value = Ausgabejanein(Convert.ToInt32(A[7]));
dG.Rows[zaehler].Cells[9].Value = Ausgabejanein(Convert.ToInt32(A[8]));
dG.Rows[zaehler].Cells[10].Value = Ausgabejanein(Convert.ToInt32(A[9]));
dG.Rows[zaehler].Cells[11].Value = A[10];
Auslesenname.closeConnection();
zaehler++;
}
Auslesen.closeConnection();
}
private void Termine()
{
fenster = 2;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "Name";
DataGridViewButtonColumn dgvButton = new DataGridViewButtonColumn();
dgvButton.HeaderText = "Name";
dgvButton.FlatStyle = FlatStyle.Flat;
dataGridView1.Columns.Insert(0, dgvButton);
dataGridView1.Columns[1].Name = "Datum";
dataGridView1.Columns[2].Name = "Uhrzeit";
dataGridView1.Columns[3].Name = "";
dataGridView1.Columns[4].Name = "Status";
dataGridView1.Columns[0].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dataGridView1.Columns[4].HeaderCell.Style.Padding = new Padding(50, 0, 50, 0);
dbConnection x = new dbConnection();
x.openConnection();
var readMitarbeiter = x.readerSQL("SELECT name,datum,uhrzeit,aktiv,status FROM Bewerbungstermine");
while (readMitarbeiter.Read())
{
string info;
if (readMitarbeiter[3].ToString() == "1")
{
if (readMitarbeiter[4].ToString() == "2")
{
info = "Angenommen";
}
else if (readMitarbeiter[4].ToString() == "3")
{
info = "Abgelehnt";
}
else
{
info = "Eingeladen";
}
dataGridView1.Rows.Add(readMitarbeiter[0].ToString(), readMitarbeiter[1].ToString(), readMitarbeiter[2].ToString() + " Uhr", "", info);
}
}
readMitarbeiter.Close();
x.closeConnection();
}
private void button1_Click(object sender, EventArgs e)
{
if (!textBox1.Text.Contains('_'))
{
MessageBox.Show("Gib deinen Namen mit Unterstrich ein!");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("Gib deinen API-Key ein");
return;
}
string name = textBox1.Text;
string key = textBox2.Text;
string hwid = GetMachineGuid();
dbConnection con = new dbConnection();
con.openConnection();
string api = "";
string id = "";
var reader = con.readerSQL("SELECT apikey,id FROM User WHERE username='******'");
while (reader.Read())
{
if (reader[0] != null)
{
api = reader[0].ToString();
}
id = reader[1].ToString();
}
reader.Close();
if (api == "" || api != key)
{
MessageBox.Show("API-Key falsch!");
return;
}
con.ExecuteSQL("UPDATE User SET hwid='" + GetMachineGuid() + "' WHERE id='" + id + "'");
con.closeConnection();
RegistryKey reg = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\LSMC-DienstApp");
reg.SetValue("Name", name);
reg.SetValue("ID", id);
reg.SetValue("API", key);
reg.Close();
MessageBox.Show("Erfolgreich eingetragen! \n Bitte starte das Programm neu!");
Application.Exit();
}
private void BedinungenRankup_Load(object sender, EventArgs e)
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Pruefungsliste");
while (reader.Read())
{
checkedListBox1.Items.Add(reader.GetString("name"));
adjustListSize(checkedListBox1);
}
reader.Close();
reader = x.readerSQL("SELECT * FROM Schulungsliste");
while (reader.Read())
{
checkedListBox2.Items.Add(reader.GetString("name"));
adjustListSize(checkedListBox2);
}
reader.Close();
reader = x.readerSQL("SELECT * FROM rankupBedinungen");
while (reader.Read())
{
List <string> tmp = new List <string>();
tmp.Add(reader.GetString("rang"));
tmp.Add(reader.GetString("prüfungen"));
tmp.Add(reader.GetString("schulungen"));
tmp.Add(reader.GetString("wochen"));
bedinungen.Add(tmp);
}
reader.Close();
update();
x.closeConnection();
}
private void BtnUseradd_Click(object sender, EventArgs e)
{
// Name realistisch angegegben, dann gehts weiter
if (check_username(Txtmembername.Text))
{
if (Txtforumname.Text != "")
{
int userid;
if (int.TryParse(Txtuserid.Text, out userid))
{
int phonenumber;
if (int.TryParse(Txtphonenumber.Text, out phonenumber))
{
dbConnection dbabfrage = new dbConnection();
dbabfrage.openConnection();
var abfrage = dbabfrage.readerSQL("SELECT Count(*) FROM User WHERE `id`= '" + userid + "'");
abfrage.Read();
if (abfrage[0].ToString() != "0")
{
MessageBox.Show("User existiert bereits!");
}
else
{
var api_key = Generate_api();
dbConnection insertquery = new dbConnection();
insertquery.openConnection();
insertquery.ExecuteSQL("INSERT INTO User (apikey, id, username, forumname, beitritt, telefon, rang, email, abteilung) VALUES ('" + api_key + "', '" + userid + "', '" + Txtmembername.Text + "', '" + Txtforumname.Text + "', NOW(), '" + phonenumber + "', '0', NULL, NULL)");
insertquery.closeConnection();
MessageBox.Show("Generierter API Key: " + api_key);
Clipboard.SetText(api_key);
MessageBox.Show("Ausgabe: " + abfrage[0]);
}
dbabfrage.closeConnection();
}
else
{
MessageBox.Show("Die Eingabe der Telefonnummer ist keine Zahl!");
}
}
else
{
MessageBox.Show("Die Eingabe der Userid ist keine Zahl!");
}
}
else
{
MessageBox.Show("Kein Forumsname angegeben!");
}
} // Benötigt keine else da in der Funktion der else Teil ist.
}
private void Insert_Mitarbeiter()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT username FROM User ORDER BY rang DESC");
while (res.Read())
{
comboBox1.Items.Add(res[0].ToString());
}
abfragemitarbeiter.closeConnection();
}
private void Ausbildung_Bemerkung_eintragen_Load(object sender, EventArgs e)
{
label1.Text = Ausbildung_User_Manage.name + " (" + Ausbildung_User_Manage.id + ")";
dbConnection con = new dbConnection();
con.openConnection();
var reader = con.readerSQL("SELECT ausbilderBemerkung from User WHERE id='" + Ausbildung_User_Manage.id + "'");
while (reader.Read())
{
textBox1.Text = reader.GetString("ausbilderBemerkung");
}
reader.Close();
con.closeConnection();
}
private void update()
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataGridViewButtonColumn dgvButton = new DataGridViewButtonColumn();
dgvButton.HeaderText = "Nummer";
dgvButton.FlatStyle = FlatStyle.Flat;
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "Typ";
dataGridView1.Columns[1].Name = "Nummer";
dataGridView1.Columns.Insert(1, dgvButton);
dataGridView1.Columns[2].Name = "Letzter Fahrer";
dataGridView1.Columns[3].Name = "Kontroliert von";
dataGridView1.Columns[4].Name = "Kontroliert am";
// dataGridView1.Columns[5].Name = "Vollständig";
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Fahrzeuge");
while (reader.Read())
{
string nmb = reader.GetString("nummer");
string typ = reader.GetString("typ");
string letzterFahrer = reader.GetString("letzterfahrer");
if (reader.GetString("kontroliert").Contains(';'))
{
string[] kontroliert = reader.GetString("kontroliert").Split(';');
dataGridView1.Rows.Add(typ, nmb, letzterFahrer, kontroliert[0], kontroliert[1]);
}
else
{
string kontroliert = reader.GetString("kontroliert").ToString();
dataGridView1.Rows.Add(typ, nmb, letzterFahrer, kontroliert, "");
}
}
reader.Close();
x.closeConnection();
}
private void Bewerbung_Load(object sender, EventArgs e)
{
dbConnection x = new dbConnection();
x.openConnection();
label1.Text = name;
var reader = x.readerSQL("SELECT * FROM Bewerbungstermine WHERE name='" + name + "'");
while (reader.Read())
{
forumsname = reader.GetString("forumsname");
userid = reader.GetString("userid");
telnummer = reader.GetString("telnummer");
}
reader.Close();
x.closeConnection();
}
private void Insert_Mitarbeiter()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT username,rang FROM User ORDER BY rang DESC");
while (res.Read())
{
if (res[0].ToString() != Form1.username && int.Parse(res[1].ToString()) <= 9)
{
comboBox1.Items.Add(res[0]);
comboBox2.Items.Add(res[0]);
comboBox3.Items.Add(res[0]);
}
}
res.Close();
abfragemitarbeiter.closeConnection();
}
private void GetTermine()
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM AusbildungsTermine WHERE status = 2 AND prüfling='" + username + "'");
while (reader.Read())
{
string tmp = reader.GetString("termin").Replace("-", "");
prüfung = DateTime.Parse(tmp);
//MessageBox.Show("Termin"+prüfung.ToShortDateString());
notificationTimer.Start();
}
reader.Close();
x.closeConnection();
}
private void Insert_Mitarbeiter()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT username,id FROM User ORDER BY rang DESC");
mitarbeiter = new List <List <string> >();
while (res.Read())
{
List <string> temp = new List <string>();
comboBox1.Items.Add(res[0]);
temp.Add(res[0].ToString()); // 0 = Username
temp.Add(res[1].ToString()); // 1 = ID
mitarbeiter.Add(temp);
}
res.Close();
abfragemitarbeiter.closeConnection();
}
private void Fahrzeugverwaltung_Load(object sender, EventArgs e)
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT nummer,typ,aktiv from Fahrzeuge");
while (reader.Read())
{
comboBox1.Items.Add(reader.GetString("typ") + " | " + reader.GetString("nummer"));
List <string> tmp = new List <string>();
tmp.Add(reader.GetString("nummer"));
tmp.Add(reader.GetString("typ"));
tmp.Add(reader.GetString("aktiv"));
fahrzeuge.Add(tmp);
}
reader.Close();
x.closeConnection();
}
private void Insert_Mitarbeiter()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT * FROM User");
mitarbeiter = new List <List <string> >();
while (res.Read())
{
List <string> temp = new List <string>();
CBMitarbeiter.Items.Add(res[2]);
temp.Add(res[2].ToString()); // 0 = Username
temp.Add(res[1].ToString()); // 1 = ID
temp.Add(res[6].ToString()); // 2 = rang
mitarbeiter.Add(temp);
}
abfragemitarbeiter.closeConnection();
}
private void button1_Click(object sender, EventArgs e)
{
DialogResult diag = MessageBox.Show("Hat der Bewerber noch fragen?", "", MessageBoxButtons.YesNo);
if (diag == DialogResult.No)
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM BewerbungFallbeispiele");
while (reader.Read())
{
List <string> tmp = new List <string>();
tmp.Add(reader.GetString("beispiel"));
tmp.Add(reader.GetString("richtig"));
tmp.Add(reader.GetString("aktiv"));
if (reader.GetString("aktiv") == "1")
{
beispiele.Add(tmp);
}
}
reader.Close();
Random rnd = new Random();
int index = rnd.Next(0, beispiele.Count);
// MessageBox.Show(index.ToString() + "\n " + beispiele.Count);
textBox1.Text = beispiele[index][0];
textBox2.Text = beispiele[index][1];
reader.Close();
this.groupBox2.Visible = false;
this.groupBox1.Visible = false;
this.groupBox3.Visible = true;
this.button1.Visible = false;
this.button2.Visible = true;
this.button3.Visible = true;
this.button4.Visible = true;
x.closeConnection();
}
}
private void FallbeispielVerwalten_Load(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "ID";
dataGridView1.Columns[1].Name = "Beispiel";
dataGridView1.Columns[2].Name = "Antwort";
dataGridView1.Columns[3].Name = "Atkiv";
dataGridView1.Columns[1].HeaderCell.Style.Padding = new Padding(100, 0, 50, 0);
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridView1.Columns[1].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dataGridView1.Columns[2].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM BewerbungFallbeispiele");
while (reader.Read())
{
string id = reader.GetString("id");
string beispiel = reader.GetString("beispiel");
string antwort = reader.GetString("richtig");
string aktiv = reader.GetString("aktiv");
dataGridView1.Rows.Add(id, beispiel, antwort, aktiv);
}
reader.Close();
x.closeConnection();
}
public void Insert_FST()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT * FROM FSTListe");
pruefungenlist = new List <List <string> >();
while (res.Read())
{
if (res[2].ToString() != "0")
{
List <string> temp = new List <string>();
pruefungen.Items.Add(res[1]);
temp.Add(res[1].ToString()); // 0 = Name
temp.Add(res[2].ToString()); // 1 = Aktiv
pruefungenlist.Add(temp);
}
}
res.Close();
abfragemitarbeiter.closeConnection();
}
private void Insert_Mitarbeiter()
{
dbConnection abfragemitarbeiter = new dbConnection();
abfragemitarbeiter.openConnection();
var res = abfragemitarbeiter.readerSQL("SELECT * FROM User ORDER BY rang DESC");
while (res.Read())
{
List <string> temp = new List <string>();
comboBox2.Items.Add(res[2]);
temp.Add(res[2].ToString()); // 0 = Username
temp.Add(res[1].ToString()); // 1 = ID
temp.Add(res[6].ToString()); // 2 = rang
temp.Add(res.GetString("sanktionspunkte")); // 2 = rang
mitarbeiter.Add(temp);
}
abfragemitarbeiter.closeConnection();
}
private void strafkatalog_add_Load(object sender, EventArgs e)
{
if (add == false)
{
dbConnection x = new dbConnection();
x.openConnection();
var reader = x.readerSQL("SELECT * FROM Strafkatalog Where id=" + id);
while (reader.Read())
{
textBox1.Text = reader.GetString("Vergehen");
if (reader.GetString("typ") == "1")
{
comboBox1.SelectedIndex = comboBox1.Items.IndexOf("leichtes Vergehen");
}
if (reader.GetString("typ") == "2")
{
comboBox1.SelectedIndex = comboBox1.Items.IndexOf("minimalschweres Vergehen");
}
if (reader.GetString("typ") == "3")
{
comboBox1.SelectedIndex = comboBox1.Items.IndexOf("mittelschweres Vergehen");
}
if (reader.GetString("typ") == "3")
{
comboBox1.SelectedIndex = comboBox1.Items.IndexOf("schweres Vergehen");
}
string[] money = reader.GetString("Geld").Split(';');
numericUpDown2.Value = int.Parse(money[0]);
numericUpDown3.Value = int.Parse(money[1]);
numericUpDown4.Value = int.Parse(money[2]);
numericUpDown5.Value = int.Parse(money[3]);
numericUpDown1.Value = int.Parse(reader.GetString("Punkte"));
}
reader.Close();
x.closeConnection();
}
}
