Example #1
0
 public static void Activate(Guid confirmation)
 {
     using (SqlCmd cmd = new SqlCmd("UPDATE [User] SET IsActive = 1, EmailConfirmation = NULL WHERE EmailConfirmation = @Confirmation", false))
     {
         cmd.AddIGuid("@Confirmation", confirmation);
         cmd.Execute();
     }
 }
Example #2
0
 public static bool ConfirmationExists(Guid confirmation)
 {
     using (SqlCmd cmd = new SqlCmd("SELECT Id FROM [User] WHERE EmailConfirmation = @Confirmation", false))
     {
         cmd.AddIGuid("@Confirmation", confirmation);
         return(cmd.ExecuteSingleRowOrNull() != null);
     }
 }
Example #3
0
 public static void AssignEmailConfirmation(int userId, Guid?emailConfirmation, bool isActive = false)
 {
     using (SqlCmd cmd = new SqlCmd("UPDATE [User] SET EmailConfirmation = @EmailConfirmation, IsActive = @IsActive WHERE Id = @Id", false))
     {
         cmd.AddIInt("@Id", userId);
         cmd.AddIGuid("@EmailConfirmation", emailConfirmation);
         cmd.AddIBool("@IsActive", isActive);
         cmd.Execute();
     }
 }
Example #4
0
 public static void AddResetRequest(Guid id, int userId)
 {
     using (SqlCmd cmd = new SqlCmd("UPDATE ResetRequests SET PasswordReset = 1 WHERE UserId = @UserId", false))
     {
         cmd.AddIInt("@UserId", userId);
         cmd.Execute();
     }
     using (SqlCmd cmd = new SqlCmd("INSERT INTO ResetRequests (Id, UserId) VALUES (@Id, @UserId)", false))
     {
         cmd.AddIGuid("@Id", id);
         cmd.AddIInt("@UserId", userId);
         cmd.Execute();
     }
 }
Example #5
0
        public static (bool reset, DateTime requestDate, int userId)? GetResetRequest(Guid resetRequest)
        {
            using (SqlCmd cmd = new SqlCmd("SELECT * FROM ResetRequests WHERE Id = @Id", false))
            {
                cmd.AddIGuid("@Id", resetRequest);
                var r = cmd.ExecuteSingleRowOrNull();
                if (r == null)
                {
                    return(null);
                }

                return((bool)r["PasswordReset"], (DateTime)r["RequestTime"], (int)r["UserId"]);
            }
        }
Example #6
0
        public static string GetUser(Guid confirmation)
        {
            using (SqlCmd cmd = new SqlCmd("SELECT UserName FROM [User] WHERE EmailConfirmation = @Confirmation", false))
            {
                cmd.AddIGuid("@Confirmation", confirmation);
                var r = cmd.ExecuteSingleRowOrNull();
                if (r == null)
                {
                    return(null);
                }

                return((string)r["UserName"]);
            }
        }
Example #7
0
 public void Add(string password, string ip, Guid emailConfirmation)
 {
     using (SqlCmd cmd = new SqlCmd("INSERT INTO [User] (UserName, UserEmail, UserPassword, TimeZone, IPAddress, IsActive, EmailConfirmation) VALUES (@UserName, @UserEmail, @Password, @TimeZone, @IPAddress, 0, @EmailConfirmation); SET @Id = SCOPE_IDENTITY();", false))
     {
         cmd.AddIString("@UserName", 40, UserName);
         cmd.AddIString("@UserEmail", 50, Email);
         cmd.AddIString("@Password", 250, password);
         cmd.AddIString("@TimeZone", 50, TimeZone.Id);
         cmd.AddIString("@IPAddress", 100, ip);
         cmd.AddIGuid("@EmailConfirmation", emailConfirmation);
         cmd.AddOInt("@Id");
         cmd.Execute();
         Id = cmd.GetInt("@Id");
     }
 }