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