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