Пример #1
0
 public Movie GetMovieId(int id) //Get Id of the movie from the database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         return(onlineMovieTicketDBContext.MovieDetails.Find(id));
     }
 }
Пример #2
0
 public IEnumerable <Category> CategoryDetails()   //Fetch Category from Database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         return(onlineMovieTicketDBContext.Categories.ToList());;
     }
 }
 public Account CheckUser(Account account) //Check existing user.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         var usr = onlineMovieTicketDBContext.AccountDetails.Where(model => model.Email == account.Email && model.Password == account.Password).FirstOrDefault();
         return(usr);
     }
 }
 public void AddUser(Account account) //Add user to Database
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         onlineMovieTicketDBContext.AccountDetails.Add(account);
         onlineMovieTicketDBContext.SaveChanges(); // Update the database
     }
 }
Пример #5
0
 public void AddCategory(Category category)   //Add Category .
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         onlineMovieTicketDBContext.Categories.Add(category);
         onlineMovieTicketDBContext.SaveChanges();
     }
 }
Пример #6
0
 public void UpdateMovie(Movie movie) //Update the movie details to the database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         onlineMovieTicketDBContext.Entry(movie).State = EntityState.Modified;
         onlineMovieTicketDBContext.SaveChanges();
     }
 }
Пример #7
0
 public void AddMovie(Movie movie) //Add movies to Database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         onlineMovieTicketDBContext.MovieDetails.Add(movie);
         onlineMovieTicketDBContext.SaveChanges();
     }
 }
Пример #8
0
 public IEnumerable <Movie> GetAllMovies() //Get all movies from Database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         IEnumerable <Movie> movie = onlineMovieTicketDBContext.MovieDetails.Include("Category").ToList();
         return(movie);
     }
 }
Пример #9
0
 public void DeleteMovie(int movieId) //Delete movie from the database.
 {
     using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext())
     {
         Movie movie = onlineMovieTicketDBContext.MovieDetails.Find(movieId);
         onlineMovieTicketDBContext.MovieDetails.Remove(movie);
         onlineMovieTicketDBContext.SaveChanges();
     }
 }