public ActionResult DeleteConfirmed(int id)
{
FilmTable movie = db.FilmTables.Find(id);
//deleting database record here
db.FilmTables.Remove(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id, Title, Release_Date, Genre, Price, Rating")] FilmTable movie)
{
if (ModelState.IsValid)
{
//adding database record here
db.FilmTables.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Edit([Bind(Include = "Id, Title, Release_Date, Genre, Price, Rating")] FilmTable movie)
{
if (ModelState.IsValid)
{
//Editing database record here
db.Entry(movie).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
private void FilmTable_MouseClick(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
int mouseOverRow = FilmTable.HitTest(e.X, e.Y).RowIndex;
if (mouseOverRow >= 0)
{
rightClickMenu.MenuItems[0].Text = string.Format("Delete "
+ FilmTable.Rows[mouseOverRow].Cells["TITLE"].Value
+ " (" + FilmTable.Rows[mouseOverRow].Cells["YEAR"].Value + ") ID : "
+ FilmTable.Rows[mouseOverRow].Cells["ID"].Value, mouseOverRow.ToString());
}
rightClickMenu.Show(FilmTable, new Point(e.X, e.Y));
}
}
//Edit View
public ActionResult Edit(int?id)
{
FilmTable movie = db.FilmTables.Find(id);
return(View(movie));
}
