public static void Create(Libro a) { using (DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Libroes.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 { Libro libro = db.Libroes.Find(id); db.Entry(libro).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(Libro libro) { using (DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Libroes.Attach(libro); db.Entry(libro).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
private static Libro GetLibro(string titulo) { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Libroes.FirstOrDefault(x => x.titulo == titulo)); }
//----------------------------------------------------------------------------------------------------------- private static List <Libro> GetLibros(string criterio) { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Libroes.Where(x => x.titulo.ToLower().Contains(criterio)).ToList()); }
public static List <Libro> List() { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Libroes.ToList()); }
public static Libro Get(int?id) { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Libroes.Find(id)); }
private static Video GetVideo(string titulo) { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Videos.FirstOrDefault(x => x.titulo == titulo)); }
public static List <Video> List() { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Videos.ToList()); }
public static Video Get(int?id) { DBBIBLIOTECAEntities db = new DBBIBLIOTECAEntities(); return(db.Videos.Find(id)); }