public PersonShow(PERSONS person) { this.person = person; MOVIEADVISOREntities6 entities = new MOVIEADVISOREntities6(); List <PICTURES_PERSONS> tempPicId = entities.PICTURES_PERSONS.Where(pp => pp.PERSON_ID == person.ID).ToList(); picturesList = new List <PICTURES>(); foreach (var pic in tempPicId) { if (!pic.IS_POSTER) { picturesList.Add(entities.PICTURES.Where(p => p.ID == pic.PICTURE_ID).First()); } else { poster = entities.PICTURES.Where(p => p.ID == pic.PICTURE_ID).First().PATH; posterId = entities.PICTURES.Where(p => p.ID == pic.PICTURE_ID).First().ID; altPoster = entities.PICTURES.Where(p => p.ID == pic.PICTURE_ID).First().TITLE; } } List <MOVIES_PERSONS_ROLES> tempMovieId = entities.MOVIES_PERSONS_ROLES.Where(pmr => pmr.PERSON_ID == person.ID).ToList(); moviesList = new List <Movie>(); foreach (var movie in tempMovieId) { moviesList.Add(new Movie(entities.MOVIES.Where(m => m.ID == movie.MOVIE_ID).First())); moviesList.Last().SetRole(person); } comments = entities.PERSONS_COMMENTS.Where(pc => pc.PERSON_ID == person.ID).ToList(); }
public PersonShow() { person = new PERSONS(); person.NAME = " "; picturesList = new List <PICTURES>(); moviesList = new List <Movie>(); poster = ""; altPoster = ""; posterId = -1; comments = new List <PERSONS_COMMENTS>(); }
public void SetRole(PERSONS person) { MOVIEADVISOREntities6 entities = new MOVIEADVISOREntities6(); roles = new List <ROLES>(); List <MOVIES_PERSONS_ROLES> tempRoles = entities.MOVIES_PERSONS_ROLES. Where(mpr => mpr.MOVIE_ID == movie.ID && mpr.PERSON_ID == person.ID).ToList(); foreach (var role in tempRoles) { roles.Add(entities.ROLES.Where(r => r.ID == role.ROLE_ID).First()); } }
public Person(PERSONS person) { this.person = person; MOVIEADVISOREntities6 entities = new MOVIEADVISOREntities6(); List <PICTURES_PERSONS> tempPicturesHolder = entities.PICTURES_PERSONS.Where(pp => pp.PERSON_ID == person.ID && pp.IS_POSTER == true).ToList(); if (tempPicturesHolder.Count > 0) { int tempPicId = tempPicturesHolder.First().PICTURE_ID; picture = entities.PICTURES.Where(p => p.ID == tempPicId).First(); } else { picture = entities.PICTURES.Where(p => p.ID == 9).First(); } }
public PersonsListItem(PERSONS person) { MOVIEADVISOREntities6 entities = new MOVIEADVISOREntities6(); int tempPosterId = entities.PICTURES_PERSONS.Where(pp => pp.PERSON_ID == person.ID && pp.IS_POSTER == true).FirstOrDefault().PICTURE_ID; if (tempPosterId > 0) { poster = entities.PICTURES.Where(p => p.ID == tempPosterId).First().PATH; alt = entities.PICTURES.Where(p => p.ID == tempPosterId).First().TITLE; } else { poster = entities.PICTURES.Where(p => p.ID == 9).First().PATH; alt = entities.PICTURES.Where(p => p.ID == 9).First().TITLE; } this.person = person; }
public void RemovePerson(PERSONS person) { MOVIEADVISOREntities6 entities1 = new MOVIEADVISOREntities6(); int tempId = person.ID; foreach (var pm in entities1.PICTURES_PERSONS.Where(p => p.PERSON_ID == person.ID)) { entities1.PICTURES_PERSONS.DeleteObject(pm); } foreach (var mpr in entities1.MOVIES_PERSONS_ROLES.Where(p => p.PERSON_ID == person.ID)) { entities1.MOVIES_PERSONS_ROLES.DeleteObject(mpr); } foreach (var mpr in entities1.PERSONS_COMMENTS.Where(p => p.PERSON_ID == person.ID)) { entities1.PERSONS_COMMENTS.DeleteObject(mpr); } entities1.PERSONS.DeleteObject(entities1.PERSONS.Where(m => m.ID == tempId).First()); entities1.SaveChanges(); }
public PersonShow update(PersonShow model, string action, HttpPostedFileBase foto, HttpPostedFileBase poster, HttpServerUtilityBase Server, string movie, string role) { MOVIEADVISOREntities6 entities = new MOVIEADVISOREntities6(); PersonShow result = new PersonShow(); result.person.ID = model.person.ID; result.person = model.person; result.picturesList = new List <PICTURES>(); foreach (var pic in model.picturesList) { result.picturesList.Add(entities.PICTURES.Where(p => p.ID == pic.ID).First()); } result.moviesList = new List <Movie>(); foreach (var per in model.moviesList) { result.moviesList.Add(new Movie(entities.MOVIES.Where(p => p.ID == per.movie.ID).First())); result.moviesList.Last().roles = new List <ROLES>(); result.moviesList.Last().roles.Add(per.roles[0]); } result.poster = model.poster; result.posterId = model.posterId; result.altPoster = model.altPoster; result.comments = new List <PERSONS_COMMENTS>(); if (action == "Добавить фильм") { int idHolder = Int32.Parse(movie); int roleHolder = Int32.Parse(role); result.moviesList.Add(new Movie(entities.MOVIES.Where(p => p.ID == idHolder).First())); result.moviesList.Last().roles = new List <ROLES>(); result.moviesList.Last().roles.Add(entities.ROLES.Where(r => r.ID == roleHolder).First()); } else if (action == "Загрузить фото") { int id = this.uploadPic(foto, Server); if (id > -1) { result.picturesList.Add(entities.PICTURES.OrderByDescending(p => p.ID).First()); } } else if (action == "Загрузить постер") { int id = uploadPic(poster, Server); if (id > -1) { result.poster = entities.PICTURES.OrderByDescending(p => p.ID).First().PATH; result.posterId = entities.PICTURES.OrderByDescending(p => p.ID).First().ID; } } else if (action == "Сохранить") { PERSONS tempPersons = new PERSONS(); tempPersons.DESCRIPTION = result.person.DESCRIPTION; tempPersons.NAME = result.person.NAME; if (result.person.ID > 0) { tempPersons.ID = result.person.ID; RemovePerson(tempPersons); } else { tempPersons.ID = entities.PERSONS.OrderByDescending(m => m.ID).First().ID + 1; } foreach (var per in result.moviesList) { MOVIES_PERSONS_ROLES tempMPR = new MOVIES_PERSONS_ROLES(); tempMPR.MOVIE_ID = per.movie.ID; tempMPR.PERSON_ID = result.person.ID; tempMPR.ROLE_ID = per.roles.First().ID; tempPersons.MOVIES_PERSONS_ROLES.Add(tempMPR); } foreach (var photo in result.picturesList) { PICTURES_PERSONS tempPM = new PICTURES_PERSONS(); tempPM.PERSON_ID = result.person.ID; tempPM.PICTURE_ID = photo.ID; tempPM.IS_POSTER = false; tempPersons.PICTURES_PERSONS.Add(tempPM); } if (model.posterId > 0) { PICTURES_PERSONS tempPoster = new PICTURES_PERSONS(); tempPoster.PERSON_ID = model.person.ID; tempPoster.PICTURE_ID = model.posterId; tempPoster.IS_POSTER = true; tempPersons.PICTURES_PERSONS.Add(tempPoster); } entities.PERSONS.AddObject(tempPersons); try { entities.SaveChanges(); } catch { } } else if (action.IndexOf("УдалитьФото") > -1) { int tempId = Int32.Parse(action.Substring(11, action.Length - 11)); result.picturesList.Remove(result.picturesList.Where(p => p.ID == tempId).First()); } else if (action.IndexOf("Удалить") > -1) { int tempId = Int32.Parse(action.Substring(7, action.Length - 7)); result.moviesList.Remove(result.moviesList.Where(p => p.movie.ID == tempId).First()); } return(result); }