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