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; }