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));
}
