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