public BedrijfViewModel(MainViewModel main,PropertyChanged last, companies bedrijf)
: this(main,last)
{
Bedrijf = bedrijf;
}
public GegevensOverzichtViewModel(MainViewModel main, PropertyChanged last)
: base(main, last)
{
stagemanagerEntities smE = new stagemanagerEntities();
List<students> students = smE.students.ToList();
List = new Dictionary<object, students>();
List<students> studenten = new List<students>();
for (int i = 0; i < students.Count; i++)
{
users thisUser = new users
{
name = "",
surname = "",
phonenumber = "",
email = "",
};
adresses thisAdresses = new adresses
{
street = "",
housenumber = "",
place = "",
zipcode = "",
};
adresses companyAdresses = new adresses
{
street = "",
housenumber = "",
place = "",
zipcode = "",
};
companies thisCompany = new companies
{
name ="",
website = "",
phonenumber = "",
adresses = companyAdresses
};
users superviserUser = new users
{
name = "",
surname = "",
phonenumber = "",
email = "",
};
supervisor thisSupervisor = new supervisor
{
users = superviserUser,
companies = thisCompany
};
List<students_internships> myList = new List<students_internships>();
myList.Add(new students_internships
{
internships = new internships
{
supervisor = thisSupervisor
}
});
students thisStudent = new students
{
users = thisUser,
meets = "",
adresses = thisAdresses,
studentnumber = 0,
students_internships = myList
};
if (students[i].studentnumber != null)
{
thisStudent.studentnumber = students[i].studentnumber;
}
if (students[i].meets != null)
{
thisStudent.meets = students[i].meets;
}
if (students[i].users == null)
{
}
else
{
if (students[i].users.name != null)
{
thisStudent.users.name = students[i].users.name;
}
if (students[i].users.surname != null)
{
thisStudent.users.surname = students[i].users.surname;
}
if (students[i].users.email != null)
{
thisStudent.users.email = students[i].users.email;
}
if (students[i].users.phonenumber != null)
{
thisStudent.users.phonenumber = students[i].users.phonenumber;
}
}
if (students[i].adresses == null)
{
thisStudent.adresses.street = "";
thisStudent.adresses.housenumber = "";
thisStudent.adresses.zipcode = "";
thisStudent.adresses.place = "";
}
else
{
if (students[i].adresses.street != null)
{
thisStudent.adresses.street = students[i].adresses.street;
}
if (students[i].adresses.housenumber != null)
{
thisStudent.adresses.housenumber = students[i].adresses.housenumber;
}
if (students[i].adresses.zipcode != null)
{
thisStudent.adresses.zipcode = students[i].adresses.zipcode;
}
if (students[i].adresses.place != null)
{
thisStudent.adresses.place = students[i].adresses.place;
}
}
if (students[i].students_internships != null && students[i].students_internships.Count > 0 && students[i].students_internships.First().internships != null)
{
if (students[i].students_internships.First().internships.supervisor != null)
{
if (students[i].students_internships.First().internships.supervisor.users.name != null)
{
thisStudent.students_internships.First().internships.supervisor.users.name = students[i].students_internships.First().internships.supervisor.users.name;
}
if (students[i].students_internships.First().internships.supervisor.users.phonenumber != null)
{
thisStudent.students_internships.First().internships.supervisor.users.phonenumber = students[i].students_internships.First().internships.supervisor.users.phonenumber;
}
if (students[i].students_internships.First().internships.supervisor.companies != null)
{
if (students[i].students_internships.First().internships.supervisor.companies.name != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.name = students[i].students_internships.First().internships.supervisor.companies.name;
}
if (students[i].students_internships.First().internships.supervisor.companies.phonenumber != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.phonenumber = students[i].students_internships.First().internships.supervisor.companies.phonenumber;
}
if (thisStudent.students_internships.First().internships.supervisor.companies.adresses != null)
{
if (students[i].students_internships.First().internships.supervisor.companies.adresses.street != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.adresses.street = students[i].students_internships.First().internships.supervisor.companies.adresses.street;
}
if (students[i].students_internships.First().internships.supervisor.companies.adresses.housenumber != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.adresses.housenumber = students[i].students_internships.First().internships.supervisor.companies.adresses.housenumber;
}
if (students[i].students_internships.First().internships.supervisor.companies.adresses.zipcode != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.adresses.zipcode = students[i].students_internships.First().internships.supervisor.companies.adresses.zipcode;
}
if (students[i].students_internships.First().internships.supervisor.companies.adresses.place != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.adresses.place = students[i].students_internships.First().internships.supervisor.companies.adresses.place;
}
}
if (students[i].students_internships.First().internships.supervisor.companies.phonenumber != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.phonenumber = students[i].students_internships.First().internships.supervisor.companies.phonenumber;
}
if (students[i].students_internships.First().internships.supervisor.companies.website != null)
{
thisStudent.students_internships.First().internships.supervisor.companies.website = students[i].students_internships.First().internships.supervisor.companies.website;
}
}
}
}
studenten.Add(thisStudent);
}
List = studenten.ToDictionary(t => (Object)new
{
Studentnummer = t.studentnumber,
Voornaam = t.users.name,
Achternaam = t.users.surname,
Email = t.users.email,
EmailURL = t.users.email,
Telefoonnummer = t.users.phonenumber,
ToestEx = t.meets,
Straatnaam = t.adresses.street,
Nummer = t.adresses.housenumber,
Postcode = t.adresses.zipcode,
Plaats = t.adresses.place,
Bedrijf = t.students_internships.First().internships.supervisor.companies.name,
BTelefoon = t.students_internships.First().internships.supervisor.companies.phonenumber,
Website = t.students_internships.First().internships.supervisor.companies.website,
BStraat = t.students_internships.First().internships.supervisor.companies.adresses.street,
BNummer = t.students_internships.First().internships.supervisor.companies.adresses.housenumber,
BPostcode = t.students_internships.First().internships.supervisor.companies.adresses.zipcode,
BPlaats = t.students_internships.First().internships.supervisor.companies.adresses.place,
Bedrijfsbegeleider = t.students_internships.First().internships.supervisor.users.name + " " + t.students_internships.First().internships.supervisor.users.surname,
BegTelefoon = t.students_internships.First().internships.supervisor.users.phonenumber
}, t => t);
}
public override void update(object[] o)
{
try
{
Bedrijf = (companies)o[2];
}
catch (Exception)
{
throw;
}
}