private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.dbcontext = new timetableCreationEntities3();
this.roomsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("roomsViewSource")));
refreshListView();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.dbcontext = new timetableCreationEntities3();
// course lsit view source
this.coursesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("coursesViewSource")));
// refresh listview
refreshListView();
}
//private System.Windows.Data.CollectionViewSource roomsViewSource;
public Window1(string tName)
{
InitializeComponent();
timetableName = tName;
this.Title = timetableName;
bindComboBox(chooseCourse);
createExampleCSVFile("timetable.txt", "courseId, moduleId, lecturerId, roomId, day, time");
this.dbcontext = new timetableCreationEntities3();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.dbcontext = new timetableCreationEntities3();
this.roomsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("roomsViewSource")));
var query = from Room in this.dbcontext.Rooms
orderby Room.roomCode
select Room;
this.roomsViewSource.Source = query.ToList();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.dbcontext = new timetableCreationEntities3();
this.moduleViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("moduleViewSource")));
var query = from Module in this.dbcontext.Modules
orderby Module.moduleCode
select Module;
this.moduleViewSource.Source = query.ToList();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.dbcontext = new timetableCreationEntities3();
this.lecturersViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("lecturersViewSource")));
var query = from Lecturer in this.dbcontext.Lecturers
orderby Lecturer.lecturerName
select Lecturer;
this.lecturersViewSource.Source = query.ToList();
}
// method to refresh the listview
public void onRefresh()
{
this.dbcontext = new timetableCreationEntities3();
this.moduleViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("moduleViewSource")));
int intCId = int.Parse(cId);
// link query to get the modules for the selected course
var query = from Module in this.dbcontext.Modules
where Module.Courses.Any(c => c.courseId == intCId)
orderby Module.moduleName
select Module;
this.moduleViewSource.Source = query.ToList();
}
public void onRefresh()
{
this.dbcontext = new timetableCreationEntities3();
this.moduleViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("moduleViewSource")));
if (lecturerComboBox.SelectedItem != null)
{
int lecturerId = int.Parse(lecturerComboBox.SelectedValue.ToString());
var query = from Module in this.dbcontext.Modules
where Module.Lecturers.Any(l => l.lecturerId == lecturerId)
orderby Module.moduleName
select Module;
this.moduleViewSource.Source = query.ToList();
}
}
