public void SetDeclinedStatus(int id) { using (var context = new CandidatesDataContext(_connectionString)) { context.ExecuteCommand("UPDATE Candidates SET Status = 2 WHERE Id = {0}", id); } }
public int GetDeclinedCount() { using (var context = new CandidatesDataContext(_connectionString)) { return(context.Candidates.Where(c => c.Status == CandidateTracker.Data.Status.Declined).Count()); } }
public IEnumerable <Candidate> GetDeclined() { using (var context = new CandidatesDataContext(_connectionString)) { return(context.Candidates.Where(c => c.Status == CandidateTracker.Data.Status.Declined).ToList()); } }
public Candidate ViewCandidateDetails(int id) { using (var context = new CandidatesDataContext(_connectionString)) { return(context.Candidates.FirstOrDefault(p => p.Id == id)); } }
public void AddCandidate(Candidate candidate) { using (var context = new CandidatesDataContext(_connectionString)) { context.Candidates.InsertOnSubmit(candidate); context.SubmitChanges(); } }