public void Sort(string key, bool ascending) { // Take action based on key switch (key) { case "Apparaatnaam": if (ascending) { Apparaten.Sort((x, y) => x.ApparaatNaam.CompareTo(y.ApparaatNaam)); } else { Apparaten.Sort((x, y) => - 1 * x.ApparaatNaam.CompareTo(y.ApparaatNaam)); } break; case "Omschrijving": if (ascending) { Apparaten.Sort((x, y) => x.Omschrijving.CompareTo(y.Omschrijving)); } else { Apparaten.Sort((x, y) => - 1 * x.Omschrijving.CompareTo(y.Omschrijving)); } break; } }
void LoadApparaten(SqliteConnection conn) { bool shouldClose = false; // Is the database already open? if (conn.State != ConnectionState.Open) { shouldClose = true; conn.Open(); } // Execute query using (var command = conn.CreateCommand()) { try { // Create new command command.CommandText = "SELECT DISTINCT ID FROM [Apparaat]"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var apparaat = new ApparaatModel(); var id = (string)reader["ID"]; apparaat.Load(conn, id); //AddPersoon(persoon); Apparaten.Add(apparaat); } } } catch (Exception Exception) { Debug.WriteLine(Exception.Message); } } if (shouldClose) { conn.Close(); } }
public bool AddApparaat(ApparaatModel _apparaat) { Apparaten.Add(_apparaat); return(true); }