private ICollection <Movies> GetMoviesByName(string directorName) { var context = new IMDBContext(); var director = context.Directors.Single(d => d.FIO == directorName); return(director.Movies); }
private Guid GetDirectorIdByName(string directorName) { var context = new IMDBContext(); var rec = context.Directors.FirstOrDefault(d => d.FIO == directorName); if (rec != null) { return(rec.Id); } return(Guid.Empty); }
private void AddFilmInSQLCollenction(Film film) { using (IMDBContext context = new IMDBContext()) { Guid dirId = GetDirectorIdByName(film.Director); if (dirId != Guid.Empty) { context.Directors.Single(d => d.FIO == film.Director) .Movies.Add(new Movies { Id = Guid.NewGuid(), Title = film.Title, Rating = film.Rating, DirectorId = dirId, Description = film.Description, Poster = film.Poster }); } else { Guid newId = Guid.NewGuid(); context.Directors.Add(new Director { Id = newId, FIO = film.Director }); context.Movies1.Add(new Movies { Id = Guid.NewGuid(), Title = film.Title, Rating = film.Rating, DirectorId = newId, Description = film.Description, Poster = film.Poster }); } context.SaveChanges(); } }
private List <Director> GetDirectors() { var context = new IMDBContext(); return(context.Directors.ToList()); }