public int GetPendingCount()
{
using (var context = new CandidateContext(_connectionString))
{
return(context.Candidates.Where(i => i.Confirmed == null).ToList().Count());
}
}
public Candidate GetCandidate(int id)
{
using (var context = new CandidateContext(_connectionString))
{
return(context.Candidates.FirstOrDefault(i => i.Id == id));
}
}
public IEnumerable <Candidate> GetPending()
{
using (var context = new CandidateContext(_connectionString))
{
return(context.Candidates.Where(i => i.Confirmed == null).ToList());
}
}
public int GetDeclinedCount()
{
using (var context = new CandidateContext(_connectionString))
{
return(context.Candidates.Where(i => i.Confirmed == false).ToList().Count());
}
}
public int GetConfirmedCount()
{
using (var context = new CandidateContext(_connectionString))
{
return(context.Candidates.Count(i => i.Confirmed == true));
}
}
public void AddCandidate(Candidate c)
{
using (var context = new CandidateContext(_connectionString))
{
context.Candidates.Add(c);
context.SaveChanges();
}
}
public void Decline(int id)
{
using (var context = new CandidateContext(_connectionString))
{
Candidate i = context.Candidates.FirstOrDefault(p => p.Id == id);
i.Confirmed = false;
context.Entry(i).State = EntityState.Modified;
context.SaveChanges();
}
}
