public List <Movies> GetAllMovies() { using (var db = new CinemaNewDB()) { return(db.Movies.OrderBy(m => m.Name).ToList()); } }
public Movies GetMovies(int id) { using (var db = new CinemaNewDB()) { return(db.Movies.FirstOrDefault(m => m.Id == id)); } }
public Category GetCategory(int id) { using (var db = new CinemaNewDB()) { return(db.Category.FirstOrDefault(c => c.Id == id)); } }
public List <Category> GetAllCategories() { using (var db = new CinemaNewDB()) { return(db.Category.OrderBy(c => c.Name).ToList()); } }
public List <UserBookings> GetUserBookings() { using (var db = new CinemaNewDB()) { return(db.UserBookings.OrderBy(b => b.Name).ToList()); } }
public List <Movies> GetByCategory(int categoryId) { using (var db = new CinemaNewDB()) { return(db.Movies .Where(m => m.CategoryId == categoryId) .OrderByDescending(m => m.Name) .ToList()); } }
public string CreateBooking(string name) { using (var db = new CinemaNewDB()) { db.UserBookings.Add(new UserBookings() { Name = name, }); db.SaveChanges(); } return(null); }
public UserBookings CancelBooking(string name) { using (var db = new CinemaNewDB()) { var booking = db.UserBookings.FirstOrDefault(b => b.Name.ToLower() == name.ToLower()); if (booking != null) { db.UserBookings.Remove(booking); db.SaveChanges(); return(booking); } } return(null); }