public void ChangeStatus(Candidate c)
{
using var context = new CandidatesDbContext(_connectionString);
context.Candidates.Attach(c);
context.Entry(c).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
}
public CountsModel GetCounts()
{
using var context = new CandidatesDbContext(_connectionString);
return(new CountsModel()
{
Confirmed = context.Candidates.Where(c => c.Status == Status.Confirmed).Count(),
Refused = context.Candidates.Where(c => c.Status == Status.Refused).Count(),
Pending = context.Candidates.Where(c => c.Status == Status.Pending).Count()
});
}
public List <Candidate> GetCandidates(Status status)
{
using var context = new CandidatesDbContext(_connectionString);
return(context.Candidates.Where(c => c.Status == status).ToList());
}
public Candidate GetPendingCandidate(int id)
{
using var context = new CandidatesDbContext(_connectionString);
return(context.Candidates.FirstOrDefault(c => c.Id == id));
}
public void AddCandidate(Candidate c)
{
using var context = new CandidatesDbContext(_connectionString);
context.Candidates.Add(c);
context.SaveChanges();
}