public List <Grade> GetUserGradeFromQuizNameAndUserId(string quizName, int userId)
{
using (var db = new QuizDatabase())
{
return(db.Grades.Include("Quiz").Include("User").Where(g => g.Quiz.Name == quizName).Where(g => g.UserId == userId).ToList());
}
}
public ObservableCollection <Quiz> GetQuizzes()
{
using (var db = new QuizDatabase())
{
return(new ObservableCollection <Quiz>(db.Quizs.ToList()));
}
}
public List <User> GetStudentName()
{
using (var db = new QuizDatabase())
{
return(db.Users.ToList());
}
}
public bool DoesGradeExcist(int quizId, int userId)
{
using (var db = new QuizDatabase())
{
return(db.Grades.Any(g => g.QuizId == SelectedQuizId && g.UserId == LoggedInUserId));
}
}
public List <Quiz> GetQuizName()
{
using (var db = new QuizDatabase())
{
return(db.Quizs.ToList());
}
}
public List <Question> GetQuestionsForQuiz(int quizId)
{
using (var db = new QuizDatabase())
{
return(db.Questions.Where(q => q.QuizId == quizId).ToList());
}
}
public ObservableCollection <Grade> GetUserGrade(int userId)
{
using (var db = new QuizDatabase())
{
return(new ObservableCollection <Grade>(db.Grades.Include("Quiz").Include("User").Where(g => g.UserId == userId)));
}
}
public bool CheckEmailExicts(string email)
{
using (QuizDatabase db = new QuizDatabase())
{
return(db.Users.Any(u => u.Email == email));
}
}
public User CheckEmail(string email)
{
using (QuizDatabase db = new QuizDatabase())
{
return(db.Users.FirstOrDefault(u => u.Email == email));
}
}
public Repository()
{
WriteLine("Does database excist?");
using (QuizDatabase db = new QuizDatabase())
{
bool wasDbCreated = db.Database.CreateIfNotExists();
WriteLine(wasDbCreated ? "Database was created" : "Database already excists");
}
WriteLine("All done");
using (var db = new QuizDatabase())
{
if (!db.Users.Any(u => u.Email == "*****@*****.**"))
{
var user = new User()
{
FirstName = "Admin",
LastName = "Adminsson",
Email = "*****@*****.**",
Password = "******",
IsAdmin = true
};
db.Users.Add(user);
db.SaveChanges();
Console.WriteLine("[email protected] added");
}
}
}
public void AddUser(User user)
{
using (QuizDatabase db = new QuizDatabase())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public void SaveUserQuizScore(Grade userGrade)
{
using (var db = new QuizDatabase())
{
db.Grades.Add(userGrade);
db.SaveChanges();
}
}
public List <Grade> GetUserGradeFromQuizName(string quizName)
{
using (var db = new QuizDatabase())
{
List <Grade> temp = db.Grades.Include("Quiz").Include("User").Where(g => g.Quiz.Name == quizName).ToList();
return(db.Grades.Include("Quiz").Include("User").Where(g => g.Quiz.Name == quizName).ToList());
}
}
public void AddQuiz(Quiz quiz)
{
using (var db = new QuizDatabase())
{
db.Quizs.Add(quiz);
db.SaveChanges();
}
}
public void AddQuestion(Question question)
{
using (var db = new QuizDatabase())
{
db.Questions.Add(question);
db.SaveChanges();
}
}
public void RemoveQuiz(Quiz quiz)
{
using (var db = new QuizDatabase())
{
db.Quizs.Attach(quiz);
db.Quizs.Remove(quiz);
db.SaveChanges();
}
}
public void RemoveUser(User user)
{
using (var db = new QuizDatabase())
{
db.Users.Attach(user);
db.Users.Remove(user);
db.SaveChanges();
}
}
public ObservableCollection <User> GetUsers()
{
using (QuizDatabase db = new QuizDatabase())
{
foreach (var item in db.Users.ToList())
{
Users.Add(item);
}
return(Users);
}
}
public ObservableCollection <Quiz> GetQuizForUser(int userId)
{
using (var db = new QuizDatabase())
{
List <int> quizIdsList = db.Grades.Where(g => g.UserId == userId).Select(g => g.QuizId).ToList();
return(new ObservableCollection <Quiz>(db.Quizs.Where(q => !quizIdsList.Contains(q.Id))
.Where(q => q.CreationDate < DateTime.Now)
.Where(q => q.EndDate > DateTime.Now)
.ToList()));
}
}
public List <Grade> GetQuizStats()
{
using (var db = new QuizDatabase())
{
List <Grade> Grades = new List <Grade>();
Grades = db.Grades.Include("Quiz").Include("User")
.OrderBy(g => g.Quiz.Id)
.ToList();
return(Grades);
}
}