public IActionResult AddPictureAlbum(AddPictureAlbumViewModel addPictureAlbumViewModel) { if (ModelState.IsValid) { int albumID = addPictureAlbumViewModel.AlbumID; List <int> pictureIDs = addPictureAlbumViewModel.PictureIDs; foreach (var pictureID in pictureIDs) { PictureXAlbum pictureAlbum = new PictureXAlbum() { PictureID = pictureID, AlbumID = albumID }; context.PictureXAlbums.Add(pictureAlbum); } context.SaveChanges(); return(Redirect(string.Format("/Album/AddPIctureAlbum/{0}", albumID))); } return(View(addPictureAlbumViewModel)); }
public IActionResult AddPictureAlbum(int ID, string locationID = "", string eventID = "", string authorID = "", string people = "", string search = "" ) { var locations = context.Locations.Include(p => p.Place).ToList(); var events = context.Events.Include(p => p.EventType).ToList(); var authors = context.Authors.ToList(); var peopleList = context.PeopleDb.ToList(); List <int> pictureIDs = new List <int>(); int albumID = ID; if (search == "Location") { var queryLocation = provider.SelectAllPictures().Where(p => p.PictureLocationID == locationID).ToList(); AddPictureAlbumViewModel searchView = new AddPictureAlbumViewModel(queryLocation, locations, events, authors, peopleList, pictureIDs, albumID); return(View(searchView)); } if (search == "Event") { var queryEvent = provider.SelectAllPictures().Where(p => p.PictureEventID == eventID).ToList(); AddPictureAlbumViewModel searchView = new AddPictureAlbumViewModel(queryEvent, locations, events, authors, peopleList, pictureIDs, albumID); return(View(searchView)); } if (search == "Author") { var queryAuthor = provider.SelectAllPictures().Where(p => p.PictureAuthorID == authorID).ToList(); AddPictureAlbumViewModel searchView = new AddPictureAlbumViewModel(queryAuthor, locations, events, authors, peopleList, pictureIDs, albumID); return(View(searchView)); } if (search == "People") { var queryAllPicture = provider.SelectAllPictures().ToList(); List <ViewPictureHelper> _queryPeople = new List <ViewPictureHelper>(); foreach (var i in queryAllPicture) { if (i.PicturePeopleIDs is null) { continue; } else { _queryPeople.Add(i); } } var queryPeople = _queryPeople.Where(p => p.PicturePeopleIDs.Contains(people)).ToList(); AddPictureAlbumViewModel searchView = new AddPictureAlbumViewModel(queryPeople, locations, events, authors, peopleList, pictureIDs, albumID); return(View(searchView)); } else { List <ViewPictureHelper> viewPictureHelpers = new List <ViewPictureHelper>(); AddPictureAlbumViewModel searchView = new AddPictureAlbumViewModel(viewPictureHelpers, locations, events, authors, peopleList, pictureIDs, albumID); return(View(searchView)); } }