public void DropQuiz(string userId, Guid slideId) { var quizzes = db.UserQuizzes.Where(q => q.UserId == userId && q.SlideId == slideId).ToList(); foreach (var q in quizzes) { q.isDropped = true; } db.SaveChanges(); }
public void UpdateTempCourseLastUpdateTime(string courseId) { var course = db.TempCourses.Find(courseId); if (course == null) { return; } course.LastUpdateTime = DateTime.Now; db.SaveChanges(); }
public void CreateUlearnBotUserIfNotExists() { if (!db.Users.Any(u => u.UserName == UlearnBotUsername)) { var user = new ApplicationUser { UserName = UlearnBotUsername, FirstName = "Ulearn", LastName = "bot", Email = "*****@*****.**", }; var userManager = new ULearnUserManager(db); userManager.Create(user, StringUtils.GenerateSecureAlphanumericString(10)); db.SaveChanges(); } }
public QuizVersion AddQuizVersionIfNeeded(string courseId, QuizSlide slide) { var slideId = slide.Id; var quizXml = slide.QuizNormalizedXml; var lastQuizVersion = GetLastQuizVersion(courseId, slideId); var newQuizVersion = new QuizVersion { CourseId = courseId, SlideId = slideId, LoadingTime = DateTime.Now, NormalizedXml = quizXml }; if (lastQuizVersion == null || lastQuizVersion.NormalizedXml != newQuizVersion.NormalizedXml) { db.QuizVersions.Add(newQuizVersion); db.SaveChanges(); return(newQuizVersion); } return(lastQuizVersion); }
public void Delete(UserQuestion userSolution) { db.UserQuestions.Remove(userSolution); db.SaveChanges(); }