public ActionResult DeleteConfirmed(int id) { tbl_Video tbl_Video = db.tbl_Video.Find(id); db.tbl_Video.Remove(tbl_Video); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "idVideo,titulo,fecha_publicacion,duracion_minutos,idCategoria")] tbl_Video tbl_Video) { if (ModelState.IsValid) { db.Entry(tbl_Video).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idCategoria = new SelectList(db.tblCategoria, "idCategoria", "nombre", tbl_Video.idCategoria); return(View(tbl_Video)); }
// GET: tbl_Video/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Video tbl_Video = db.tbl_Video.Find(id); if (tbl_Video == null) { return(HttpNotFound()); } return(View(tbl_Video)); }
// GET: tbl_Video/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Video tbl_Video = db.tbl_Video.Find(id); if (tbl_Video == null) { return(HttpNotFound()); } ViewBag.idCategoria = new SelectList(db.tblCategoria, "idCategoria", "nombre", tbl_Video.idCategoria); return(View(tbl_Video)); }
public static void Create(tbl_Video a) { using (dbBibliotecaEntities db = new dbBibliotecaEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.tbl_Video.Add(a); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (dbBibliotecaEntities db = new dbBibliotecaEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { tbl_Video tbl_Video = db.tbl_Video.Find(id); db.Entry(tbl_Video).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(tbl_Video tbl_Video) { using (dbBibliotecaEntities db = new dbBibliotecaEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.tbl_Video.Attach(tbl_Video); db.Entry(tbl_Video).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public bool Update(tbl_Video entity) { try { var obj = db.tbl_Video.Find(entity.Id); obj.Ten_Video = entity.Ten_Video; obj.Id_CaSi = entity.Id_CaSi; obj.LuotXem = entity.LuotXem; obj.Id_TheLoai = entity.Id_TheLoai; obj.Url_Video = entity.Url_Video; obj.Active = entity.Active; obj.Id_ChuDe = entity.Id_ChuDe; obj.Id_NhanVien = entity.Id_NhanVien; obj.NgayDang = entity.NgayDang; obj.urlImage = entity.urlImage; obj.Ord = entity.Ord; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public long Insert(tbl_Video entity) { db.tbl_Video.Add(entity); db.SaveChanges(); return(entity.Id); }