private static IList <JobHistory> GetJobHistories(string location)
{
var sr = new StreamReader(location);
var historyList = new List <JobHistory>();
var foreignKey = new ForeignKeys();
string s = sr.ReadLine();
while (s != null)
{
var split = s.Split(',');
var newHistory = new JobHistory
{
CandidateNumber = foreignKey.GetRandomCandidate(),
CompanyId = foreignKey.GetRandomCompany(),
WorkedHours = Convert.ToDouble(split[0]),
WorkedFrom = Convert.ToDateTime(split[1])
};
if (split[2] != "")
{
newHistory.WorkedTo = Convert.ToDateTime(split[2]);
}
historyList.Add(newHistory);
s = sr.ReadLine();
}
return(historyList);
}
private static IList <Opening> GetOpenings(string location)
{
var sr = new StreamReader(location);
var openings = new List <Opening>();
var foreignKey = new ForeignKeys();
string s = sr.ReadLine();
while (s != null)
{
var split = s.Split(',');
var newOpening = new Opening
{
StartingDate = Convert.ToDateTime(split[0]),
AnticipatedEndDate = Convert.ToDateTime(split[1]),
HourlyPay = Convert.ToDouble(split[2]),
QualificationId = foreignKey.GetRandomQualification(),
CompanyId = foreignKey.GetRandomCompany()
};
openings.Add(newOpening);
s = sr.ReadLine();
}
return(openings);
}
