public List <SatyamResultsTableEntry> getEntries(string SQLCommandString) { List <SatyamResultsTableEntry> ret = new List <SatyamResultsTableEntry>(); 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["ResultString"]; int SatyamTaskTableEntryID = (int)reader["SatyamTaskTableEntryID"]; DateTime PageLoadTime = (DateTime)reader["PageLoadTime"]; DateTime SubmitTime = (DateTime)reader["SubmitTime"]; string Status = (string)reader["Status"]; SatyamResultsTableEntry entry = new SatyamResultsTableEntry(ID, JobTemplateType, UserID, JobGUID, JSonString, SatyamTaskTableEntryID, PageLoadTime, SubmitTime, Status); ret.Add(entry); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { } return(ret); }
public WorkerStatisticsTableEntry getWorkerStatistics(string l_WorkerId, string l_JobTemplateType) { String SQLCommandString = "SELECT * FROM " + TableName + " WHERE WorkerId = '" + l_WorkerId + "' AND JobTemplateType = '" + l_JobTemplateType + "'"; SqlCommand sqlCommand = new SqlCommand(SQLCommandString, dbAccess.getSQLConnection()); sqlCommand.CommandTimeout = 200; WorkerStatisticsTableEntry entry = null; try { SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { int Id = (int)reader["Id"]; string WorkerId = (string)reader["WorkerId"]; string JobTemplateType = (string)reader["JobTemplateType"]; int TasksDone = (int)reader["TasksDone"]; int TasksApproved = (int)reader["TasksApproved"]; double SuccessFraction = (double)reader["SuccessFraction"]; DateTime LastUpdateTime = (DateTime)reader["LastUpdateTime"]; entry = new WorkerStatisticsTableEntry(Id, WorkerId, JobTemplateType, TasksDone, TasksApproved, SuccessFraction, LastUpdateTime); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { } return(entry); }
public List <WorkerInfoTableEntry> getEntries(string SQLCommandString) { List <WorkerInfoTableEntry> ret = new List <WorkerInfoTableEntry>(); SqlCommand sqlCommand = new SqlCommand(SQLCommandString, dbAccess.getSQLConnection()); sqlCommand.CommandTimeout = 200; try { SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { int ID = (int)reader["id"]; string WorkerId = (string)reader["WorkerId"]; int Age = (int)reader["Age"]; string Sex = (string)reader["Sex"]; string Ethnicity = (string)reader["Ethnicity"]; string Employment = (string)reader["Employment"]; string Income = (string)reader["Income"]; string Home = (string)reader["Home"]; string HighestDegree = (string)reader["HighestDegree"]; string TaskSpecificInfo = (string)reader["TaskSpecificInfo"]; WorkerInfoTableEntry entry = new WorkerInfoTableEntry(ID, WorkerId, Age, Sex, Ethnicity, Employment, Income, Home, HighestDegree, TaskSpecificInfo); ret.Add(entry); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { } return(ret); }
public List <SatyamAmazonHITTableAccessEntry> getEntries(string SQLCommandString) { List <SatyamAmazonHITTableAccessEntry> ret = new List <SatyamAmazonHITTableAccessEntry>(); SqlCommand sqlCommand = new SqlCommand(SQLCommandString, dbAccess.getSQLConnection()); sqlCommand.CommandTimeout = 200; try { SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { int ID = (int)reader["ID"]; string JobTemplateType = (string)reader["JobTemplateType"]; string UserID = (string)reader["UserID"]; string HITID = (string)reader["HITID"]; string JobGUID = (string)reader["JobGUID"]; DateTime CreationTime = (DateTime)reader["CreationTime"]; string HITParameters = (string)reader["HITParameters"]; string AmazonAccessKeyID = (string)reader["AmazonAccessKeyID"]; string AmazonSecretAccessKeyID = (string)reader["AmazonSecretAccessKeyID"]; string Status = (string)reader["Status"]; SatyamAmazonHITTableAccessEntry entry = new SatyamAmazonHITTableAccessEntry(ID, JobTemplateType, UserID, HITID, JobGUID, CreationTime, HITParameters, AmazonAccessKeyID, AmazonSecretAccessKeyID, Status); ret.Add(entry); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { } return(ret); }
public List <SatyamTaskTableEntry> getEntries(string SQLCommandString) { List <SatyamTaskTableEntry> ret = new List <SatyamTaskTableEntry>(); 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["TaskParametersString"]; DateTime SubmitTime = (DateTime)reader["JobSubmitTime"]; int DoneScore = (int)reader["DoneScore"]; double PricePerTask = 0; if (reader["PricePerTask"] != null) { PricePerTask = (double)reader["PricePerTask"]; } SatyamTaskTableEntry entry = new SatyamTaskTableEntry(ID, JobTemplateType, UserID, JobGUID, JSonString, SubmitTime, DoneScore, PricePerTask); ret.Add(entry); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { } return(ret); }