public async Task <bool> UserExists(string username)
{
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
if (await connection.QueryFirstOrDefaultAsync <User>(SqlQueriesFactory.GetUser(), new { Username = username }) == null)
{
return(false);
}
else
{
return(true);
}
}
}
public async Task <User> Login(UserForLoginDto userForLoginDto)
{
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
var user = await connection.QueryFirstOrDefaultAsync <User>(SqlQueriesFactory.GetUser(), new { Username = userForLoginDto.Username });
if (user == null)
{
return(null);
}
if (!VerifyPasswordHash(userForLoginDto.Password, user.PasswordHash, user.PasswordSalt))
{
return(null);
}
return(user);
}
}