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