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