public ListForObjects GetAllAssignmentsByTeacherId(int teacherId)
{
AssignmentDb asDB = new AssignmentDb();
PersonCtrl userCtrl = new PersonCtrl();
ListForObjects list = new ListForObjects();
ListForObjects l = asDB.GetAllAssignmentsByTeacherId(teacherId);
foreach (Object o in l.Asl)
{
Assignment a = (Assignment)o;
a.teacher = (Teacher)userCtrl.GetPerson(a.teacher.Id);
list.Asl.Add(a);
}
return list;
}
public ListForObjects GetAllHomeworksByID(int assignmentId)
{
HomeworkDb hwDb = new HomeworkDb();
UserCtrl userCtrl = new UserCtrl();
AssignmentCtrl assgnmentCtrl = new AssignmentCtrl();
ListForObjects l = hwDb.GetAllHomeworksById(assignmentId);
ListForObjects list = new ListForObjects();
foreach (Homework hw in l.Asl)
{
hw.Child = (Child)userCtrl.GetPerson(hw.Child.Id);
//hw.Assignment = assgnmentCtrl.GetAssignmentById(hw.Assignment.Id);
list.Asl.Add(hw);
}
return list;
}
public ListForObjects GetAllHomeworksById(int assignmentId)
{
ListForObjects homeworkList = new ListForObjects();
try
{
comm = new SqlCommand();
comm.CommandText = "SELECT * FROM Homework WHERE assignmentId = " + assignmentId;
dbCon = new DbConnection();
comm.Connection = dbCon.GetConnection();
comm.Connection.Open();
comm.CommandType = CommandType.Text;
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
Homework h = new Homework();
h.Id = Convert.ToInt32(dr["hid"]);
Assignment a = new Assignment();
a.Id = Convert.ToInt32(dr["assignmentId"]);
h.Assignment = a;
Child c = new Child();
c.Id = Convert.ToInt32(dr["childId"]);
h.Child = c;
h.Date = Convert.ToDateTime(dr["date"]);
h.DiskName = Convert.ToString(dr["diskName"]);
homeworkList.AddObj(h);
}
}
catch (Exception)
{
throw;
}
finally
{
comm.Connection.Close();
}
return homeworkList;
}
