public bool UpdateShowDAL(ShowEntity updateShow) { bool showUpdated = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var objShow = new Show(); objShow = ObjContext.Shows.Find(updateShow.ShowId); if (objShow != null) { objShow.ShowDate = updateShow.ShowDate; objShow.ShowTime = updateShow.ShowTime; objShow.MovieId = updateShow.MovieId; objShow.Price = updateShow.Price; objShow.ScreenId = updateShow.ScreenId; int NoOfRowsAffected = ObjContext.SaveChanges(); showUpdated = NoOfRowsAffected > 0; } else { showUpdated = false; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(showUpdated); }
public bool AddMovieDAL(MovyEntity newMovie) { try { bool isAdded = false; var ObjContext = new CinestarEntitiesDAL(); var objMovie = new Movy(); objMovie.MovieId = newMovie.MovieId; objMovie.MovieName = newMovie.MovieName; objMovie.MovieUrl = newMovie.MovieUrl; objMovie.ReleaseDate = newMovie.ReleaseDate; objMovie.GenreId = newMovie.GenreId; objMovie.LanguageId = newMovie.LanguageId; objMovie.MovieDescription = newMovie.MovieDescription; ObjContext.Movies.Add(objMovie); int NoOfrowsAffected = ObjContext.SaveChanges(); if (NoOfrowsAffected > 0) { isAdded = true; } return(isAdded); } catch (Exception Ex) { return(false); } }
public bool DeleteShowDAL(int deleteShowID) { bool showDeleted = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var objShow = new Show(); objShow = ObjContext.Shows.Find(deleteShowID); if (objShow != null) { ObjContext.Shows.Remove(objShow); int NoOfRowsAffected = ObjContext.SaveChanges(); showDeleted = NoOfRowsAffected > 0; } else { showDeleted = false; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(showDeleted); }
public bool AddShowDAL(ShowEntity newShow) { bool showAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var Objshow = new Show(); Objshow.ShowDate = newShow.ShowDate; Objshow.ShowTime = newShow.ShowTime; Objshow.MovieId = newShow.MovieId; Objshow.Price = newShow.Price; Objshow.ScreenId = newShow.ScreenId; ObjContext.Shows.Add(Objshow); int NoOfRowsAffected = ObjContext.SaveChanges(); bool showLayoutAdded = ShowSeatLayoutDAL.AddScreenLayout(Objshow.ShowId); if (NoOfRowsAffected > 0 && showLayoutAdded) { showAdded = true; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(showAdded); }
public bool SignUpUserDAL(UserEntity newUser) { bool userAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var ObjUser = new User(); ObjUser.UserName = newUser.UserName; ObjUser.Password = newUser.Password; ObjContext.Users.Add(ObjUser); int NoOfRowsAffected = ObjContext.SaveChanges(); if (NoOfRowsAffected > 0) { newUser.UserName = ObjUser.UserName; userAdded = true; } else { userAdded = false; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(userAdded); }
public bool GiveFeedbackDAL(FeedbackEntity newFeedback) { try { bool isAdded = false; var ObjContext = new CinestarEntitiesDAL(); var objFeedback = new Feedback(); objFeedback.FeedbackId = newFeedback.FeedbackId; objFeedback.FeedbackDetails = newFeedback.FeedbackDetails; objFeedback.ViewersId = newFeedback.ViewersId; ObjContext.Feedbacks.Add(objFeedback); int NoOfrowsAffected = ObjContext.SaveChanges(); if (NoOfrowsAffected > 0) { isAdded = true; } return(isAdded); } catch (Exception Ex) { return(false); } }
public bool CreateTicketDAL(TicketEntity newTicket) { bool ticketAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); Ticket ObjTicket = new Ticket(); ObjTicket.NoOfTickets = newTicket.NoOfTickets; ObjTicket.ShowId = newTicket.ShowId; ObjTicket.Price = newTicket.Price; ObjTicket.ViewersId = newTicket.ViewersId; ObjTicket.TransactionDate = newTicket.TransactionDate; ObjTicket.MovieId = newTicket.MovieId; ObjTicket.Seats = newTicket.Seats; ObjContext.Tickets.Add(ObjTicket); int NoOfRowsAffected = ObjContext.SaveChanges(); if (NoOfRowsAffected > 0) { ticketAdded = true; } else { ticketAdded = false; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(ticketAdded); }
public static bool AddViewerProfilesDAL(ViewerProfileEntity newViewerProfile) { bool viewerProfileAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var ObjViewerProfile = new ViewerProfile(); ObjViewerProfile.FirstName = newViewerProfile.FirstName; ObjViewerProfile.LastName = newViewerProfile.LastName; ObjViewerProfile.MobileNo = newViewerProfile.MobileNo; ObjViewerProfile.EmailId = newViewerProfile.EmailId; ObjViewerProfile.UserName = newViewerProfile.UserName; ObjContext.ViewerProfiles.Add(ObjViewerProfile); int NoOfRowsAffected = ObjContext.SaveChanges(); if (NoOfRowsAffected > 0) { newViewerProfile.ViewersId = ObjViewerProfile.ViewersId; viewerProfileAdded = true; } else { viewerProfileAdded = false; } } catch (Exception ex) { throw new MovieExceptions(ex.Message); } return(viewerProfileAdded); }
public static bool AddScreenLayout(int showId) { bool layoutAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var objSeatLayout = new ShowSeatLayout(); objSeatLayout.ShowId = showId; objSeatLayout.LayoutId = showId; objSeatLayout.UnavailableSeats = string.Empty; ObjContext.ShowSeatLayouts.Add(objSeatLayout); int NoOfRowsAffected = ObjContext.SaveChanges(); if (NoOfRowsAffected > 0) { layoutAdded = true; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading data", ex); } return(layoutAdded); }
public bool DeleteMovieDAL(int movieId) { bool isDeleted = false; var objContext = new CinestarEntitiesDAL(); var objMovie = objContext.Movies.Find(movieId); if (objMovie != null) { objContext.Movies.Remove(objMovie); int NoofRowsAffected = objContext.SaveChanges(); isDeleted = (NoofRowsAffected > 0); } else { isDeleted = false; } return(isDeleted); }
public bool UpdateMovieDAL(MovyEntity updateMovie) { bool movieUpdated = false; var ObjContext = new CinestarEntitiesDAL(); var objMovie = ObjContext.Movies.Find(updateMovie.MovieId); if (objMovie != null) { objMovie.MovieId = updateMovie.MovieId; objMovie.MovieName = updateMovie.MovieName; objMovie.MovieUrl = updateMovie.MovieUrl; objMovie.ReleaseDate = updateMovie.ReleaseDate; objMovie.GenreId = updateMovie.GenreId; objMovie.LanguageId = updateMovie.LanguageId; objMovie.MovieDescription = updateMovie.MovieDescription; int NoofRowsAffected = ObjContext.SaveChanges(); movieUpdated = (NoofRowsAffected > 0); } return(movieUpdated); }
public static bool UpdateLayoutDAL(ShowSeatLayoutEntity layout) { CinestarEntitiesDAL cinestar = new CinestarEntitiesDAL(); ShowSeatLayout seatLayout = new ShowSeatLayout(); seatLayout.LayoutId = layout.LayoutId; seatLayout.ShowId = layout.ShowId; seatLayout.UnavailableSeats = layout.UnavailableSeats; cinestar.Entry(seatLayout).State = EntityState.Modified; int rowsaffected = cinestar.SaveChanges(); if (rowsaffected > 0) { return(true); } else { return(false); } }
public bool AddGenreDAL(GenreEntity newGenre) { try { bool isAdded = false; var ObjContext = new CinestarEntitiesDAL(); var objGenre = new Genre(); objGenre.GenreId = newGenre.GenreId; objGenre.GenreName = newGenre.GenreName; ObjContext.Genres.Add(objGenre); int NoOfrowsAffected = ObjContext.SaveChanges(); if (NoOfrowsAffected > 0) { isAdded = true; } return(isAdded); } catch (Exception Ex) { return(false); } }