public static void Create(DetallePedido p)
{
using (DeliveryJWEntities db = new DeliveryJWEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.DetallePedido.Add(p);
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public static void Delete(int?id)
{
using (DeliveryJWEntities db = new DeliveryJWEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
DetallePedido p = db.DetallePedido.Find(id);
db.Entry(p).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(DetallePedido p)
{
using (DeliveryJWEntities db = new DeliveryJWEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.DetallePedido.Attach(p);
db.Entry(p).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static List <DetallePedido> List()
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.DetallePedido.ToList());
}
public static DetallePedido Get(int?id)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.DetallePedido.Find(id));
}
public static CabeceraPedido Get(int?id)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.CabeceraPedido.Find(id));
}
public static List <CabeceraPedido> List()
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.CabeceraPedido.ToList());
}
public static List <Banco> List()
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Banco.ToList());
}
public static List <Banco> List(string criterio)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Banco.Where(x => x.numero_Cuenta.Contains(criterio)).ToList());
}
public static List <Usuario> List(string criterio)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Usuario.Where(x => x.cedula.Contains(criterio)).ToList());
}
public static Banco Get(int?id)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Banco.Find(id));
}
public static List <Usuario> List()
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Usuario.ToList());
}
public static Usuario Get(int?id)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Usuario.Find(id));
}
public static List <Juego> List(string criterio)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Juego.Where(x => x.estado.Contains(criterio)).ToList());
}
public static List <Juego> List()
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Juego.ToList());
}
public static Juego Get(int?id)
{
DeliveryJWEntities db = new DeliveryJWEntities();
return(db.Juego.Find(id));
}
