public static void UnlockAll(LoginUser loginUser) { ScheduledReports scheduledReports = new ScheduledReports(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = "UPDATE ScheduledReports SET LockProcessID = NULL"; command.CommandType = CommandType.Text; scheduledReports.ExecuteNonQuery(command); } }
public static void UnlockThread(LoginUser loginUser, int thread) { ScheduledReports scheduledReports = new ScheduledReports(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = "UPDATE ScheduledReports SET LockProcessId = NULL WHERE LockProcessId = @id"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("id", thread); scheduledReports.ExecuteNonQuery(command); } }