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