public static void Update(Usuario usuario) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Usuario.Attach(usuario); db.Entry(usuario).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); } } } }
public static void Create(Carrito a) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Carrito.Add(a); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { Categoria alumno = db.Categoria.Find(id); db.Entry(alumno).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(Categoria Categoria) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Categoria.Attach(Categoria); db.Entry(Categoria).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Create(CuerpoFactura a) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { a.crf_dateOfCreated = DateTime.Now; db.CuerpoFactura.Add(a); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { ProductoEnCarrito ProductoEnCarrito = db.ProductoEnCarrito.Find(id); ProductoBLL.Update(ProductoEnCarrito.prd_id, (-1 * ProductoEnCarrito.pcr_cnt)); db.Entry(ProductoEnCarrito).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Create(Cliente a) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { 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 Update(int prd_id, int cantidad) { using (PortBellyDBEntities db = new PortBellyDBEntities()) { 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; } } } }