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