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