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