public Candidate GetCandidate(int id) { using (var context = new CandidateContext(_connectionString)) { return(context.Candidates.FirstOrDefault(x => x.Id == id)); } }
public List <Candidate> GetAll() { using (var context = new CandidateContext(_connectionString)) { return(context.Candidates.ToList()); } }
public void RefuseCandidate(int id) { using (var context = new CandidateContext(_connectionString)) { context.Database.ExecuteSqlCommand("UPDATE Candidates SET Pending = 0, Refused = 1 WHERE Id = @id", new SqlParameter("@id", id)); } }
public void Add(Candidate c) { using (var context = new CandidateContext(_connectionString)) { context.Candidates.Add(c); context.SaveChanges(); } }