public IEnumerable <Candidate> GetPendingCandidates() { using (var context = new CTContext(_conn)) { return(context.Candidates.Where(c => c.Status == 0).ToList()); } }
public int GetDeclinedAmount() { using (var context = new CTContext(_conn)) { return(GetDeclinedCandidates().Count()); } }
public int GetPendingAmount() { using (var context = new CTContext(_conn)) { return(GetPendingCandidates().Count()); } }
public Candidate GetCandidateById(int id) { using (var context = new CTContext(_conn)) { return(context.Candidates.FirstOrDefault(c => c.Id == id)); } }
public void DeclineCandidate(int id) { using (var context = new CTContext(_conn)) { var candidate = context.Candidates.FirstOrDefault(c => c.Id == id); candidate.Status = 2; context.Candidates.Update(candidate); context.SaveChanges(); } }
public void AddCandidate(Candidate c) { using (var context = new CTContext(_conn)) { var candidate = new Candidate { Name = c.Name, Email = c.Email, Number = c.Number, Notes = c.Notes, Status = 0 }; context.Candidates.Add(candidate); context.SaveChanges(); } }