public void GetCandidateWithOutTheGivenQualification()
{
using var _context = new TecContext();
string qualificationCode = "QLN-000001";
var qualifiedCandidates = _context.Candidates.Where(candidate =>
_context.Certifications.Where(certification => certification.QualificationId == qualificationCode)
.Select(certification => certification.CandidateNumber)
.Contains(candidate.CandidateNumber)).Select(c => c.CandidateNumber).ToList();
var candidateList = _context.Candidates.Where(candidate =>
!qualifiedCandidates.Any(c => c
.Equals(candidate.CandidateNumber)));
//var candidateList = new List<Candidate>();
//foreach (var candidate in _context.Candidates)
// if (!qualifiedCandidates.Any(c => c.Equals(candidate.CandidateNumber)))
// candidateList.Add(candidate);
foreach (var candidate in candidateList)
{
Console.WriteLine($"{candidate.CandidateNumber}\t{candidate.CandidateFullName}");
}
}
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 DeleteSession()
{
using var context = new TecContext();
context.Remove(context.TrainingSessions.Find("TRA-000001"));
context.SaveChanges();
}
public void Candidate_ViewApplications()
{
using var context = new TecContext();
//var candidates = context.Candidates.Where(c => c.IsDeleted == false);
//foreach (var candidate in candidates)
//{
// Console.WriteLine($"Candidate: {candidate.CandidateName}");
// var candidatesApplication = context.Applications
// .Where(c => c.CandidateNumber == candidate.CandidateNumber
// && c.IsDeleted == false);
// foreach (var application in candidatesApplication)
// Console.WriteLine($"{application.ApplicationId}");
//}
var candidate = context.Candidates.Find(new ForeignKeys().GetRandomCandidate());
var candidateApplication =
context.Placements.Where(c => c.CandidateNumber == candidate.CandidateNumber).ToList();
//Console.WriteLine($"Candidate: {candidate.CandidateName}");
foreach (var application in candidateApplication)
{
Console.WriteLine($"{application.PlacementId}");
}
}
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 DisplayUnrelatedCourse()
{
using var db = new TecContext();
string qualification = "QLN-000001";
var requiredCourses =
db.Prerequisites.Where(c => c.RequirementFor.ToLower() == "qualification" &&
c.QualificationId == qualification)
.Select(c => c.CourseId).OrderBy(c => c).ToList();
var courses = db.Courses.Where(c => !c.IsDeleted).ToList();
var courseList = courses.Where(course => !requiredCourses.Any(c =>
c.Equals(course.CourseId))).OrderBy(c => c.CourseId).ToList();
foreach (var course in courseList)
{
Console.WriteLine($"{course.CourseId}\t{course.CourseName}");
}
Console.WriteLine("\nRequired Courses");
foreach (var course in requiredCourses)
{
Console.WriteLine(course);
}
}
public void DeleteCourse()
{
using var context = new TecContext();
context.Remove(context.Courses.Find("COR-000001"));
//context.SaveChanges();
}
public void GetCandidateWithOutAssociatedEntity_ExplicitLoading()
{
using var _context = new TecContext();
string qualificationCode = "QLN-000001";
var candidates = _context.Candidates.Where(c => !c.IsDeleted).ToList();
var certifications = _context.Certifications.Where(c => c.QualificationId == qualificationCode)
.Select(c => c.CandidateNumber).ToList();
var candidateList = new List <Candidate>();
foreach (var candidate in candidates)
{
if (certifications.Any(c => c == candidate.CandidateNumber))
{
if (!candidateList.Contains(candidate))
{
candidateList.Add(candidate);
}
}
}
foreach (var candidate in candidateList)
{
Console.WriteLine($"{candidate.CandidateNumber}\t{candidate.CandidateFullName}");
}
}
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();
}
protected override object NextValue(EntityEntry entry)
{
using var context = new TecContext();
var st = new StringBuilder();
st.Append($"Day-{context.Days.Count()+1}");
return(st.ToString());
}
public void Candidate_ViewCandidate()
{
using var context = new TecContext();
var candidates = context.Candidates;
foreach (var candidate in candidates)
{
Console.WriteLine($"{candidate.CandidateNumber}");
}
}
public void Candidate_ViewCandidateFromDataBase()
{
using var context = new TecContext();
var candidates = context.Candidates.Where(c => c.IsDeleted == false);
foreach (var candidate in candidates)
{
//Console.WriteLine($"{candidate.CandidateNumber}\t{candidate.CandidateName}\t{candidate.CandidateAge}");
}
}
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 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();
}
}
protected override object NextValue(EntityEntry entry)
{
using var context = new TecContext();
var st = new StringBuilder();
var idNumSequence = (context.Schedules.Count() + 1).ToString().PadLeft(6, '0');
st.Append($"SCD-{idNumSequence}");
return(st.ToString());
}
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 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 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 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 string GetRandomCandidate()
{
using var context = new TecContext();
var count = context.Candidates.Count();
var r = new Random();
var selected = r.Next(minValue: 0, maxValue: count);
var candidate = context.Candidates.Skip(selected).Take(1).First();
return(candidate.CandidateNumber);
}
public string GetRandomOpening()
{
using var context = new TecContext();
var count = context.Openings.Count();
var r = new Random();
var selected = r.Next(minValue: 0, maxValue: count);
var opening = context.Openings.Skip(selected).Take(1).First();
return(opening.OpeningNumber);
}
public string GetRandomCourse()
{
using var context = new TecContext();
var count = context.Courses.Count();
var r = new Random();
var selected = r.Next(minValue: 0, maxValue: count);
var course = context.Courses.Skip(selected).Take(1).First();
return(course.CourseId);
}
public string GetRandomQualification()
{
using var context = new TecContext();
var count = context.Qualifications.Count();
var r = new Random();
var selected = r.Next(minValue: 0, maxValue: count);
var qualification = context.Qualifications.Skip(selected).Take(1).First();
return(qualification.QualificationId);
}
protected override object NextValue(EntityEntry entry)
{
using var context = new TecContext();
var stringId = new StringBuilder();
var idNumSequence = (context.JobHistories.Count() + 1).ToString();
stringId.Append("HTY-");
stringId.Append($"{idNumSequence.PadLeft(6, '0')}");
return(stringId.ToString());
}
public void DisplayPrerequisiteForQualification()
{
using var context = new TecContext();
var prereq = context.Prerequisites.Where(c => c.RequirementFor.ToLower() == "course")
.Include(c => c.CourseLink)
.Include(c => c.QualificationLink);
foreach (var prerequisite in prereq)
{
Console.WriteLine($"{prerequisite.QualificationLink.QualificationCode} Require {prerequisite.CourseLink.CourseName}");
}
}
public string GetRandomSessions()
{
using var context = new TecContext();
var count = context.TrainingSessions.Count();
var r = new Random();
var selected = r.Next(minValue: 0, maxValue: count);
var trainingSession = context.TrainingSessions.Skip(selected).Take(1).First();
return(trainingSession.SessionId);
}
protected override object NextValue(EntityEntry entry)
{
using var context = new TecContext();
var st = new StringBuilder();
var idNumSequence = (context.Placements.Count() + 1).ToString();
st.Append("PLC-");
st.Append($"{idNumSequence.PadLeft(6, '0')}");
return(st.ToString());
}
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();
}
}
