public void Register(string username, string email, string password) { using (var db = new CinemaDb()) { var existingUser = db.Users.FirstOrDefault(u => u.Username.ToLower() == username.ToLower()); if (existingUser != null) { throw new LogicException("That username is already in use!"); } existingUser = db.Users.FirstOrDefault(u => u.Email.ToLower() == email.ToLower()); if (existingUser != null) { throw new LogicException("That e-mail is already in use!"); } if (!password.IsPasswordOk()) { throw new LogicException("Password should be at least 6 symbols!"); } db.Users.Add(new Users() { Email = email, Password = password, Username = username, }); db.SaveChanges(); } }
public Movies BookAMovie(int id) { using (var db = new CinemaDb()) { var movie = db.Movies.FirstOrDefault(m => m.Id == id); if (movie != null) { db.Bookings.Add(new Bookings() { MovieId = movie.Id, Title = movie.Title, Pic = movie.Pic, Description = movie.Description, SelectedTime = movie.AvailableTime, Auditorium = movie.AuditoriumId, }); db.SaveChanges(); return(movie); } } return(null); }
//to delete a category public void Delete(int id) { using (var db = new CinemaDb()) { var category = db.Categories.FirstOrDefault(c => c.Id == id); db.Categories.Remove(category); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new CinemaDb()) { var movie = db.Movies.FirstOrDefault(m => m.Id == id); db.Movies.Remove(movie); db.SaveChanges(); } }
public void Update(int curUserId, int bookingId) { using (var db = new CinemaDb()) { var bookingData = db.Bookings.FirstOrDefault(b => b.Id == bookingId); bookingData.UserId = curUserId; db.SaveChanges(); } }
public string CreateNew(string title) { using (var db = new CinemaDb()) { db.Categories.Add(new Categories() { Title = title, }); db.SaveChanges(); return(null); } }
public Bookings CancelBooking(int id) { using (var db = new CinemaDb()) { var currentBooking = db.Bookings.FirstOrDefault(b => b.Id == id); if (currentBooking != null) { db.Bookings.Remove(currentBooking); db.SaveChanges(); return(currentBooking); } } return(null); }
public Movies CancelUserBookings(int movieId) { //returns a movie(movies) that was canceled by a client using (var db = new CinemaDb()) { var cancelBooking = db.Bookings.FirstOrDefault(m => m.MovieId == movieId); if (cancelBooking != null) { db.Bookings.Remove(cancelBooking); var cancelation = db.Movies.FirstOrDefault(m => m.Id == movieId); var returnedseat = db.Theaters.FirstOrDefault(t => t.Id == cancelation.AuditoriumId); returnedseat.TotalSeats++; db.SaveChanges(); return(cancelation); } } return(null); }
public string CreateNewMovie(string title, string director, string description, int categoryId, int price, int?auditorium, int?length) { using (var db = new CinemaDb()) { db.Movies.Add(new Movies() { Title = title, Director = director, PlayingTime = DateTime.Now, TextAbout = description, Category = categoryId, PriceId = price, AuditoriumId = auditorium, Length = length, Image = "", }); db.SaveChanges(); return(null); } }
//Movies chosen by title //gets a list of all movies chosen by the user public List <Movies> GetUserBookings(int movieId) { //returns a movie that a client chose using (var db = new CinemaDb()) { var movie = db.Movies.FirstOrDefault(m => m.Id == movieId); var theater = db.Theaters.FirstOrDefault(t => t.Id == movie.AuditoriumId); if (movie != null && theater.TotalSeats > 0) { //need to count down the number of seats available at the auditorium theater.TotalSeats--; db.Bookings.Add(new Bookings() { MovieId = movie.Id, WatchingTime = movie.PlayingTime }); db.SaveChanges(); return(db.Movies.OrderBy(c => c.Id).ToList()); } } return(null); }