public List <SatyamJobSubmissionsTableAccessEntry> getEntries(string SQLCommandString)
{
List <SatyamJobSubmissionsTableAccessEntry> ret = new List <SatyamJobSubmissionsTableAccessEntry>();
SqlCommand sqlCommand = new SqlCommand(SQLCommandString, dbAccess.getSQLConnection());
sqlCommand.CommandTimeout = 200;
try {
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
int ID = (int)reader["ID"];
string UserID = (string)reader["UserID"];
string JobGUID = (string)reader["JobGUID"];
string JobTemplateType = (string)reader["JobTemplateType"];
string JSonString = (string)reader["JobParametersString"];
DateTime SubmitTime = (DateTime)reader["JobSubmitTime"];
string Status = (string)reader["JobStatus"];
string Progress = (string)reader["JobProgress"];
SatyamJobSubmissionsTableAccessEntry entry = new SatyamJobSubmissionsTableAccessEntry(ID, JobTemplateType, UserID, JobGUID, JSonString, SubmitTime, Status, Progress);
ret.Add(entry);
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
}
return(ret);
}
public bool UpdateEntryProgress(string GUID, string Progress)
{
SatyamJobSubmissionsTableAccessEntry entry = getEntryByJobGIUD(GUID);
if (entry != null)
{
String SQLCommandString = "UPDATE " + TableName + " SET JobProgress = '" + Progress + "' WHERE JobGUID = '" + GUID + "'";
return(ExecuteNoQuerySQLCommand(SQLCommandString));
}
return(true);
}