public ActionResult RemoveFromFavourites(int adId) { using (HangerDatabase DataContext = new HangerDatabase()) { int user = (Session["LogedUserID"] as User).Id; var fav = (from s in DataContext.Favourite where (s.UserId == user) && (s.AdId == adId) select s).FirstOrDefault(); DataContext.Favourite.Remove(fav); DataContext.SaveChanges(); ViewBag.isInFavourites = false; } var ad = from s in db.Ad select s; //ViewBag.AddCount = ad.Count(); ViewBag.index = ad.ToList().FindIndex(a => a.Id == adId); ViewBag.ad = adId; Ad advertisement = db.Ad.Find(adId); return(PartialView("AdToFavorites", ad.ToList())); }
public ActionResult AddToFavourites(int adId) { using (HangerDatabase db = new HangerDatabase()) { Favourite f = new Favourite(); f.Date_start = DateTime.Now; f.UserId = (Session["LogedUserID"] as User).Id; if (db.Favourite != null && db.Favourite.Count() != 0) { f.Id = (from ph in db.Favourite select ph.Id).Max() + 1; } else { f.Id = 0; } // p.OwnerId = (Session["CurrentUserEmail"] as User).UserId; f.AdId = adId; db.Favourite.Add(f); db.SaveChanges(); ViewBag.isInFavourites = true; //return Json(f, JsonRequestBehavior.AllowGet); } //return RedirectToAction("New", "Home"); //return RedirectToAction("Product", "Ad", new { id = adId }); var ad = from s in db.Ad select s; ViewBag.index = ad.ToList().FindIndex(a => a.Id == adId); return(PartialView("AdToFavorites", ad.ToList())); }
public ActionResult AddPhoto(int adId) { HttpPostedFileBase file = Request.Files[0]; byte[] imageSize = new byte[file.ContentLength]; file.InputStream.Read(imageSize, 0, (int)file.ContentLength); using (HangerDatabase db = new HangerDatabase()) { Photos p = new Photos(); p.Photo = imageSize; p.FIle_name = file.FileName; if (db.Photos != null && db.Photos.Count() != 0) { p.Id = (from ph in db.Photos select ph.Id).Max() + 1; } else { p.Id = 0; } // p.OwnerId = (Session["CurrentUserEmail"] as User).UserId; p.AdId = adId; p.Type = file.ContentType; p.Main_photo = false; db.Photos.Add(p); db.SaveChanges(); } //return RedirectToAction("New", "Home"); return(RedirectToAction("Photo1", "Ad", new { id = adId })); }
public ActionResult DeletePhoto(int id, int adId) { using (HangerDatabase DataContext = new HangerDatabase()) { var photoToDelete = (from p in DataContext.Photos where p.Id == id select p).FirstOrDefault(); DataContext.Photos.Remove(photoToDelete); DataContext.SaveChanges(); } return(RedirectToAction("Photo1", "Ad", new { id = adId })); }
public ActionResult Delete(int adId) { using (HangerDatabase DataContext = new HangerDatabase()) { var photoToDelete = (from p in DataContext.Photos where p.AdId == adId select p); while (photoToDelete.Count() > 0) { DataContext.Photos.Remove(photoToDelete.FirstOrDefault()); DataContext.SaveChanges(); } var ad = (from p in DataContext.Ad where p.Id == adId select p).FirstOrDefault(); DataContext.Ad.Remove(ad); DataContext.SaveChanges(); } return(RedirectToAction("UserProfil", "UserProfil", new { id = (Session["LogedUserID"] as Hanger.Models.User).Id })); }
public ActionResult IsSold(int adId) { using (HangerDatabase db = new HangerDatabase()) { Ad A = db.Ad.Find(adId); if (ModelState.IsValid) { A.Is_sold = true; A.Date_end = DateTime.Now; db.Entry(A).State = EntityState.Modified; try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; } } } //return RedirectToAction("New", "Home"); return(RedirectToAction("Product", "Ad", new { id = adId })); }