void FetchData() { using (SQLiteConnection connection = new SQLiteConnection(Properties.Settings.Default.connString)) connection.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT ID_Mitarbeiter, FirstName, LastName, ID_Team FROM Mitarbeiter", connection); SQLiteCommand cmd_Team = new SQLiteCommand("SELECT * FROM Teams", connection); using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { int ID_Mitarbeiter = reader.GetInt32(0); string Vorname = reader.GetString(1); string Nachname = reader.GetString(2); int ID_Team = reader.GetInt32(3); OC_Mitarbeiter.Add(new Mitarbeiter(ID_Mitarbeiter, Vorname, Nachname, ID_Team)); } } using (SQLiteDataReader reader = cmd_Team.ExecuteReader()) { while (reader.Read()) { int ID_Team = reader.GetInt32(0); string Name = reader.GetString(1); OC_Team.Add(new Team(ID_Team, Name)); } } }
private void CreateNewRow(object param) { string Parameter = (string) param; if (Parameter == "Mitarbeiter") { OC_Mitarbeiter.Add(new Mitarbeiter(99999, "?", "?", 1)); } else if (Parameter == "Team") { OC_Team.Add(new Team(99999, "?")); } else { MessageBox.Show("falscher Parameter"); } }
private void DeleteEntryVoid(object param) { string Parameter = (string)param; if (Parameter == "Mitarbeiter") { try { using (SQLiteConnection connection = new SQLiteConnection(Properties.Settings.Default.connString)) { connection.Open(); SQLiteCommand cmd = new SQLiteCommand("DELETE FROM Mitarbeiter WHERE ID_Mitarbeiter= '" + MySelectedMitarbeiter.ID_Mitarbeiter + "'", connection); cmd.ExecuteNonQuery(); } } catch (Exception exception) { Console.WriteLine(exception); } OC_Mitarbeiter.Remove(OC_Mitarbeiter.Where(i => i.ID_Mitarbeiter == MySelectedMitarbeiter.ID_Mitarbeiter).Single()); } else if (Parameter == "Team") { try { using (SQLiteConnection connection = new SQLiteConnection(Properties.Settings.Default.connString)) { connection.Open(); SQLiteCommand cmd = new SQLiteCommand("DELETE FROM Teams WHERE ID_Team= '" + MySelectedTeam.ID_Team + "'", connection); cmd.ExecuteNonQuery(); } } catch (Exception exception) { Console.WriteLine(exception); } OC_Team.Remove(OC_Team.Where(i => i.ID_Team == MySelectedTeam.ID_Team).Single()); } else { MessageBox.Show("falscher Parameter"); } }