public void Refuse(int candidateId)
{
using (var context = new CandidateDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Candidates SET Status = 2 WHERE Id={0}", candidateId);
}
}
public int GetNumPending()
{
using (var context = new CandidateDataContext(_connectionString))
{
return(context.Candidates.ToList().Where(c => c.Status == 0).Count());
}
}
public Candidate GetCandidateById(int id)
{
using (var context = new CandidateDataContext(_connectionString))
{
return(context.Candidates.ToList().FirstOrDefault(c => c.Id == id));
}
}
public IEnumerable <Candidate> GetRefusedCandidates()
{
using (var context = new CandidateDataContext(_connectionString))
{
return(context.Candidates.ToList().Where(c => c.Status == Status.Refused));
}
}
public void AddCandidate(Candidate c)
{
using (var context = new CandidateDataContext(_connectionString))
{
context.Candidates.InsertOnSubmit(c);
context.SubmitChanges();
}
}
public StatusCounts GetCounts()
{
using (var context = new CandidateDataContext(_connectionString))
{
var counts = new StatusCounts
{
Pending = context.Candidates.ToList().Where(c => c.Status == Status.Pending).Count(),
Refused = context.Candidates.ToList().Where(c => c.Status == Status.Refused).Count(),
Confirmed = context.Candidates.ToList().Where(c => c.Status == Status.Confirmed).Count(),
};
return(counts);
}
}
