public IActionResult Actors() { if (FilmDataDbContext.LocalActors == null) { FilmDataDbContext.UpdateLists(); } return(View(FilmDataDbContext.LocalActors)); }
public IActionResult Actor(int id) { DbActor actor; using (var db = new FilmDataDbContext()) { actor = db.Actors.Include(s => s.Works).First(x => x.Id == id); List <DbFilm> a = db.Films.Include(x => x.Credits).ToList(); } return(View(actor)); }
public IActionResult Film(int id) { DbFilm film; using (var db = new FilmDataDbContext()) { film = db.Films.Include(s => s.Credits).First(x => x.Id == id); List <DbActor> a = db.Actors.Include(x => x.Works).ToList(); } return(View(film)); }
public ActionResult FilmImage(int id) { byte[] poster; using (var db = new FilmDataDbContext()) { poster = db.Films.Find(id).Poster; } if (poster == null) { return(base.File(Properties.Resources.Nullimg, "image/jpeg")); } return(base.File(poster, "image/jpeg")); }
public ActionResult ActorImage(int id) { byte[] foto; using (var db = new FilmDataDbContext()) { foto = db.Actors.Find(id).Foto; } if (foto == null) { return(base.File(Properties.Resources.Nullimg, "image/jpeg")); } return(base.File(foto, "image/jpeg")); }
public IActionResult DoUpload(IFormFile file) { using (var stream = file.OpenReadStream()) { var xs = new XmlSerializer(typeof(DataXml)); var dataXml = (DataXml)xs.Deserialize(stream); var data = dataXml.ToData(); var dbFilms = data.Films.ToDictionary(x => x.Key, x => new DbFilm(x.Value)); var dbActors = data.Actors.ToDictionary(x => x.Key, x => new DbActor(x.Value)); foreach (var film in data.Films) { foreach (var work in film.Value.Credits) { var dbWork = new DbWork { Position = work.Position, Discription = work.Discription }; dbFilms[work.FilmId].Credits.Add(dbWork); dbActors[work.ActorId].Works.Add(dbWork); } } using (var db = new FilmDataDbContext()) { foreach (var film in dbFilms.Values) { db.Films.Add(film); } foreach (var actor in dbActors.Values) { db.Actors.Add(actor); } db.SaveChanges(); } FilmDataDbContext.UpdateLists(); return(View(dataXml)); } }