public void InsertAndDelete() { DM.Insert(contact); int p = DM.CountRows("People"); Assert.AreEqual(1, DM.DoesExistContact(contact)); DM.Remove(contact); Assert.AreEqual(0, DM.DoesExistContact(contact)); }
static void Main(string[] args) { string server = ".\\SQLEXPRESS"; string database = "PhoneBook"; DataManagement DM = new DataManagement(new DataContext(server, database)); Location l = new Location("Lodz", "00-000"); Location l2 = new Location("Lodz", "10-000"); Location l3 = new Location("Lodz", "20-000"); Person p = new Person("Tomasz", "Smolarek", l); Person p2 = new Person("Learn", "C#", l2); Person p3 = new Person("Love", "It", l3); PhoneNumber n = new MobilePhoneNumber("607890726"); PhoneNumber n2 = new MobilePhoneNumber("607890726"); PhoneNumber n3 = new MobilePhoneNumber(); Contact c = new Contact(p, n); Contact c2 = new Contact(p2, n2); Contact c3 = new Contact(p3, n3); DM.Insert(c); DM.Insert(c2); DM.Insert(c3); Console.WriteLine(DM.DoesExistContact(c)); System.Threading.Thread.Sleep(5000); DM.Remove(c); DM.Remove(c2); DM.Remove(c3); Console.WriteLine(DM.DoesExistContact(c)); Console.WriteLine(n3.Number); int count = DM.CountRows("Contacts"); Console.WriteLine(count); }