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());
}
