using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FrameworkDAL.Query.PasswordPolicy
{
    public static class PasswordPolicyQB
    {
        public const string GET_PASSWORDPOLICY = @"
SELECT 
    PP.PASSWORDPOLICYID AS PasswordPolicyId,
    PP.PASSWORDPOLICYCODE AS PasswordPolicyCode,
    PP.PASSWORDPOLICYNAME AS PasswordPolicyName,
    PP.MAXIMUMPASSWORDAGE AS PasswordPolicyMaximumPasswordAge,
    PP.MINIMUMPASSWORDAGE AS PasswordPolicyMinimumPasswordAge,
    PP.NUMBEROFWRONGATTEMPTS AS PasswordPolicyNumberOfWrongAttempts,
    PP.PASSWORDHISTORY AS PasswordPolicyPasswordHistory,
    PP.MINIMUMPASSWORDLENGTH AS PasswordPolicyMinimumPasswordLength,
    PP.MINIMUMNUMBERLENGTH AS PasswordPolicyMinimumNumberLength,
    PP.MINIMUMUPPERLENGTH AS PasswordPolicyMinimumUpperLength,
    PP.MINIMUMSPECIALLENGTH AS PasswordPolicyMinimumSpecialLength,
    PP.MAXCONSECUTIVEREPEATEDCHARS AS PasswordPolicyMaxConsecutiveRepeatedChars,
    PP.MAXCONSECUTIVERUNNINGNUMBERS AS PasswordPolicyMaxConsecutiveRunningNumbers,
    PP.SORTORDER AS PasswordPolicySortOrder,
    PP.STATUS AS PasswordPolicyStatus,
    PP.VERSION AS PasswordPolicyVersion,
    PP.SOURCETYPE AS PasswordPolicySourceType,
    PP.CREATEDBYID AS PasswordPolicyCreatedById,
    CU.USERNAME AS PasswordPolicyCreatedByName,
    PP.CREATEDON AS PasswordPolicyCreatedOn,
    PP.MODIFIEDBYID AS PasswordPolicyModifiedById,
    MU.USERNAME AS PasswordPolicyModifiedByName,
    PP.MODIFIEDON AS PasswordPolicyModifiedOn
FROM
    MPASSWORDPOLICY PP
    INNER JOIN MUSER CU ON PP.CREATEDBYID = CU.USERID
    INNER JOIN MUSER MU ON PP.MODIFIEDBYID = MU.USERID
WHERE
    PP.PASSWORDPOLICYID = @passwordpolicyid;
";

    }
}