public void AddCandidate(Candidate candidate)
{
var ctx = new CandidateDbContext(_connectionString);
ctx.Candidates.Add(candidate);
ctx.SaveChanges();
}
public void Refuse(int id)
{
var ctx = new CandidateDbContext(_connectionString);
ctx.Database.ExecuteSqlInterpolated($"update candidates set status = {Status.Refused} where id = {id}");
}
public Candidate GetById(int id)
{
var ctx = new CandidateDbContext(_connectionString);
return(ctx.Candidates.FirstOrDefault(c => c.Id == id));
}
public List <Candidate> GetRefusedCandidates()
{
var ctx = new CandidateDbContext(_connectionString);
return(ctx.Candidates.Where(c => c.Status == Status.Refused).ToList());
}
