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 User GetUser(string userId) { using (var db = new AcademicQuizBotDb()) { return(db.Users.FirstOrDefault(u => u.UserId == userId)); } }
public ICollection <AnswerStatistic> GetAnswerStatistic(string userId) { using (var db = new AcademicQuizBotDb()) { var user = db.Users.FirstOrDefault(u => u.UserId == userId); return(user?.AnswerStatistic); } }
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(); } }
public string GetWinner() { using (var db = new AcademicQuizBotDb()) { var userlist = db.Users.Where(u => u.PersonalData.Count > 0 && u.PersonalData.FirstOrDefault().IsAccepted).ToList(); Random r = new Random(); int count = userlist.Count; if (count == 0) { return(""); } int index = r.Next(count); var winner = userlist[index]; var pd = winner.PersonalData.First(); string winnerName = $"{pd.FirstName} {pd.LastName} {winner.Id}"; return(winnerName); } }