public void AddCandidate(Candidate candidate) { var ctx = new CandidateDbContext(_connectionString); ctx.Candidates.Add(candidate); ctx.SaveChanges(); }
public void UpdateCandidate(Candidate candidate) { var ctx = new CandidateDbContext(_connectionString); ctx.Candidates.Attach(candidate); ctx.Entry(candidate).State = EntityState.Modified; ctx.SaveChanges(); }
public List <int> getCounts() { var ctx = new CandidateDbContext(_connectionString); var counts = new List <int>(); counts.Add(ctx.Candidates.Where(c => c.Status == Status.Pending).Count()); counts.Add(ctx.Candidates.Where(c => c.Status == Status.Confirmed).Count()); counts.Add(ctx.Candidates.Where(c => c.Status == Status.Refused).Count()); return(counts); }
public Candidate GetCandidate(int id) { var ctx = new CandidateDbContext(_connectionString); return(ctx.Candidates.FirstOrDefault(c => c.Id == id)); }
public List <Candidate> GetCandidates(Status status) { var ctx = new CandidateDbContext(_connectionString); return(ctx.Candidates.Where(c => c.Status == status).ToList()); }