public static void UnlockAll(LoginUser loginUser)
{
TaskEmailPosts taskEmailPosts = new TaskEmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE TaskEmailPosts SET LockProcessID = NULL";
command.CommandType = CommandType.Text;
taskEmailPosts.ExecuteNonQuery(command);
}
}
public static void UnlockThread(LoginUser loginUser, int thread)
{
TaskEmailPosts taskEmailPosts = new TaskEmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE TaskEmailPosts SET LockProcessID = NULL WHERE LockProcessID = @id";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("id", thread);
taskEmailPosts.ExecuteNonQuery(command);
}
}
public static TaskEmailPost GetTaskEmailPost(LoginUser loginUser, int taskEmailPostID)
{
TaskEmailPosts taskEmailPosts = new TaskEmailPosts(loginUser);
taskEmailPosts.LoadByTaskEmailPostID(taskEmailPostID);
if (taskEmailPosts.IsEmpty)
{
return(null);
}
else
{
return(taskEmailPosts[0]);
}
}
public static TaskEmailPost GetNextWaiting(LoginUser loginUser, string processID)
{
TaskEmailPosts emails = new TaskEmailPosts(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = @"
UPDATE
TaskEmailPosts
SET
LockProcessID = @ProcessID
OUTPUT
Inserted.*
WHERE
TaskEmailPostID IN
(
SELECT
TOP 1
TaskEmailPostID
FROM
TaskEmailPosts
WHERE
LockProcessID IS NULL
AND DATEADD(SECOND, HoldTime, DateCreated) < GETUTCDATE()
ORDER BY
DateCreated
)
";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@ProcessID", processID);
emails.Fill(command);
}
if (emails.IsEmpty)
{
return(null);
}
else
{
return(emails[0]);
}
}
public TaskEmailPost(DataRow row, TaskEmailPosts taskEmailPosts) : base(row, taskEmailPosts)
{
_taskEmailPosts = taskEmailPosts;
}
