public static void Create(Usuario a)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
a.uso_rol = "Cliente";
db.Usuario.Add(a);
db.SaveChanges();
transaction.Commit();
Usuario u = GetUsuarioByUsu(a.uso_usu);
Cliente c = new Cliente();
c.uso_id = u.uso_id;
ClienteBLL.Create(c);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Create(CuerpoFactura a)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.CuerpoFactura.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
{
CuerpoFactura CuerpoFactura = db.CuerpoFactura.Find(id);
db.Entry(CuerpoFactura).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(CuerpoFactura CuerpoFactura)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.CuerpoFactura.Attach(CuerpoFactura);
db.Entry(CuerpoFactura).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(ProductoEnCarrito ProductoEnCarrito)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.ProductoEnCarrito.Attach(ProductoEnCarrito);
db.Entry(ProductoEnCarrito).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Create(Producto a)
{
using (emmcomerseEntities db = new emmcomerseEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
a.prd_dateOfCreated = DateTime.Now;
db.Producto.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(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 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;
}
}
}
}