public ActionResult Edit(PosterCreate posterEditView) { if (ModelState.IsValid) { Poster posterNew = posterEditView.Poster; int posterID = posterEditView.Poster.PosterID; var PostersCategoriesList = _context.PostersCategories.Where(cc => cc.PosterID == posterID).ToList(); foreach (var PosterCategory in PostersCategoriesList) { _context.PostersCategories.Remove(PosterCategory); _context.SaveChanges(); _context.Categories.Where(x => x.CategoryID == PosterCategory.CategoryID) .FirstOrDefault().PostersCategories.Remove(PosterCategory); } posterNew.PostersCategories = new List <PosterCategory>(); foreach (var categoryID in posterEditView.CategoriesID) { PosterCategory pc = new PosterCategory { CategoryID = categoryID, PosterID = posterID }; _context.PostersCategories.Add(pc); _context.SaveChanges(); posterNew.PostersCategories.Add(pc); _context.Categories.Where(x => x.CategoryID == categoryID).FirstOrDefault().PostersCategories.Add(pc); } _context.Entry(posterNew).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } return(View(posterEditView)); }
public ActionResult Create(PosterCreate posterCreate) { if (ModelState.IsValid) { string UserID = HttpContext.User.Identity.GetUserId(); Poster posterNew = new Poster { AddingDate = DateTime.Now, Title = posterCreate.Poster.Title, Price = posterCreate.Poster.Price, Views = 0, IsActive = posterCreate.Poster.IsActive, IsValuable = posterCreate.Poster.IsValuable, Content = posterCreate.Poster.Content, References = posterCreate.Poster.References, OwnerID = UserID }; _context.Posters.Add(posterNew); _context.SaveChanges(); UserPoster up = new UserPoster { ApplicationUserID = UserID, PosterID = posterNew.PosterID }; _context.UsersPosters.Add(up); _context.SaveChanges(); _context.Users.Where(x => x.Id == UserID).FirstOrDefault().UserPoster.Add(up); foreach (int categoryID in posterCreate.CategoriesID) { PosterCategory pc = new PosterCategory { CategoryID = categoryID, PosterID = posterNew.PosterID }; _context.PostersCategories.Add(pc); _context.SaveChanges(); posterNew.PostersCategories.Add(pc); _context.Categories.Where(x => x.CategoryID == categoryID).FirstOrDefault().PostersCategories.Add(pc); } _context.SaveChanges(); return(RedirectToAction("Index")); } return(View(posterCreate)); }
public List <PosterItem> GetAllPosters() { List <PosterItem> list = new List <PosterItem>(); PosterItem _test = new PosterItem(); #region Poster 1 _test.posterName = "Communication is a Two-Way Street"; _test.fileName = "communication_two_way"; _test.Id = 1; _test.imageName = "img1"; IPosterCategory ipc = new PosterCategory(); List <IPosterCategory> ipc_list = new List <IPosterCategory>(); ipc.Id = 1; ipc.posterCategoryName = "E-Commerce"; ipc_list.Add(ipc); ipc = new PosterCategory(); ipc.Id = 2; ipc.posterCategoryName = "MANUFACTURING"; ipc_list.Add(ipc); _test.posterCategoryNames = ipc_list; IPosterMessage ipm = new PosterMessage(); ipm.Id = 1; ipm.posterMessageName = "COMPANY CULTURE"; _test.posterMessage = ipm; list.Add(_test); #endregion #region Poster 2 _test = new PosterItem(); _test.posterName = "How solid is your integrity?"; _test.fileName = "how_solid_integrity?"; _test.Id = 2; _test.imageName = "img2"; ipc_list = new List <IPosterCategory>(); ipc = new PosterCategory(); ipc.Id = 3; ipc.posterCategoryName = "AVIATION"; ipc_list.Add(ipc); ipc = new PosterCategory(); ipc.Id = 2; ipc.posterCategoryName = "MANUFACTURING"; ipc_list.Add(ipc); _test.posterCategoryNames = ipc_list; ipm = new PosterMessage(); ipm.Id = 2; ipm.posterMessageName = "CUSTOMER SUPPORT"; _test.posterMessage = ipm; list.Add(_test); #endregion #region Poster 3 _test = new PosterItem(); _test.posterName = "When the right thing to do isn’t clear… Focus on integrity"; _test.fileName = "focus_on_integrity"; _test.Id = 3; _test.imageName = "img3"; ipc_list = new List <IPosterCategory>(); ipc = new PosterCategory(); ipc.Id = 4; ipc.posterCategoryName = "HOSPITAL AND FOOD"; ipc_list.Add(ipc); ipc = new PosterCategory(); ipc.Id = 5; ipc.posterCategoryName = "HEALTHCARE"; ipc_list.Add(ipc); _test.posterCategoryNames = ipc_list; ipm = new PosterMessage(); ipm.Id = 2; ipm.posterMessageName = "CUSTOMER SUPPORT"; _test.posterMessage = ipm; list.Add(_test); #endregion #region Poster 4 _test = new PosterItem(); _test.posterName = "When the right thing to do isn’t clear… Focus on integrity"; _test.fileName = "focus_on_integrity2"; _test.Id = 4; _test.imageName = "img4"; ipc_list = new List <IPosterCategory>(); ipc = new PosterCategory(); ipc.Id = 5; ipc.posterCategoryName = "HEALTHCARE"; ipc_list.Add(ipc); _test.posterCategoryNames = ipc_list; ipm = new PosterMessage(); ipm.Id = 1; ipm.posterMessageName = "COMPANY CULTURE"; _test.posterMessage = ipm; list.Add(_test); #endregion return(list); }