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