private void timer_ExecuteJobs_Tick(object sender, EventArgs e)
{
List <JobO> jobsToExecute = DB_Server.SelectJobsToBeExecuted();
foreach (JobO executingJob in jobsToExecute)
{
RO jobResource = DB_Server.GetResource(executingJob.ResourceID);
ExecuteDummyScript(jobResource.ExecuteScript, executingJob);
}
}
internal static RO GetResource(int resourceID)
{
RO r = new RO();
OpenConnection();
SqlCommand getR = new SqlCommand("SELECT * FROM Resource WHERE ResourceID=@ResourceID", myConnection);
getR.Parameters.Add("@ResourceID", SqlDbType.Int);
getR.Parameters["@ResourceID"].Value = resourceID;
SqlDataReader reader = getR.ExecuteReader();
if (reader.Read())
{
r.Name = reader.GetString(1);
r.ResourceID = reader.GetInt32(2);
}
CloseConnection();
return(r);
}
