public IEnumerable <Candidate> GetCandidates(Status status)
{
using (var context = new CandidateTrackerDataContext())
{
return(context.Candidates.Where(c => c.Status == status).ToList());
}
}
public Candidate GetCandidate(int id)
{
using (var context = new CandidateTrackerDataContext())
{
return(context.Candidates.FirstOrDefault(c => c.Id == id));
}
}
public void UpdateStatus(int id, Status status)
{
using (var context = new CandidateTrackerDataContext())
{
context.ExecuteCommand("UPDATE Candidates SET Status = {0} where id = {1}", status, id);
context.SubmitChanges();
}
}
public void AddCandidate(Candidate candidate)
{
using (var context = new CandidateTrackerDataContext())
{
context.Candidates.InsertOnSubmit(candidate);
context.SubmitChanges();
}
}
