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