Esempio n. 1
0
 public static List<Test> GetAllTests()
 {
     var db = new TestSystemEntities();
     var tests = db.Tests.ToList();
     db.Dispose();
     return tests;
 }
Esempio n. 2
0
 public static Test GetTest(int id)
 {
     var db = new TestSystemEntities();
     var test = db.Tests
         .Include(p => p.TestQuestions.Select(a => a.Question))
         .Where(t => t.Id == id)
         .FirstOrDefault();
     return test;
 }
Esempio n. 3
0
 public static void DeleteQuestion(int id)
 {
     using (var db = new TestSystemEntities())
     {
         db.StudentAnswers.RemoveRange(db.StudentAnswers.Where(s => s.QuestionId == id));
         db.TestQuestions.Remove(db.TestQuestions.Where(q => q.QuestionId == id).FirstOrDefault());
         db.Questions.Remove(db.Questions.Where(q => q.Id == id).FirstOrDefault());
         db.SaveChanges();
     }
 }
Esempio n. 4
0
 public static void UpdateTest(Test test)
 {
     using (var db = new TestSystemEntities())
     {
         db.Tests.Add(test);
         var entry = db.Entry(test);
         entry.State = EntityState.Modified;
         db.SaveChanges();
     }
 }
Esempio n. 5
0
 public static void UpdateTestQuestions(Question[] questions)
 {
     if (questions == null) return;
     using (var db = new TestSystemEntities())
     {
         foreach (var item in questions)
         {
             db.Questions.Add(item);
             var entry = db.Entry(item);
             entry.State = EntityState.Modified;
         }
         db.SaveChanges();
     }
 }
Esempio n. 6
0
        public static void AddQuestion(int test, Question q)
        {
            using (var db = new TestSystemEntities())
            {
                db.Questions.Add(q);
                var entry = db.Entry(q);
                entry.State = EntityState.Added;
                db.SaveChanges();

                TestQuestion t = new TestQuestion()
                {
                    QuestionId = q.Id,
                    TestId = test
                };
                db.TestQuestions.Add(t);
                db.SaveChanges();
            }
        }
Esempio n. 7
0
 public static void AddAnswers(List<StudentAnswer> answers)
 {
     using (var db = new TestSystemEntities())
     {
         foreach (var item in answers)
         {
             db.StudentAnswers.Add(item);
         }
         db.SaveChanges();
     }
 }
Esempio n. 8
0
        public static int AddStudent(string p, int test)
        {
            var db = new TestSystemEntities();
            Student stud = new Student(){
                Name = p,
                TestId = test
            };
            db.Students.Add(stud);
            db.SaveChanges();
            db.Dispose();

            return stud.Id;
        }
Esempio n. 9
0
 public static User GetUser(string username, string password)
 {
     var db = new TestSystemEntities();
     var user = db.Users.Where(u => u.Username == username && u.Password == password).FirstOrDefault();
     db.Dispose();
     return user;
 }
Esempio n. 10
0
 public static int AddNewTest(string title)
 {
     Test t = new Test()
     {
         Title = title
     };
     using (var db = new TestSystemEntities())
     {
         
         db.Tests.Add(t);
         db.SaveChanges();
     }
     return t.Id;
 }
Esempio n. 11
0
        public static void DeleteTest(int id)
        {
            var db = new TestSystemEntities();
            var test = db.Tests.Where(t => t.Id == id).FirstOrDefault();;
            var students = db.Students.Where(s => s.TestId == id).ToList();

            foreach (var stud in students)
            {
                db.StudentAnswers.RemoveRange(db.StudentAnswers.Where(s => s.StudentId == stud.Id));
                db.Students.Remove(db.Students.Where(s => s.Id == stud.Id).FirstOrDefault());
            }

            var questions = db.TestQuestions.Where(t => t.TestId == test.Id).Select(s => s.Question).ToList();
            db.TestQuestions.RemoveRange(db.TestQuestions.Where(t => t.TestId == test.Id));
            db.Questions.RemoveRange(questions);
            db.Tests.Remove(test);

            db.SaveChanges();
            db.Dispose();
        }
Esempio n. 12
0
 public static List<Student> GetStudents(int id)
 {
     var db = new TestSystemEntities();
     var students = db.Students.Where(s => s.TestId == id).ToList();
     db.Dispose();
     return students;
 }
Esempio n. 13
0
 public static List<StudentAnswer> GetStudentAnswers(int id)
 {
     var db = new TestSystemEntities();
     var answers = db.StudentAnswers
         .Include(m => m.Question)
         .Include(q => q.Student)
         .Where(s => s.StudentId == id)
         .OrderBy(o => o.QuestionId)
         .ToList();
     db.Dispose();
     return answers;
 }