public void GetKundenKontakteSQLTest1()
        {
            DataBaseManager target = new DataBaseManager();

            KundeKontaktTable k = new KundeKontaktTable();
            k.ID = -1; // indicates that it shall not be searched for ID
            k.Type = false;
            k.Vorname = "Franz";
            k.NachnameFirmenname = string.Empty;
            string expected = "SELECT * FROM Kunde WHERE Vorname = ?";
            string actual;
            actual = target.GetKundenKontakteSQL(k);
            Assert.AreEqual(expected, actual);
        }
 public void GetKundenKontakteSQLTest3()
 {
     DataBaseManager target = new DataBaseManager();
     KundeKontaktTable k = new KundeKontaktTable();
     k.ID = -1; // don't search for ID
     k.Type = true;
     k.Vorname = "Hans";
     k.NachnameFirmenname = "Huber";
     string expected = "SELECT * FROM Kontakt WHERE Vorname = ? AND Nachname_Firmenname = ?";
     string actual;
     actual = target.GetKundenKontakteSQL(k);
     Assert.AreEqual(expected, actual);
 }