public void TestAddDeleteToDatabaseSpecialty()
{
Specialty spec = new Specialty()
{
Id = 1,
SpecName = "Машино- и приборостроение",
NameGroup = "МТ-21",
NameGroup_2 = "МТ-22"
};
AddToDataBase add = new AddToDataBase();
add.AddNewSpecialty(spec);
DataContext db = new DataContext(connectionString);
Specialty sp = db.GetTable <Specialty>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement = true;
var actual_EndElement = spec.Equals(sp);
DeleteToDataBase del = new DeleteToDataBase();
del.DeleteSpecialty();
sp = db.GetTable <Specialty>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement_2 = false;
var actual_EndElement_2 = spec.Equals(sp);
Assert.AreEqual(except_EndElement, actual_EndElement);
Assert.AreEqual(except_EndElement_2, actual_EndElement_2);
}
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 TestAddDeleteToDatabaseStudent()
{
Student student = new Student()
{
Id = 12,
Name = "Юрий",
SurName = "Корнеев",
Patronymic = "Олегович",
DateBr = new DateTime(2002, 4, 2),
Sex = "Муж",
Group = "ИТП-21",
ExamName_1 = "ООП",
ExamName_2 = "КС",
ExamName_3 = "Экономика",
ExamDate_1 = new DateTime(2021, 1, 12),
ExamDate_2 = new DateTime(2021, 1, 14),
ExamDate_3 = new DateTime(2021, 1, 16),
Mark_1 = 7, Mark_2 = 8, Mark_3 = 6
};
AddToDataBase add = new AddToDataBase();
add.AddNewStudent(student);
DataContext db = new DataContext(connectionString);
Student st = db.GetTable <Student>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement = true;
var actual_EndElement = student.Equals(st);
DeleteToDataBase del = new DeleteToDataBase();
del.DeleteEndStudent();
st = db.GetTable <Student>().OrderByDescending(u => u.Id).FirstOrDefault();
var except_EndElement_2 = false;
var actual_EndElement_2 = student.Equals(st);
Assert.AreEqual(except_EndElement, actual_EndElement);
Assert.AreEqual(except_EndElement_2, actual_EndElement_2);
}
