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