public MyObservableCollection <MyTeacher> refreshTeacherTable()
{
MyObservableCollection <MyTeacher> myTeachers = new MyObservableCollection <MyTeacher>();
var query = from s in teacherTable
select new MyTeacher(s.ID, s.CellPhone, s.FirstName, s.LastName, s.Enabled);
foreach (MyTeacher ss in query)
{
myTeachers.Add(ss);
}
return(myTeachers);
}
public MyObservableCollection <MyClass> refreshClassTable()
{
MyObservableCollection <MyClass> myClasses = new MyObservableCollection <MyClass>();
var query = from s in classTable
where s.Enabled == true
select new MyClass(s.ID, s.Division, s.ClassName, s.Semester, s.Dayofweek, s.Timeofweek, s.Enabled, s.Tuition);
foreach (MyClass ss in query)
{
myClasses.Add(ss);
}
return(myClasses);
}
public MyObservableCollection <MyClass> refreshClassTable()
{
MyObservableCollection <MyClass> myClasses = new MyObservableCollection <MyClass>();
var query = (from s in classTable
where s.Enabled == true
orderby s.ID descending
select new MyClass(s.ID, s.Division, s.ClassName, s.Semester, s.Dayofweek, s.Timeofweek, s.Enabled, s.Tuition)
).Take(ClassDropDownItems)
;
foreach (MyClass ss in query)
{
myClasses.Add(ss);
}
return(myClasses);
}
public MyObservableCollection <MyStudent> refreshStudentTable()
{
MyObservableCollection <MyStudent> myStudents = new MyObservableCollection <MyStudent>();
var query = (from s in studentTable
select new MyStudent(s.ID,
"" + s.FirstName + " " + s.LastName + " " + ((s.CellPhone.Length > 0) ? s.CellPhone : s.HomePhone),
s.FirstName, s.LastName)
).Take(StudentDropDownItems)
;
foreach (MyStudent ss in query)
{
myStudents.Add(ss);
}
return(myStudents);
}
