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)); }