// GET: Cliente
public List <Cliente> Get()
{
try
{
return(_contexto.ConexaoOracle().Query <Cliente>("select clienteid,nome from cliente").ToList());
}
catch (Exception ex)
{
Response.StatusCode = 400;
Response.WriteAsync(ex.Message);
return(null);
}
}
public object Login([FromBody] User user)
{
bool ok = false;
Usuario usuario = new Usuario();
if (user != null)
{
usuario = _contexto.ConexaoOracle().Query <Usuario>("select usuarioid,nome,login,senha,email from usuario where LOGIN = :LOGIN and SENHA = :SENHA",
new Dictionary <string, object>()
{
{ "LOGIN", user.Login }, { "SENHA", user.Senha }
}).FirstOrDefault();
if (usuario != null)
{
ok = true;
}
}
if (ok)
{
ClaimsIdentity identity = new ClaimsIdentity(
new GenericIdentity(user.Login, "Login"),
new[] {
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString("N")),
new Claim(JwtRegisteredClaimNames.UniqueName, usuario.Nome),
}
);
DateTime dataCriacao = DateTime.Now;
DateTime dataExpiracao = dataCriacao.AddDays(1);
var handler = new JwtSecurityTokenHandler();
var securityToken = handler.CreateToken(new SecurityTokenDescriptor
{
Issuer = _tokenConfiguration.Issuer,
Audience = _tokenConfiguration.Audience,
SigningCredentials = _tokenConfiguration.SigningCredentials,
Subject = identity,
NotBefore = dataCriacao,
Expires = dataExpiracao
});
var token = handler.WriteToken(securityToken);
return(new
{
authenticated = true,
created = dataCriacao.ToString("yyyy-MM-dd HH:mm:ss"),
expiration = dataExpiracao.ToString("yyyy-MM-dd HH:mm:ss"),
accessToken = token,
message = "OK"
});
}
else
{
return(new
{
authenticated = false,
message = "Falha ao autenticar"
});
}
}