public ActionResult DeleteConfirmed(int id) { videoproducer videoproducer = db.videoproducer.Find(id); db.videoproducer.Remove(videoproducer); db.SaveChanges(); return(RedirectToAction("Index")); }
public EmptyResult AddNewVideo() { video video = new video(); int video_id = (from m in db.video select m.video_id).ToList().Last() + 1; video.video_id = video_id; video.video_name = Request["name"]; video.video_year = Int32.Parse(Request["year"]); video.video_description = Request["description"]; video.video_price_per_day = Double.Parse(Request["price"]); video.video_country = Request["country"]; video.video_quantity = Int32.Parse(Request["quantity"]); db.video.Add(video); db.SaveChanges(); string [] genre = Request["genre"].Split(','); int videoGenreId = (from m in db.videogenre select m.videogenre_id).ToList().Last(); for (int i = 0; i < genre.Length; i++) { videogenre videoGenre = new videogenre(); videoGenre.videogenre_id = ++videoGenreId; videoGenre.videogenre_id_video = video_id; videoGenre.videogenre_id_genre = Int32.Parse(genre[i]); db.videogenre.Add(videoGenre); db.SaveChanges(); } string producer = Request["producer"]; producer findProducer = db.producer.FirstOrDefault(p => p.producer_name == producer); videoproducer vp = new videoproducer(); vp.videoproducer_id = (from m in db.videoproducer select m.videoproducer_id).ToList().Last() + 1; vp.videoproducer_id_video = video_id; if (findProducer == null) { producer pr = new producer(); int id = (from m in db.producer select m.producer_id).ToList().Last() + 1; pr.producer_id = id; pr.producer_name = producer; db.producer.Add(pr); db.SaveChanges(); vp.videoproducer_id_producer = id; } else { vp.videoproducer_id_producer = findProducer.producer_id; } db.videoproducer.Add(vp); db.SaveChanges(); return(new EmptyResult()); }
public ActionResult Edit([Bind(Include = "videoproducer_id,videoproducer_id_producer,videoproducer_id_video")] videoproducer videoproducer) { if (ModelState.IsValid) { db.Entry(videoproducer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.videoproducer_id_producer = new SelectList(db.producer, "producer_id", "producer_name", videoproducer.videoproducer_id_producer); ViewBag.videoproducer_id_video = new SelectList(db.video, "video_id", "video_name", videoproducer.videoproducer_id_video); return(View(videoproducer)); }
// GET: videoproducers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } videoproducer videoproducer = db.videoproducer.Find(id); if (videoproducer == null) { return(HttpNotFound()); } return(View(videoproducer)); }
// GET: videoproducers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } videoproducer videoproducer = db.videoproducer.Find(id); if (videoproducer == null) { return(HttpNotFound()); } ViewBag.videoproducer_id_producer = new SelectList(db.producer, "producer_id", "producer_name", videoproducer.videoproducer_id_producer); ViewBag.videoproducer_id_video = new SelectList(db.video, "video_id", "video_name", videoproducer.videoproducer_id_video); return(View(videoproducer)); }