/// <summary>
/// Gets all the candidates from the database
/// </summary>
/// <returns>Returns the candidate data</returns>
internal ObservableCollection <CandidateSelection> GetCandidates()
{
List <CandidateTable> dbcandidates = new List <CandidateTable>();
dbcandidates = this.db.Query <CandidateTable>("SELECT * FROM CandidateTable");
ObservableCollection <CandidateSelection> candidates = new ObservableCollection <CandidateSelection>();
foreach (CandidateTable item in dbcandidates)
{
CandidateSelection candidate = new CandidateSelection()
{
Id = item.Id,
ServerId = item.ServerId,
Name = item.Name,
Detail = item.Detail,
Image = item.Image,
Selected = false
};
candidates.Add(candidate);
}
return(candidates);
}
public NewPlacementModel(DataAccess.EF.Placement model, IRepository repository, OpeningModel selectedOpening, CandidateSelection selectedCandidate) : base(model)
{
_repository = repository;
ModelCopy.TotalHoursWorked = GetTotalHoursWorked(selectedOpening);
ModelCopy.CandidateId = selectedCandidate.Model.CandidateId;
ModelCopy.OpeningNumber = selectedOpening.Model.OpeningNumber;
_repository.Placement.Add(ModelCopy);
}
public NewHistoryModel(DataAccess.EF.History model, IRepository repository, OpeningModel selectedOpening, CandidateSelection selectedCandidate, NewPlacementModel selectedPlacement) : base(model)
{
_repository = repository;
ModelCopy.DateStarted = selectedOpening.Model.StartDate;
ModelCopy.DateEnded = selectedOpening.Model.EndDate;
ModelCopy.CandidateId = selectedCandidate.Model.CandidateId;
ModelCopy.PlacementId = selectedPlacement.ModelCopy.PlacementId;
ModelCopy.HistoryDescription = selectedOpening.Model.Qualification.QualificationCode;
_repository.History.Add(ModelCopy);
//var candidate = _repository.Candidate.Get(c => c.CandidateId == selectedCandidate.Model.CandidateId);
//SelectedCandidate = candidate;
}
