using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using Neo.Afx.Security;

namespace Neo.SqlServer
{
    /// <summary>
    /// Groups some security utility methods.
    /// </summary>
    public class Authentication
    {
        [SqlFunction(IsDeterministic = true, IsPrecise = true)]
        public static SqlString HashPassword(SqlString password)
        {
            return new SqlString(SecurePassword.Hash(password.Value));
        }

        [SqlFunction(IsDeterministic = false, IsPrecise = true)]
        public static SqlString GeneratePassword(int length)
        {
            return new SqlString(SecurePassword.CreateSalt(length));
        }

        [SqlFunction(IsDeterministic = false, IsPrecise = true)]
        public static SqlString CreatePasswordSalt()
        {
            return new SqlString(SecurePassword.CreateSalt());
        }
    }
}