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