public List<Key> GetKeys()
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
return context.Keys.ToList();
}
}
public List<Lesson> GetLessons(int chapterId)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
return context.Lessons/*.Include("Chapter")*/.Where(l => l.Chapter.Id == chapterId).ToList();
}
}
public User GetUserByEmail(string email)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
User userFromDb = context.Users.Where(u => u.Email == email).FirstOrDefault();
return userFromDb;
}
}
public Lesson Retrieve(int id)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
Lesson lessonFromDb = context.Lessons.Include(c => c.WorkedChars).Include(c => c.KnownChars).FirstOrDefault(u => u.LessonId == id);
return lessonFromDb;
}
}
public List<Chapter> GetChapters()
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
Log.Info("LessonDal", context.ObjectContext.Connection.ConnectionString);
return context.Chapters.ToList();
}
}
public User Retrieve(int id)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
User UserFromDb = context.Users.Where(u => u.Id == id).FirstOrDefault();
return UserFromDb;
}
}
public User Create(User inputObject)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
context.Users.Add(inputObject);
context.SaveChanges();
return inputObject;
}
}
public User Update(User inputObject)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
context.Users.Attach(inputObject);
context.Entry(inputObject).State = EntityState.Modified;
context.SaveChanges();
return inputObject;
}
}
public void Delete(int id)
{
using (GoKeyboardDbContext context = new GoKeyboardDbContext())
{
User UserFromDb = context.Users.Where(u => u.Id == id).FirstOrDefault();
if (UserFromDb == null)
throw new KeyboardDalException("Utilisateur introuvable en base de données");
context.Users.Remove(UserFromDb);
context.SaveChanges();
}
}
