Ejemplo n.º 1
0
        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);
        }