public static void GenerateSchedules() { var schedules = Schedule_ReadFormCsv(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Schedule.CSV"); using var context = new TecContext(); foreach (var schedule in schedules) { context.Add(schedule); context.SaveChanges(); } }
public void GenerateApplications() { var applications = GetApplications(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Application.CSV"); using var context = new TecContext(); foreach (var application in applications) { context.Add(application); context.SaveChanges(); } }
public static void GenerateSessions() { var trainingSessions = GetSessions(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\TrainingSession.CSV"); using var context = new TecContext(); foreach (var trainingSession in trainingSessions) { context.Add(trainingSession); context.SaveChanges(); } }
public static void GenerateCandidates() { var candidates = Candidate_ReadFromCSV(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Candidate.CSV"); using var context = new TecContext(); foreach (var candidate in candidates) { context.Add(candidate); context.SaveChanges(); } }
public static void GenerateDays() { var days = Day_ReadFormCsv(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Day.CSV"); using var context = new TecContext(); foreach (var day in days) { context.Add(day); context.SaveChanges(); } }
public static void GenerateQualifications() { var qualifications = Qualification_ReadFromCSV(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Qualification.CSV"); using var context = new TecContext(); foreach (var qualification in qualifications) { context.Add(qualification); context.SaveChanges(); } }
public static void GenerateJobHistory() { var histories = GetJobHistories(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\History.csv"); using var context = new TecContext(); foreach (var jobHistory in histories) { context.Add(jobHistory); context.SaveChanges(); } }
public static void GenerateCertifications() { var certificates = Certification_ReadFromCSV( @"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Certification.csv"); using var context = new TecContext(); foreach (var certification in certificates) { context.Add(certification); context.SaveChanges(); } }
public static void GeneratePlacements_CSV() { var placements = GetPlacements(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Placement.csv"); using var context = new TecContext(); foreach (var placement in placements) { context.Add(placement); context.SaveChanges(); } }
public void AddOpening_Manual() { var openings = GetOpenings(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Opening.csv"); using var context = new TecContext(); context.Add(openings[0]); context.SaveChanges(); Console.WriteLine(openings[0].OpeningNumber); }
public static void GenerateCourses() { var courses = GetCourse(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Course.CSV"); using var context = new TecContext(); foreach (var course in courses) { context.Add(course); context.SaveChanges(); } }
public static void GenerateCompanies() { var companies = Company_ReadFromCSV(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Company.CSV"); using var context = new TecContext(); foreach (var company in companies) { context.Add(company); context.SaveChanges(); } }
public void Company_AddNewCompanyWithAutoGeneratedId() { using var context = new TecContext(); var newCompany = new Company(); newCompany.CompanyName = "Soft World"; context.Add(newCompany); context.SaveChanges(); Console.WriteLine($"ID: {newCompany.CompanyId}\tName: {newCompany.CompanyName}"); }
public void AddOpening_Loaded() { var openings = GetOpenings(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\Opening.csv"); using var context = new TecContext(); foreach (var opening in openings) { context.Add(opening); context.SaveChanges(); } }
public void AddCertificate_WithGeneratedKeys() { using var context = new TecContext(); var newCert = new Certification { CandidateNumber = new ForeignKeys().GetRandomCandidate(), QualificationId = new ForeignKeys().GetRandomQualification(), CertificationDate = new DateTime(2020, 1, 1) }; context.Add(newCert); context.SaveChanges(); Console.WriteLine($"ID: {newCert.CertificationId}\tCandidate Number: {newCert.CandidateNumber}\tQualification Code: {newCert.QualificationId}"); }
public static void GenerateRegistrations() { var registeredCandidates = GetRegisteredCandidates(@"C:\Users\Admin\Desktop\2nd Sem '19\Software Design\Project\Data\RegisteredCandidate.CSV"); using var context = new TecContext(); foreach (var registeredCandidate in registeredCandidates) { context.Add(registeredCandidate); context.SaveChanges(); } //context.Add(registeredCandidates[0]); //context.SaveChanges(); }
public static void GeneratePlacements() { using var context = new TecContext(); var foreignKey = new ForeignKeys(); for (int i = 0; i < 200; i++) { var newPlacement = new Placement { CandidateNumber = foreignKey.GetRandomCandidate(), OpeningNumber = foreignKey.GetRandomOpening(), PlacementStatus = i % 5 != 0 ? "Qualified" : "Pending" }; context.Add(newPlacement); context.SaveChanges(); } }
public void Candidate_ManualAdd() { using var context = new TecContext(); var newCandidate = new Candidate { CandidateFirstName = "Nathan Jesther", CandidateLastName = "Naanep", CandidateMiddleName = "Gagula", //CandidateName = "Nata de Coco", CandidateGender = "Male", CandidateAddress = "DVO", CandidateBirthDate = new DateTime(2000, 3, 25), CandidateContactNumber = "09999999999", CandidateEmail = "*****@*****.**" }; context.Add(newCandidate); context.SaveChanges(); }
public static void GeneratePrerequisites() { using var context = new TecContext(); var foreignKey = new ForeignKeys(); for (int i = 0; i < 200; i++) { var newCoursePrerequisite = new Prerequisite() { CourseId = foreignKey.GetRandomCourse(), QualificationId = foreignKey.GetRandomQualification(), RequirementFor = context.Prerequisites.Count() % 2 == 0 ? "Course" : "Qualification" }; context.Add(newCoursePrerequisite); context.SaveChanges(); } }