public List <PrinterUser> GetNewUsers() { using (var db = new AcademicQuizBotDb()) { var newUsers = db.Users.Where(u => !u.IsPrintedTicked).ToList(); var printUsers = new List <PrinterUser>(); foreach (var user in newUsers) { var personalData = user.PersonalData.FirstOrDefault(); if (personalData == null) { continue; } printUsers.Add(new PrinterUser { Id = user.UserId, FirstName = personalData.FirstName, LastName = personalData.LastName, TicketNumber = user.Id }); user.IsPrintedTicked = true; } db.SaveChanges(); return(printUsers); } }
public void ClearPersonalData(string userId) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); if (user == null) { return; } db.PersonalDatas.RemoveRange(user.PersonalData); db.SaveChanges(); } }
public void ClearAnswerStatistics(string userId) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); if (user == null) { return; } db.AnswerStatistics.RemoveRange(user.AnswerStatistic); db.SaveChanges(); } }
public void SetLiteQuizComlete(string userId) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); if (user == null) { return; } user.IsFullQuiz = true; db.SaveChanges(); } }
public void AddAnswerStatistics(string userId, AnswerStatistic answerStatistics) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); if (user == null) { return; } user.AnswerStatistic.Add(answerStatistics); db.SaveChanges(); } }
public void SetUserData(string userId, PersonalData userData) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); if (user == null) { return; } user.PersonalData.Add(userData); db.SaveChanges(); } }
private User AddNewUser(string userId, string name) { using (var db = new AcademicQuizBotDb()) { var user = new User { UserId = userId, Name = name }; db.Users.Add(user); db.SaveChanges(); return(user); } }
public void Delete(string userId) { ClearAnswerStatistics(userId); ClearPersonalData(userId); using (var db = new AcademicQuizBotDb()) { var entity = db.Users.FirstOrDefault(e => e.UserId == userId); if (entity == null) { return; } db.Users.Remove(entity); db.SaveChanges(); } }