public void AddContactTest1() { ContactModel model = new orgainizer.DataModels.ContactModel("899941100022", "TestSurname", "test", "*****@*****.**"); AddContact contact = new AddContact(); contact.Add(model, connection); var cmdText = $"SELECT * FROM CONTACTS WHERE [Phone_Num] = '{model.Phone}' " + $"AND [Surname] = '{model.Surname}' " + $"AND [Initials] = '{model.Initials}'" + $"AND [Email] = '{model.Email}'"; connection.Open(); OleDbCommand TestCommand = new OleDbCommand(cmdText, connection); if (TestCommand.ExecuteReader().HasRows) { connection.Close(); Assert.Pass(); } else { connection.Close(); Assert.Fail("В таблице нет записи"); } }
public void AddContactTest2() { ContactModel model = new ContactModel("+79994256467", "Тестовая запись", "ТЗ", "тест@mail.com"); AddContact contact = new AddContact(); contact.Add(model, connection); var cmdText = $"SELECT * FROM CONTACTS WHERE [Phone_Num] = '{model.Phone}' " + $"AND [Surname] = '{model.Surname}' " + $"AND [Initials] = '{model.Initials}'" + $"AND [Email] = '{model.Email}'"; connection.Open(); OleDbCommand TestCommand = new OleDbCommand(cmdText, connection); if (TestCommand.ExecuteReader().HasRows) { connection.Close(); Assert.Pass(); } else { connection.Close(); Assert.Fail("В таблице нет записи"); } }
public void Setup() { connection.Open(); OleDbCommand TruncateCommand = new OleDbCommand("DELETE FROM Contacts", connection); TruncateCommand.ExecuteNonQuery(); connection.Close(); AddContact contact = new AddContact(); ContactModel model; for (int Item = 0; Item < 100; Item++) { model = new ContactModel($"899941100{Item}", $"TestSurname {Item}", $"test {Item}", $"Test{Item}@mail.com"); contact.Add(model, connection); } }