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