방실이의 홈페이지

    /// <summary>
    /// CustomSqlMembershipProvider Ver 2.2
    /// </summary>
    /// <remarks>
    /// 06.04.03 - Prototype - 방실
    /// 06.07.07 - UserId라는 GUID키를 추가 - 방실
    /// 06.07.27 - partial 키워드로 override 부분과 재정의 부분을 분리 - 방실
    /// 06.10.13 - GetExceptionText에 case 8: 추가 - 방실
    /// 06.10.16 - ChangePassword 메서드의 버그 수정 - 방실
    /// </remarks>

public class CustomSqlMembershipProvider : MembershipProvider
{
      // Methods
      public CustomSqlMembershipProvider();
      private string BinToHex(byte[] arrByte);
      public bool ChangePassword(string userName, string newPassword);
      public override bool ChangePassword(string userName, string oldPassword, string newPassword);
      public override bool ChangePasswordQuestionAndAnswer(string userName, string password, string newPasswordQuestion, string newPasswordAnswer);
      internal bool CheckPassword(string userName, string password, out Message msg);
      private bool CheckPassword(string userName, string password, bool updateLastLoginActivityDate, bool failIfNotApproved);
      public override MembershipUser CreateUser(string userName, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status);
      public MembershipUser CreateUser(string userName, string password, string realName, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status, string phone, string celPhone, string ssn, string position, string department, string zipcode, string address1, string address2, int cPId, string cName, string cNameEtc);
      private bool CreateUserValidate(string userName, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, out MembershipCreateStatus status, out string encryptPassword, out string encryptPasswordAnswer);
      private string DecryptPassword(string pass);
      public override bool DeleteUser(string userName, bool deleteAllRelatedData);
      private string EncryptPassword(string pass);
      public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords);
      public override MembershipUserCollection FindUsersByName(string userNameToMatch, int pageIndex, int pageSize, out int totalRecords);
      public SqlDataReader GetAddressList(string dong);
      public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords);
      private string GetEncryptPasswordAnswer(string userName, string passwordAnswer);
      private string GetExceptionText(int status);
      public override int GetNumberOfUsersOnline();
      public override string GetPassword(string userName, string answer);
      private string GetPasswordFromDB(string userName, string passwordAnswer, out int status);
      private void GetPasswordWithFormat(string userName, bool updateLastLoginActivityDate, out int status, out string password, out int failedPasswordAttemptCount, out int failedPasswordAnswerAttemptCount, out bool isApproved, out DateTime lastLoginDate);
      public CustomSqlMembershipUser GetUser(string userName);
      public override MembershipUser GetUser(object providerUserKey, bool userIsOnline);
      public override MembershipUser GetUser(string userName, bool userIsOnline);
      public override string GetUserNameByEmail(string email);
      public string GetUserNameBySSN(string realName, string ssn, out Message msg);
      public override void Initialize(string name, NameValueCollection config);
      private bool IsStatusDueToBadPassword(int status);
      public override string ResetPassword(string userName, string answer);
      public override bool UnlockUser(string userName);
      public void UpdateUser(CustomSqlMembershipUser user);
      public override void UpdateUser(MembershipUser user);
      public override bool ValidateUser(string userName, string password);
      public void ValidateUserBySSN(string userName, string realName, string ssn, out Message msg);

      // Properties
      public override string ApplicationName { get; set; }
      public override bool EnablePasswordReset { get; }
      public override bool EnablePasswordRetrieval { get; }
      public override int MaxInvalidPasswordAttempts { get; }
      public override int MinRequiredNonAlphanumericCharacters { get; }
      public override int MinRequiredPasswordLength { get; }
      public override int PasswordAttemptWindow { get; }
      public override MembershipPasswordFormat PasswordFormat { get; }
      public override string PasswordStrengthRegularExpression { get; }
      public override bool RequiresQuestionAndAnswer { get; }
      public override bool RequiresUniqueEmail { get; }

      // Fields
      private string connectionString;
      private bool enablePasswordReset;
      private bool enablePasswordRetrieval;
      private int maxInvalidPasswordAttempts;
      private int minRequiredNonalphanumericCharacters;
      private int minRequiredPasswordLength;
      private int passwordAttemptWindow;
      private MembershipPasswordFormat passwordFormat;
      private string passwordStrengthRegularExpression;
      private bool requiresQuestionAndAnswer;
      private bool requiresUniqueEmail;
}
 

/// <summary>
/// 속성 값이 지정되고 고유한 식별자를 가진 새 사용자를 데이터 저장소에 추가하고 사용자가 만들어졌음을 나타내거나 사용자 만들기에 실패한 이유를 나타내는 상태 매개 변수를 반환합니다.
/// </summary>
/// <param name="userName">새 사용자의 사용자 아이디입니다.</param>
/// <param name="password">새 사용자의 암호입니다.</param>
/// <param name="password">새 사용자의 이름입니다.</param>
/// <param name="email">새 사용자의 전자 메일 주소입니다.</param>
/// <param name="passwordQuestion">멤버 자격 사용자의 암호 질문 값입니다.</param>
/// <param name="passwordAnswer">멤버 자격 사용자의 암호 대답 값입니다.</param>
/// <param name="isApproved">새 사용자에 대한 로그온이 승인되는지 여부를 나타내는 부울 값입니다.</param>
/// <param name="providerUserKey">멤버 자격 정보 저장소에 저장되어야 하는 사용자 ID입니다.</param>
/// <param name="status">사용자가 만들어졌음을 나타내거나 사용자 만들기에 실패한 이유를 나타내는 MembershipCreateStatus입니다.</param>
/// <returns>새로 만든 사용자에 대한 MembershipUser 개체입니다. 사용자가 만들어지지 않았으면 이 메서드가 Null 참조를 반환합니다. </returns>
public MembershipUser CreateUser(string userName, string password, string realName, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
{
    string encryptPassword = "";
    string encryptPasswordAnswer = "";

    if (!this.CreateUserValidate(userName, password, email, passwordQuestion, passwordAnswer, isApproved, out status, out encryptPassword, out encryptPasswordAnswer))
    {
        return null;
    }

    SqlDB db = new SqlDB(this.connectionString);
    DateTime time1 = DateTime.Now;
    SqlParameter[] param = {
        new SqlParameter("@ReturnValue", SqlDbType.Int),
        new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
        new SqlParameter("@UserName", SqlDbType.VarChar, 64),
        new SqlParameter("@Password", SqlDbType.VarChar, 256),
        new SqlParameter("@RealName", SqlDbType.VarChar, 128),
        new SqlParameter("@Email", SqlDbType.VarChar, 256),
        new SqlParameter("@PasswordQuestion", SqlDbType.VarChar,256),
        new SqlParameter("@PasswordAnswer", SqlDbType.VarChar,256),
        new SqlParameter("@IsApproved", SqlDbType.Bit),
        new SqlParameter("@UniqueEmail", SqlDbType.Bit),
        new SqlParameter("@CurrentTime", SqlDbType.DateTime)
    };
    param[0].Direction = ParameterDirection.ReturnValue;
    param[1].Direction = ParameterDirection.InputOutput;

    db.ExecuteNonQuery(false, CommandType.StoredProcedure, "dbo.Accounts_Custom_Membership_CreateUser", param, providerUserKey, userName, encryptPassword, realName, email, passwordQuestion, encryptPasswordAnswer, isApproved ? 1 : 0, this.RequiresUniqueEmail ? 1 : 0, time1);
    int num3 = db.GetReturnValue<int>(param[0]);
    if ((num3 < 0) || (num3 > 11))
    {
        num3 = 11;
    }
    status = (MembershipCreateStatus)num3;
    if (num3 != 0)
    {
        return null;
    }
    providerUserKey = new Guid(param[1].Value.ToString());
    time1 = time1.ToLocalTime();
    return new MembershipUser(this.Name, userName, providerUserKey, email, passwordQuestion, null, isApproved, false, time1, time1, time1, time1, new DateTime(0x6da, 1, 1));
}

    /// <summary>
    /// CustomSqlRoleProvider Ver 2.0
    /// </summary>
    /// <remarks>06.03.28 - Prototype - 방실</remarks>
    /// <remarks>06.07.07 - UserId라는 GUID키를 추가 - 방실</remarks>
    /// <remarks>06.07.27 - partial 키워드로 override 부분과 재정의 부분을 분리 - 방실</remarks>

public class CustomSqlRoleProvider : RoleProvider
{
      // Methods
      public override void AddUsersToRoles(string[] userNames, string[] roleNames);
      public override void CreateRole(string roleName);
      public override bool DeleteRole(string roleName, bool deleteOnlyIfRoleIsEmpty);
      public override string[] FindUsersInRole(string roleName, string userName);
      public override string[] GetAllRoles();
      public override string[] GetRolesForUser(string userName);
      public override string[] GetUsersInRole(string roleName);
      public override void Initialize(string name, NameValueCollection config);
      public override bool IsUserInRole(string userName, string roleName);
      public override void RemoveUsersFromRoles(string[] userNames, string[] roleNames);
      public override bool RoleExists(string roleName);

      // Properties
      public override string ApplicationName { get; set; }

      // Fields
      private string connectionString;
}

    <roleManager enabled="true" defaultProvider="CustomSqlRoleProvider" cacheRolesInCookie="true">
      <providers>
        <clear/>
        <add name="CustomSqlRoleProvider" connectionStringName="con" type="BIT.Web.Accounts.CustomSqlRoleProvider"/>
      </providers>
    </roleManager>

        /// <summary>
        /// 공급자를 초기화합니다. 
        /// </summary>
        /// <param name="name">공급자의 이름입니다.</param>
        /// <param name="config">이 공급자에 대해 구성에 지정된 공급자별 특성을 나타내는 이름/값 쌍의 컬렉션입니다.</param>
        public override void Initialize(string name, NameValueCollection config)
        {
            if (config == null)
            {
                throw new ArgumentNullException("config");
            }

            if (name == null || name.Length == 0)
            {
                name = "CustomSqlRoleProvider";
            }

            if (String.IsNullOrEmpty(config["description"]))
            {
                config.Remove("description");
                config.Add("description", "Custom Sql Role Provider");
            }

            if (String.IsNullOrEmpty(config["connectionStringName"]))
            {
                throw new ArgumentNullException("connectionStringName");
            }
            else
            {
                this.connectionString = config["connectionStringName"];
            }

            base.Initialize(name, config);
        }