public List<Assignment> GetAllAssignments()
{
AssignmentDb asDB = new AssignmentDb();
List<Assignment> asgs = asDB.GetAllAssignments();
return asgs;
}
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 int CreateAssignment(int teacherId, string subject, string title, string exercise, DateTime date, DateTime deadline)
{
Assignment asg = new Assignment();
asg.Teacher = new Person(teacherId);
asg.Subject = subject;
asg.Title = title;
asg.Exercise = exercise;
asg.Date = date;
asg.Deadline = deadline;
asgDb = new AssignmentDb();
return asgDb.CreateAssignment(asg);
}
public int CreateAssignment(int teacherId, string subject, string title, string exercise, DateTime date, DateTime deadline)
{
PersonCtrl usCtrl = new PersonCtrl();
Assignment ass = new Assignment();
ass.teacher = (Teacher)usCtrl.GetPerson(teacherId);
ass.subject = subject;
ass.title = title;
ass.exercise = exercise;
ass.date = date;
ass.deadline = deadline;
AssignmentDb assDb = new AssignmentDb();
return assDb.CreateAssignment(ass);
}
public List<Assignment> GetAllAssignmentsByTeacher(int teacherId)
{
asgDb = new AssignmentDb();
return asgDb.GetAllAssignmentsByTeacher(teacherId);
}
public List<Assignment> GetAllAssignments()
{
asgDb = new AssignmentDb();
return asgDb.GetAllAssignments();
}
private List<Homework> MiscWhere(string where, Boolean retrieveAssociation)
{
List<Homework> hws = new List<Homework>();
try
{
cmd = new SqlCommand();
cmd.CommandText = BuildQuery(where);
dbCon = new DbConnection();
cmd.Connection = dbCon.GetConnection();
cmd.Connection.Open();
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
Homework hw = null;
while (dr.Read())
{
hw = BuildHomework(dr);
if (retrieveAssociation)
{
PersonDb persDb = new PersonDb();
int childId = hw.Child.Id;
Person child = persDb.SingleWhere("pid = '" + childId + "'", false);
hw.Child = child;
AssignmentDb asgDb = new AssignmentDb();
int assignmentId = hw.Assignment.Id;
Assignment asg = asgDb.SingleWhere("aid = '" + assignmentId + "'", false);
hw.Assignment = asg;
}
hws.Add(hw);
}
dr.Close();
}
catch
{
throw;
}
return hws;
}