public static void Update(CabezaFactura CabezaFactura)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.CabezaFactura.Attach(CabezaFactura);
db.Entry(CabezaFactura).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Delete(int?id)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
CabezaFactura CabezaFactura = db.CabezaFactura.Find(id);
db.Entry(CabezaFactura).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Create(Cliente a)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
a.cln_tipo = "Nuevo";
a.cln_dateOfCreated = DateTime.Now;
db.Cliente.Add(a);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Delete(int?id)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
ProductoEnCarrito ProductoEnCarrito = db.ProductoEnCarrito.Find(id);
db.Entry(ProductoEnCarrito).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
ProductoBLL.Update(ProductoEnCarrito.prd_id, (-1 * ProductoEnCarrito.prd_cnt));
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Create(ProductoEnCarrito a)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
a.pcr_est = "Pendiente";
a.pcr_dateOfCreated = DateTime.Now;
db.ProductoEnCarrito.Add(a);
db.SaveChanges();
transaction.Commit();
ProductoBLL.Update(a.prd_id, a.prd_cnt);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(int prd_id, int?cantidad)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Producto p = db.Producto.Find(prd_id);
p.prd_cnt -= cantidad;
db.Producto.Attach(p);
db.Entry(p).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static Usuario Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Usuario.Find(id));
}
public static List <Producto> GetProdutsByCategory(int cat_id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Producto.Where(x => x.cat_id.Equals(cat_id)).ToList());
}
public static List <Producto> GetProdutsByPromocion(int prm_id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Producto.Where(x => x.prm_id.Equals(prm_id)).ToList());
}
public static List <Pago> List(int cln_id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Pago.Where(x => x.cln_id.Equals(cln_id)).ToList());
}
public static List <Producto> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Producto.Include(p => p.Categoria).Include(p => p.Promocion).ToList());
}
public static Usuario GetUsuarioByUsu(string usu)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Usuario.FirstOrDefault(x => x.uso_usu == usu));
}
public static List <Pago> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Pago.Include(p => p.Cliente).ToList());
}
public static List <Carrito> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Carrito.Include(c => c.Cliente).ToList());
}
public static CuerpoFactura Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.CuerpoFactura.Find(id));
}
public static List <ProductoEnCarrito> List(int car_id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.ProductoEnCarrito.Where(x => x.car_id.Equals(car_id)).ToList());
}
public static List <Usuario> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Usuario.ToList());
}
public static List <Cliente> List(int uso_usu)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Cliente.Where(x => x.uso_id.Equals(uso_usu)).ToList());
}
public static List <Cliente> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Cliente.Include(c => c.Usuario).ToList());
}
public static Cliente Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Cliente.Find(id));
}
public static Categoria Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Categoria.Find(id));
}
public static List <Categoria> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Categoria.ToList());
}
public static List <ProductoEnCarrito> GetProdutsInCarByState(string pcr_est)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.ProductoEnCarrito.Where(x => x.pcr_est.Equals(pcr_est)).ToList());
}
public static List <CabezaFactura> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.CabezaFactura.Include(c => c.Cliente).ToList());
}
public static ProductoEnCarrito Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.ProductoEnCarrito.Find(id));
}
public static List <CabezaFactura> List(int cln_id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.CabezaFactura.Where(x => x.cln_id.Equals(cln_id)).ToList());
}
public static List <ProductoEnCarrito> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.ProductoEnCarrito.Include(p => p.Carrito).Include(p => p.Producto).ToList());
}
public static Pago Get(int?id)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Pago.Find(id));
}
public static List <CuerpoFactura> List()
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.CuerpoFactura.Include(c => c.CabezaFactura).Include(c => c.Carrito).ToList());
}
private static Usuario GetUsuario(string correo)
{
emmcomerseEntities db = new emmcomerseEntities();
return(db.Usuario.FirstOrDefault(x => x.uso_cor == correo));
}
