public Movie GetMovieId(int id) //Get Id of the movie from the database. { using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext()) { return(onlineMovieTicketDBContext.MovieDetails.Find(id)); } }
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 } }
public void AddCategory(Category category) //Add Category . { using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext()) { onlineMovieTicketDBContext.Categories.Add(category); onlineMovieTicketDBContext.SaveChanges(); } }
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(); } }
public void AddMovie(Movie movie) //Add movies to Database. { using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext()) { onlineMovieTicketDBContext.MovieDetails.Add(movie); onlineMovieTicketDBContext.SaveChanges(); } }
public IEnumerable <Movie> GetAllMovies() //Get all movies from Database. { using (OnlineMovieTicketDBContext onlineMovieTicketDBContext = new OnlineMovieTicketDBContext()) { IEnumerable <Movie> movie = onlineMovieTicketDBContext.MovieDetails.Include("Category").ToList(); return(movie); } }
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(); } }