public void SetDeclinedStatus(int id)
 {
     using (var context = new CandidatesDataContext(_connectionString))
     {
         context.ExecuteCommand("UPDATE Candidates SET Status = 2  WHERE Id = {0}", id);
     }
 }