public ActionResult Create([Bind(Include = "idLibro,Titulo,Autor,ISBN,Fecha_publicacion,Numero_de_Ejemplares,idCategoria")] tbl_Libro tbl_Libro)
{
if (ModelState.IsValid)
{
db.tbl_Libro.Add(tbl_Libro);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idCategoria = new SelectList(db.tblCategoria, "idCategoria", "nombre", tbl_Libro.idCategoria);
return(View(tbl_Libro));
}
public ActionResult Create([Bind(Include = "idVideo,titulo,fecha_publicacion,duracion_minutos,idCategoria")] tbl_Video tbl_Video)
{
if (ModelState.IsValid)
{
db.tbl_Video.Add(tbl_Video);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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;
}
}
}
}
