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 AddQuestion(Question question)
{
using (var db = new QuizDatabase())
{
db.Questions.Add(question);
db.SaveChanges();
}
}
public void AddQuiz(Quiz quiz)
{
using (var db = new QuizDatabase())
{
db.Quizs.Add(quiz);
db.SaveChanges();
}
}
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 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();
}
}