public static List <Pelicula> List() { ServicioStreamEntities db = new ServicioStreamEntities(); return(db.Pelicula.ToList()); }
//BLL Bussiness Logic Layer //Capa de Logica del Negocio public static void Create(Pelicula p) { using (ServicioStreamEntities db = new ServicioStreamEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Pelicula.Add(p); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (ServicioStreamEntities db = new ServicioStreamEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { Pelicula pelicula = db.Pelicula.Find(id); db.Entry(pelicula).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(Pelicula pelicula) { using (ServicioStreamEntities db = new ServicioStreamEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Pelicula.Attach(pelicula); db.Entry(pelicula).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
private static List <Pelicula> GetAlumnos(string criterio) { ServicioStreamEntities db = new ServicioStreamEntities(); return(db.Pelicula.Where(x => x.nombre_pelicula.ToLower().Contains(criterio)).ToList()); }
public static Pelicula Get(int?id) { ServicioStreamEntities db = new ServicioStreamEntities(); return(db.Pelicula.Find(id)); }
private static Pelicula GetPelicula(string nombre) { ServicioStreamEntities db = new ServicioStreamEntities(); return(db.Pelicula.FirstOrDefault(x => x.nombre_pelicula == nombre)); }