public static void Delete(int?id) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { Usuario usuario = db.Usuarios.Find(id); var articulos = usuario.Articuloes.Where(t => t.idUsuario == id); Venta venta = db.Ventas.Find(usuario.idUsuario); var ventas = usuario.Ventas.Where(t => t.idUsuario == id); if (articulos != null) { db.Articuloes.RemoveRange(articulos); } if (venta != null) { db.Ventas.RemoveRange(ventas); } db.Entry(usuario).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static string Delete(SegurityViewModel modelo, int id) { if (!UsuarioBLL.Verify(modelo.token))//No autorizado { return "No autorizado"; } using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { Articulo articulo = db.Articuloes.Find(id); if (articulo == null) { return "Articulo no existe"; } db.Entry(articulo).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); return "EliminaciĆ³n correcta"; } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
}//end public static bool LogOut(int?id) { //se crea una instancia o un iniverso dentro de otro universo //esta instancia se termina aqui using (Entities_Bio db = new Entities_Bio()) { try { using (var transaction = db.Database.BeginTransaction()) { Usuario userLogin = db.Usuarios.Find(id); userLogin.token_temp = null; db.Usuarios.Attach(userLogin); db.Entry(userLogin).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); return(true); } } catch (Exception ex) { throw; } } }//end
public static SegurityViewModel Login(string email, string password) { //se crea una instancia o un iniverso dentro de otro universo //esta instancia se termina aqui using (Entities_Bio db = new Entities_Bio()) { SegurityViewModel token = new SegurityViewModel(); try { var lst = db.Usuarios.Where(d => d.email == email && d.contrasena == password); //var lst = db.Usuarios.Where(d => d.email == email && d.contrasena == email && d.estado == "a"); if (lst.Count() > 0) { using (var transaction = db.Database.BeginTransaction()) { Usuario userLogin = lst.First(); if (userLogin.token_temp == null) { userLogin.token_temp = Guid.NewGuid().ToString(); } db.Usuarios.Attach(userLogin); db.Entry(userLogin).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); token.token = userLogin.token_temp; token.id_logueado = userLogin.idUsuario; token.nombre = userLogin.nombres + " " + userLogin.apellidos; //token.pathIMG = userLogin.imgPath; return(token); } } else { return(token); } } catch (Exception ex) { throw; } } }//end
//BLL Bussiness Logic Layer //Capa de Logica del Negocio public static void Create(Articulo a) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Articuloes.Add(a); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(Usuario Usuario) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Usuarios.Attach(Usuario); db.Entry(Usuario).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { Usuario alumno = db.Usuarios.Find(id); db.Entry(alumno).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
//BLL Bussiness Logic Layer //Capa de Logica del Negocio public static void Create(Venta a) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { //DateTime thisDay = DateTime.Today; a.fechaVenta = DateTime.Today; db.Ventas.Add(a); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static bool Update(Articulo articulo) { using (Entities_Bio db = new Entities_Bio()) { using (var transaction = db.Database.BeginTransaction()) { try { db.Articuloes.Attach(articulo); db.Entry(articulo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; //throw ex; } } } }
public static string Add(ArticuloViewModel modelo) { using (Entities_Bio db = new Entities_Bio()) { if (!UsuarioBLL.Verify(modelo.token))//No autorizado { return "No autorizado"; } using (var transaction = db.Database.BeginTransaction()) { try { Articulo a = new Articulo(); a.nombre = modelo.nombre; a.precio = modelo.precio; a.categoria = modelo.categoria; a.detalle = modelo.detalle; a.estado = modelo.estado; a.idUsuario = modelo.idUsuario; a.fecha = modelo.fecha_ingreso; a.imagen = modelo.imagen; db.Articuloes.Add(a); db.SaveChanges(); transaction.Commit(); return "Articulo creado exitosamente"; } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }//end Create