internal List <UmService.wisVestiging> GetVestigingen(bool filterLocation, string[] locations)
{
List <UmService.wisVestiging> vestigingen = new List <UmService.wisVestiging>();
using (UmService.UmServiceClient us = new UmService.UmServiceClient())
{
try
{
Console.Write(string.Format("Vestigingen opvragen: "));
vestigingen = us.getInrichtingVestigingen(umServiceBrinNr, umServiceUsername, umServicePassword).ToList();
Console.WriteLine(vestigingen.Count());
}
catch (Exception ex)
{
eh.WriteLog(String.Format("Vestiging download mislukt: {0}", ex.Message), System.Diagnostics.EventLogEntryType.Error, 500);
}
if (filterLocation && vestigingen.Count() > 0)
{
Console.Write(string.Format("Vestigingen filteren: "));
vestigingen = vestigingen.Where(v => locations.Any(l => v.afkorting.ToLower() == l.ToLower())).ToList();
Console.WriteLine(string.Format("{0} vestigingen overgebleven", vestigingen.Count()));
}
Console.WriteLine(string.Format("-------------------------------------"));
}
return(vestigingen.OrderBy(v => v.afkorting).ToList());
}
internal bool ValidateUsernameFormat()
{
bool success = true;
webserviceUmObject dummyUser = new webserviceUmObject()
{
medewerkerUsername = "******"
};
try
{
ReplaceUserProperty(OutputFormatUsernameTeacher, dummyUser);
//ReplaceUserProperty(OutputFormatFirstnameTeacher, dummyUser);
//ReplaceUserProperty(OutputFormatLastnameTeacher, dummyUser);
}
catch (Exception ex)
{
success = false;
eh.WriteLog(string.Format("OutputFormatUsernameTeacher onjuist: {0}", ex.Message), System.Diagnostics.EventLogEntryType.Error, 500);
}
try
{
ReplaceUserProperty(OutputFormatUsernameStudent, dummyUser);
//ReplaceUserProperty(OutputFormatFirstnameStudent, dummyUser);
//ReplaceUserProperty(OutputFormatLastnameStudent, dummyUser);
}
catch (Exception ex)
{
success = false;
eh.WriteLog(string.Format("OutputFormatUsernameStudent onjuist: {0}", ex.Message), System.Diagnostics.EventLogEntryType.Error, 500);
}
return(success);
}
internal bool WriteSDStoFiles(string path, SDScsv sdscsv)
{
EventLogHelper eh = new EventLogHelper();
if (sdscsv.Schools.Count() > 0 &&
sdscsv.Sections.Count() > 0 &&
sdscsv.Teachers.Count() > 0 &&
sdscsv.Students.Count() > 0 &&
sdscsv.TeacherRosters.Count() > 0 &&
sdscsv.StudentEnrollments.Count > 0)
{
if (!Directory.Exists(path))
{
eh.WriteLog(String.Format("Output directory bestaat niet, maar wordt nu aangemaakt: {0} ", path), EventLogEntryType.Information, 100);
Directory.CreateDirectory(path);
}
Console.Write(string.Format("CSV-bestanden schrijven... "));
using (TextWriter writer = new StreamWriter(path + @"School.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<SchoolCSVMap>();
csv.WriteRecords(sdscsv.Schools); // where values implements IEnumerable
}
using (TextWriter writer = new StreamWriter(path + @"Section.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<SectionCSVMap>();
csv.WriteRecords(sdscsv.Sections); // where values implements IEnumerable
}
using (TextWriter writer = new StreamWriter(path + @"Student.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<StudentCSVMap>();
csv.WriteRecords(sdscsv.Students); // where values implements IEnumerable
}
using (TextWriter writer = new StreamWriter(path + @"Teacher.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<TeacherCSVMap>();
csv.WriteRecords(sdscsv.Teachers); // where values implements IEnumerable
}
using (TextWriter writer = new StreamWriter(path + @"TeacherRoster.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<TeacherRosterCSVMap>();
csv.WriteRecords(sdscsv.TeacherRosters); // where values implements IEnumerable
}
using (TextWriter writer = new StreamWriter(path + @"StudentEnrollment.csv"))
{
var csv = new CsvWriter(writer);
csv.Configuration.RegisterClassMap<StudentEnrollmentCSVMap>();
csv.WriteRecords(sdscsv.StudentEnrollments); // where values implements IEnumerable
}
if (sdscsv.Schools.Count == 1)
{
eh.WriteLog(String.Format("CSV-bestanden geschreven: {0}, {1} Lesgroepen, {2} Docenten, {3} Leerlingen, {4} Docentlesgroepen, {5} Leerlinglesgroepen, naar {6}",
sdscsv.Schools[0].Name, sdscsv.Sections.Count, sdscsv.Teachers.Count, sdscsv.Students.Count, sdscsv.TeacherRosters.Count, sdscsv.StudentEnrollments.Count, path), EventLogEntryType.Information, 200);
}
else
{
eh.WriteLog(String.Format("CSV-bestanden geschreven: {0} Scholen, {1} Lesgroepen, {2} Docenten, {3} Leerlingen, {4} Docentlesgroepen, {5} Leerlinglesgroepen, naar {6}",
sdscsv.Schools.Count, sdscsv.Sections.Count, sdscsv.Teachers.Count, sdscsv.Students.Count, sdscsv.TeacherRosters.Count, sdscsv.StudentEnrollments.Count, path), EventLogEntryType.Information, 200);
}
}
else
{
if (sdscsv.Schools.Count == 1)
{
eh.WriteLog(String.Format("Te weinig informatie om naar CSV te schrijven: {0}, {1} Lesgroepen, {2} Docenten, {3} Leerlingen, {4} Docentlesgroepen, {5} Leerlinglesgroepen",
sdscsv.Schools[0].Name, sdscsv.Sections.Count, sdscsv.Teachers.Count, sdscsv.Students.Count, sdscsv.TeacherRosters.Count, sdscsv.StudentEnrollments.Count), EventLogEntryType.Warning, 100);
}
else
{
eh.WriteLog(String.Format("Te weinig informatie om naar CSV te schrijven: {0} Scholen, {1} Lesgroepen, {2} Docenten, {3} Leerlingen, {4} Docentlesgroepen, {5} Leerlinglesgroepen",
sdscsv.Schools.Count, sdscsv.Sections.Count, sdscsv.Teachers.Count, sdscsv.Students.Count, sdscsv.TeacherRosters.Count, sdscsv.StudentEnrollments.Count), EventLogEntryType.Warning, 100);
}
}
return true;
}
