public IEnumerable <Usuario> GetAll() { try { using (var db = new Connection.SigContext()) { var usuarios = db.Usuarios.ToList(); return(usuarios); } } catch (Exception ex) { return(null); } }
public IEnumerable <Frete> GetAll() { try { using (var db = new Connection.SigContext()) { var fretes = db.Fretes.ToList(); return(fretes); } } catch (Exception ex) { return(null); } }
public IEnumerable <Pedido> GetAll() { try { using (var db = new Connection.SigContext()) { var pedidos = db.Pedidos.ToList(); return(pedidos); } } catch (Exception ex) { return(null); } }
public Frete Add(Frete obj) { try { using (var db = new Connection.SigContext()) { db.Fretes.Add(obj); db.SaveChanges(); return(obj); } } catch (Exception ex) { return(null); } }
public Usuario GetUser(System.Collections.Hashtable parametro) { try { var senhaCrypt = Cryptography.Generate(parametro["email"].ToString(), parametro["senha"].ToString()); var email = parametro["email"].ToString(); using (var db = new Connection.SigContext()) { var usuarios = db.Usuarios.FirstOrDefault(x => x.email == email && x.senha == senhaCrypt); return(usuarios); } } catch (Exception ex) { return(null); } }