public async Task <bool> SaveNewQuiz(Quiz quiz) { using (var context = new AssessmentToolContext()) { context.Quizzes.Add(quiz); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> UpdateQuiz(Quiz quiz) { using (var context = new AssessmentToolContext()) { context.Entry(quiz).State = System.Data.Entity.EntityState.Modified; return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> NewStudentQuiz(StudentQuiz studentQuiz) { using (var context = new AssessmentToolContext()) { context.StudentQuizzes.Add(studentQuiz); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> SaveNewQuestion(Question question) { using (var context = new AssessmentToolContext()) { context.Questions.Add(question); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> NewAttemptedQuestion(AttemptedQuestion attemptedQuestion) { using (var context = new AssessmentToolContext()) { context.AttemptedQuestions.Add(attemptedQuestion); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> NewRole(IdentityRole role) { using (var context = new AssessmentToolContext()) { context.Roles.Add(role); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> DeleteQuestion(Question question) { using (var context = new AssessmentToolContext()) { context.Questions.Attach(question); context.Options.RemoveRange(question.Options); context.Questions.Remove(question); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> DeleteQuiz(Quiz quiz) { using (var context = new AssessmentToolContext()) { context.Quizzes.Attach(quiz); quiz.Questions.ForEach(qu => context.Options.RemoveRange(qu.Options)); context.Questions.RemoveRange(quiz.Questions); context.Quizzes.Remove(quiz); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> DeleteRole(string ID) { using (var context = new AssessmentToolContext()) { var role = context.Roles.Find(ID); if (role != null) { context.Entry(role).State = System.Data.Entity.EntityState.Deleted; } return(await context.SaveChangesAsync() > 0); } }
//public async Task<bool> NewUser(AssessmentToolUser user) //{ // using (var context = new AssessmentToolContext()) // { // context.Users.Add(user); // return await context.SaveChangesAsync() > 0; // } //} public async Task <bool> UpdateRole(IdentityRole role) { using (var context = new AssessmentToolContext()) { var oldRole = context.Roles.Find(role.Id); if (oldRole != null) { oldRole.Name = role.Name; context.Entry(oldRole).State = System.Data.Entity.EntityState.Modified; } return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> UpdateQuestion(Question question) { using (var context = new AssessmentToolContext()) { //get the question by ID var oldQuestion = context.Questions.Find(question.ID); //delete this old question with all options context.Options.RemoveRange(oldQuestion.Options); context.Questions.Remove(oldQuestion); //add a new question with new options context.Questions.Add(question); return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> RemoveUserRole(string userID, string roleID) { using (var context = new AssessmentToolContext()) { var user = context.Users.Find(userID); if (user != null) { var userRole = user.Roles.Where(r => r.RoleId == roleID).FirstOrDefault(); if (user != null) { user.Roles.Remove(userRole); } } return(await context.SaveChangesAsync() > 0); } }
public async Task <bool> AddUserRole(string userID, string roleID) { using (var context = new AssessmentToolContext()) { var user = context.Users.Find(userID); var role = context.Roles.Find(roleID); if (user != null && role != null) { user.Roles.Add(new IdentityUserRole() { UserId = userID, RoleId = roleID }); } return(await context.SaveChangesAsync() > 0); } }