public List <Show> GitShowsByMovieId(int MovieId) { _Db = new EGMoviesWorkshopDB(); Movie movie = new Movie(); movie = _Db.Movies.FirstOrDefault(m => m.Id == MovieId); return(movie.Shows.ToList()); }
public int AddNew(CinemaGroup obj) { _Db = new EGMoviesWorkshopDB(); _Db.CinemaGroups.Add(obj); _Db.Entry(obj).State = System.Data.Entity.EntityState.Added; _Db.SaveChanges(); return(obj.Id); }
public List <string> GitGenres() { _Db = new EGMoviesWorkshopDB(); var GenreList = new List <string>(); var Quary = from gen in _Db.Movies orderby gen.Genre select gen.Genre; GenreList.AddRange(Quary.Distinct()); return(GenreList); }
public List <string> GitAreas() { _Db = new EGMoviesWorkshopDB(); var AreasList = new List <string>(); var Quary = from ara in _Db.CinemaGroups orderby ara.Area select ara.Area; AreasList.AddRange(Quary.Distinct()); return(AreasList); }
public List <Cinema> GitCinemasByMovieId(int MovieId) { _Db = new EGMoviesWorkshopDB(); Movie movie = new Movie(); movie = _Db.Movies.FirstOrDefault(m => m.Id == MovieId); var q = from c in movie.Shows.Where(s => s.MovieId == MovieId) select c.Cinema; return(q.Distinct().ToList()); }
public List <Movie> SearchByMovieName(String MovieName) { _Db = new EGMoviesWorkshopDB(); //if (string.IsNullOrEmpty(MovieName)) //{ // return _Db.Movies.ToList(); //} //else //{ return(_Db.Movies.Where(mov => mov.Name.Contains(MovieName)).ToList()); //} }
public bool GitIDByName(string MovieName, out int ID) { _Db = new EGMoviesWorkshopDB(); Movie intMovie = new Movie(); intMovie = _Db.Movies.FirstOrDefault(mov => mov.Name.Equals(MovieName)); if (intMovie != null) { ID = intMovie.Id; return(true); } else { ID = 0; return(false); } }
public List <Cinema> GitCinemasByAreaName(string areaName) { _Db = new EGMoviesWorkshopDB(); return(_Db.CinemaGroups.FirstOrDefault(cg => cg.Area == areaName).Cinemas.ToList()); }
public ActorRepository() { _Db = new EGMoviesWorkshopDB(); _obj = new Actor(); }
public Cinema GitCinemaByCinemaId(int CinemaId) { _Db = new EGMoviesWorkshopDB(); return(_Db.Cinemas.FirstOrDefault(c => c.Id == CinemaId)); }
public List <Show> GitShowsByCinemaId(int cinemaId) { _Db = new EGMoviesWorkshopDB(); return(_Db.Shows.Where(s => s.CinemaId == cinemaId).ToList()); }
public List <Cinema> GitAll() { _Db = new EGMoviesWorkshopDB(); return(_Db.Cinemas.ToList()); }
public List <Cinema> GitCinemasByCinemaGroup(int CinemaGroupId) { _Db = new EGMoviesWorkshopDB(); return(_Db.Cinemas.Where(c => c.CinemaGroupId == CinemaGroupId).ToList()); }
public Movie GitMovieByMovieId(int MovieId) { _Db = new EGMoviesWorkshopDB(); return(_Db.Movies.SingleOrDefault(mov => mov.Id == (MovieId))); }
public CinemaRepository() { _Db = new EGMoviesWorkshopDB(); _obj = new Cinema(); }
public List <Show> GitAll() { _Db = new EGMoviesWorkshopDB(); return(_Db.Shows.ToList()); }
public ShowRepository() { _Db = new EGMoviesWorkshopDB(); _obj = new Show(); }
public Actor FindActorByName(string ActorName) { _Db = new EGMoviesWorkshopDB(); return(_Db.Actors.FirstOrDefault(actr => actr.Name.Equals(ActorName))); }
public Movie FindMovieByName(string MovieName) { _Db = new EGMoviesWorkshopDB(); return(_Db.Movies.FirstOrDefault(mov => mov.Name.Equals(MovieName))); }
public MovieRepository() { _Db = new EGMoviesWorkshopDB(); _obj = new Movie(); }
public List <Movie> GitMoviesByGenre(string Genrename) { _Db = new EGMoviesWorkshopDB(); return(_Db.Movies.Where(mov => mov.Genre.Contains(Genrename)).ToList()); }
public Movie GitMovieByCinemaId(int CinemaId) { _Db = new EGMoviesWorkshopDB(); return(_Db.Shows.FirstOrDefault(sh => sh.CinemaId == CinemaId).Movie); }
public List <Actor> GitAll() { _Db = new EGMoviesWorkshopDB(); return(_Db.Actors.ToList()); }
public List <Movie> GitAll() { _Db = new EGMoviesWorkshopDB(); return(_Db.Movies.ToList()); }