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