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); } }