public static List<Test> GetAllTests()
{
var db = new TestSystemEntities();
var tests = db.Tests.ToList();
db.Dispose();
return tests;
}
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 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;
}
