public LogInViewModel(IApplicationController app)
{
_app = app;
this._ShowMainWindow = new RelayCommand(ShowMainWindow);
this._WachtwoordVergeten = new RelayCommand(ShowWachtwoordView);
_database = ModelFactory.Database;
}
public GebruikerAccountViewModel(IApplicationController app)
{
_app = app;
_opslaanCommand = new RelayCommand(Opslaan);
_terugCommand = new RelayCommand(Terug);
_database = ModelFactory.Database;
}
public StageBedrijfViewModel(IApplicationController app)
{
_app = app;
_saveCommand = new RelayCommand(Save);
_backCommand = new RelayCommand(Back);
_database = ModelFactory.Database;
}
public MatchMogelijkViewModel(IApplicationController app)
{
_app = app;
_showDetailsCommand = new RelayCommand(ShowDetails);
_matchenCommand = new RelayCommand(Matchen);
_terugCommand = new RelayCommand(Terug);
_database = ModelFactory.Database;
this.ReaderCollection = CollectionViewSource.GetDefaultView(SecondReader);
this.ReaderCollection.SortDescriptions.Add(new SortDescription("Hours", ListSortDirection.Descending));
this.TeacherCollection = CollectionViewSource.GetDefaultView(Teachers);
this.TeacherCollection.SortDescriptions.Add(new SortDescription("Hours", ListSortDirection.Descending));
}
public StageopdrachtViewModel(IApplicationController app)
{
_app = app;
_opslaanCommand = new RelayCommand(Save);
_terugCommand = new RelayCommand(Back);
_database = ModelFactory.Database;
fillBox();
FillKnowledgeAreas();
_type = new string[2];
_type[0] = "Stage";
_type[1] = "Afstuderen";
}
public MatchGemaaktViewModel(IApplicationController app)
{
_app = app;
_resetCommand = new RelayCommand(Reset);
_matchenCommand = new RelayCommand(Matchen);
_zoekenCommand = new RelayCommand(Zoeken);
_terugCommand = new RelayCommand(Terug);
_database = ModelFactory.Database;
_fillquery = "SELECT s.studentnr, s.naam, s.mailadres, o.omschrijving, so.opdrachtnaam, b.naam, so.periode_periodenaam, so.type, so.stagenr FROM student s JOIN stageopdracht_has_student ss ON s.studentnr = ss.student_studentnr JOIN stageopdracht so ON so.stagenr = ss.stageopdracht_stagenr JOIN stagebedrijf b ON so.stagebedrijf_bedrijfnr = b.bedrijfnr JOIN opleiding o ON s.opleiding_afkorting = o.afkorting JOIN docent_has_stageopdracht ds ON so.stagenr = ds.stageopdracht_stagenr GROUP BY ds.stageopdracht_stagenr";
FillTable();
FillPeriode();
this.StudentCollection = CollectionViewSource.GetDefaultView(Students);
SelectedPeriod = "Alle";
}
public MatchInvoerViewModel(IApplicationController app)
{
_app = app;
_resetCommand = new RelayCommand(Reset);
_matchenCommand = new RelayCommand(Matchen);
_zoekenCommand = new RelayCommand(Zoeken);
_matchmadeCommand = new RelayCommand(Matchmade);
_database = ModelFactory.Database;
_fillquery = "SELECT s.studentnr, s.naam, s.mailadres, o.omschrijving, so.opdrachtnaam, so.opdrachtgoed, so.toestemmingvoorlopig, so.toestemmingdefinitief, b.naam, so.periode_periodenaam, so.type FROM student s JOIN stageopdracht_has_student ss ON s.studentnr = ss.student_studentnr JOIN stageopdracht so ON so.stagenr = ss.stageopdracht_stagenr JOIN stagebedrijf b ON so.stagebedrijf_bedrijfnr = b.bedrijfnr JOIN opleiding o ON s.opleiding_afkorting = o.afkorting WHERE so.stagenr NOT IN (SELECT ds.stageopdracht_stagenr FROM docent_has_stageopdracht ds)";
FillTable();
FillPeriode();
this.StudentCollection = CollectionViewSource.GetDefaultView(Students);
SelectedPeriod = "Alle";
}
