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