public Candidate GetCandidate(int id) { using (var context = new CandidateTrackerContext(_connectionString)) { return(context.Candidates.FirstOrDefault(c => c.Id == id)); } }
public IEnumerable <Candidate> GetCandidates(Status status) { using (var context = new CandidateTrackerContext(_connectionString)) { return(context.Candidates.Where(c => c.Status == status).ToList()); } }
public void AddCandidate(Candidate candidate) { using (var context = new CandidateTrackerContext(_connectionString)) { context.Candidates.Add(candidate); context.SaveChanges(); } }
public void UpdateStatus(int candidateId, Status status) { using (var context = new CandidateTrackerContext(_connectionString)) { context.Database.ExecuteSqlCommand("UPDATE Candidates SET Status = @status WHERE Id = @id", new SqlParameter("@status", status), new SqlParameter("@id", candidateId)); } }
public CandidateCounts GetCounts() { using var context = new CandidateTrackerContext(_connectionString); return(new CandidateCounts { Confirmed = context.Candidates.Count(c => c.Status == Status.Confirmed), Pending = context.Candidates.Count(c => c.Status == Status.Pending), Refused = context.Candidates.Count(c => c.Status == Status.Refused), }); }
public void UpdateStatus(int candidateId, Status status) { using var context = new CandidateTrackerContext(_connectionString); context.Database.ExecuteSqlInterpolated( $"UPDATE Candidates SET Status = {status} WHERE Id = {candidateId}"); }
public List <Candidate> GetCandidates(Status status) { using var context = new CandidateTrackerContext(_connectionString); return(context.Candidates.Where(c => c.Status == status).ToList()); }