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()); }