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(); } }