public static List<tbl_Libro> ListToNames() { dbBibliotecaEntities db = new dbBibliotecaEntities(); List<tbl_Libro> result = new List<tbl_Libro>(); db.tbl_Libro.ToList().ForEach(x => result.Add( new tbl_Libro { Titulo = x.Titulo, idLibro = x.idLibro })); return result; }
public static List <tbl_Video> ListToNames() { dbBibliotecaEntities db = new dbBibliotecaEntities(); List <tbl_Video> result = new List <tbl_Video>(); db.tbl_Video.ToList().ForEach(x => result.Add( new tbl_Video { titulo = x.titulo, idVideo = x.idVideo })); return(result); }
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 static List <tbl_Video> List() { dbBibliotecaEntities db = new dbBibliotecaEntities(); return(db.tbl_Video.ToList()); }
public static tbl_Video Get(int?id) { dbBibliotecaEntities db = new dbBibliotecaEntities(); return(db.tbl_Video.Find(id)); }
public static List<tbl_Libro> List() { dbBibliotecaEntities db = new dbBibliotecaEntities(); return db.tbl_Libro.ToList(); }
public static tbl_Libro Get(int? id) { dbBibliotecaEntities db = new dbBibliotecaEntities(); return db.tbl_Libro.Find(id); }
public static List <tblCategoria> List() { dbBibliotecaEntities db = new dbBibliotecaEntities(); return(db.tblCategoria.ToList()); }