public AuthPasswordModel Authenticate(AuthModel user)
{
try
{
using (var connection = _odsHelper.Connection())
{
var sql = @"
SELECT PasswordHash
,PasswordSalt
FROM AuthUsers
WHERE UserName = @UserName";
connection.Open();
var parameters = new DynamicParameters();
parameters.Add("@UserName", user.UserName, DbType.String, ParameterDirection.Input);
return(connection.QueryFirst <AuthPasswordModel>(sql, parameters, commandType: CommandType.Text));
}
}
catch (Exception ex)
{
_odsHelper.Logger().LogError(ex, "Error authenticating user");
return(null);
}
}
public IEnumerable <SampleModel> ListSamples()
{
try
{
using (var connection = _odsHelper.Connection())
{
var sql = @"
SELECT id
,value
FROM Samples";
connection.Open();
return(connection.Query <SampleModel>(sql));
}
}
catch (Exception ex)
{
_odsHelper.Logger().LogError(ex, "Error retrieving samples");
return(null);
}
}