public ArrayList readAllIssuedHomework()
{
ArrayList allIssuedHomework = new ArrayList();
string query = "SELECT * from IssuedHomework";
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader re = cmd.ExecuteReader();
while (re.Read())
{
IssuedHomework issuedHomework = new IssuedHomework(re["IssuedHomeworkID"].ToString(), re["CoreHomeworkID"].ToString(), re["StudentID"].ToString(), re["SetByTeacherID"].ToString(), re["TimeToComplete"].ToString(), Convert.ToDateTime(re["DueDate"]), Convert.ToDateTime(re["SubmissionDate"]));
allIssuedHomework.Add(issuedHomework);
}
conn.Close();
return(allIssuedHomework);
}
public ArrayList selectAllIssuedHomeworkFromCore(string id)
{
ArrayList selectedIDs = new ArrayList();
string query = "SELECT IssuedHomeworkID FROM IssuedHomework WHERE CoreHomeworkID = '" + id + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader re = cmd.ExecuteReader();
while (re.Read())
{
IssuedHomework thisIssHw = new IssuedHomework(re["IssuedHomeworkID"].ToString());
selectedIDs.Add(thisIssHw.IssuedHomeworkID);
}
//cmd.ExecuteNonQuery();
conn.Close();
return(selectedIDs);
}
public IssuedHomework readSelectedIssuedHomeworkForMarking(string id)//if submission date is null this cant be read
{
string query = "SELECT * from IssuedHomework WHERE IssuedHomeworkID = @id";
IssuedHomework seclectedIssuedHomework = new IssuedHomework();
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader re = cmd.ExecuteReader();
while (re.Read())
{
seclectedIssuedHomework = new IssuedHomework(re["IssuedHomeworkID"].ToString(), re["CoreHomeworkID"].ToString(), re["StudentID"].ToString(), re["SetByTeacherID"].ToString(), re["TimeToComplete"].ToString(), Convert.ToDateTime(re["DueDate"]), Convert.ToDateTime(re["SubmissionDate"]));
}
conn.Close();
return(seclectedIssuedHomework);
}
