public void TestAddDeleteToDatabaseExaminer()
{
Examiner examiner = new Examiner
{
Id = 5,
Name = "Илья",
SurName = "Шутов",
Patronymic = "Борисович",
Examen = "Математика",
Examen_2 = "Информатика"
};
AddToDataBase add = new AddToDataBase();
add.AddNewExaminer(examiner);
DataContext db = new DataContext(connectionString);
Examiner ex = db.GetTable <Examiner>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement = true;
var actual_EndElement = examiner.Equals(ex);
DeleteToDataBase del = new DeleteToDataBase();
del.DeleteEndExaminer();
ex = db.GetTable <Examiner>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement_2 = false;
var actual_EndElement_2 = examiner.Equals(ex);
Assert.AreEqual(except_EndElement, actual_EndElement);
Assert.AreEqual(except_EndElement_2, actual_EndElement_2);
}
public void TestExaminer()
{
Examiner examiner = new Examiner()
{
Id = 1,
Name = "Илья",
SurName = "Шутов",
Patronymic = "Борисович",
Examen = "Математика",
Examen_2 = "Информатика"
};
Examiner examiner2 = new Examiner()
{
Id = 1,
Name = "Илья",
SurName = "Шутов",
Patronymic = "Борисович",
Examen = "Математика",
Examen_2 = "Информатика"
};
string except = "1 Шутов Илья Борисович Математика Информатика";
int except_properties = 6;
Assert.IsTrue(examiner.Equals(examiner2));
Assert.AreEqual(except, examiner.ToString());
Assert.AreEqual(except_properties, examiner.GetHashCode());
}
public void TestingUpdateDatabase()
{
string new_ex = "ОС";
Examiner ex = new Examiner()
{
Id = 1,
Name = "Константин",
SurName = "Курочка",
Patronymic = "Сергеевич",
Examen = "ООП",
Examen_2 = new_ex
};
UpdateDataBase update = new UpdateDataBase();
update.UpdateFirstExaminer(ex);
DataContext db = new DataContext(connectionString);
Examiner res = db.GetTable <Examiner>().FirstOrDefault();
var except = true;
var actual = ex.Equals(res);
// возврат начальных значений
ex.Examen_2 = "КС";
update.UpdateFirstExaminer(ex);
Assert.AreEqual(except, actual);
}
