public static List<Test> GetAllTests() { var db = new TestSystemEntities(); var tests = db.Tests.ToList(); db.Dispose(); return tests; }
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; }
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(); } }
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(); } }
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(); } }
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(); } }
public static void AddAnswers(List<StudentAnswer> answers) { using (var db = new TestSystemEntities()) { foreach (var item in answers) { db.StudentAnswers.Add(item); } db.SaveChanges(); } }
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; }
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; }
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; }
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(); }
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; }
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; }