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