public void DeleteSession()
{
using var context = new TecContext();
context.Remove(context.TrainingSessions.Find("TRA-000001"));
context.SaveChanges();
}
public void Opening_ManualDelete()
{
using var context = new TecContext();
context.Remove(context.Openings.Find("OPN-000001"));
context.SaveChanges();
}
public void RemoveCert()
{
using var context = new TecContext();
//context.Remove(context.Certifications.Find("CRT-000001"));
context.SaveChanges();
}
public void DeleteApplication()
{
using var context = new TecContext();
context.Remove(context.Applications.Find("APL-000002"));
context.SaveChanges();
}
public void DeleteSession()
{
using var context = new TecContext();
context.Remove(context.RegisteredCandidates.Find("REG-000001"));
context.SaveChanges();
}
public void DeleteCandidate()
{
using var context = new TecContext();
context.Remove(context.Candidates.Find("CDT-000001"));
context.Remove(context.Candidates.Find("CDT-000202"));
//context.Remove(context.Candidates.Find("CDT-000203"));
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 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 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 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 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 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 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 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 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 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 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 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 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 void AddJobHistory()
{
using var context = new TecContext();
var newHistory = new JobHistory
{
WorkedFrom = DateTime.Now.AddYears(-1),
WorkedTo = DateTime.Now.AddYears(1),
CandidateNumber = "CDT-000001",
CompanyId = "CMP-000001"
};
context.JobHistories.Add(newHistory);
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 void Candidate_UpdateCandidate()
{
using var context = new TecContext();
//var editCandidate = context.Candidates.Find("CDT-000202");
var updateCandidate = new Candidate
{
CandidateNumber = "CDT-000202",
//CandidateName = "Nathan Jesther G. Naanep",
CandidateGender = "Male",
CandidateAddress = "Koronadal City",
CandidateEmail = "mail.edu.ph"
};
context.Candidates.Update(updateCandidate);
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();
}
}
public void AddTrainingSession(TrainingSession trainingSession)
{
_context.TrainingSessions.Add(trainingSession);
_context.SaveChanges();
}
