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