public static void UnlockAll(LoginUser loginUser)
{
EmailPosts emailPosts = new EmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE EmailPosts SET LockProcessID = NULL";
command.CommandType = CommandType.Text;
emailPosts.ExecuteNonQuery(command);
}
}
public static void DeleteImportEmails(LoginUser loginUser)
{
EmailPosts emailPosts = new EmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "DELETE FROM EmailPosts WHERE CreatorID = -5";
command.CommandType = CommandType.Text;
emailPosts.ExecuteNonQuery(command, "EmailPosts");
}
}
public static void UnlockThread(LoginUser loginUser, int thread)
{
EmailPosts emailPosts = new EmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE EmailPosts SET LockProcessID = NULL WHERE LockProcessID = @id";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("id", thread);
emailPosts.ExecuteNonQuery(command);
}
}