public void AddCandidate(Candidate candidate) { var dbcontext = new SQLAzureDemo.AramPerformanceTestDBEntities(); dbcontext.Candidates.Add(candidate); dbcontext.SaveChanges(); }
public List <Candidate> GetCandidatesList(int pageSize) { var dbcontext = new SQLAzureDemo.AramPerformanceTestDBEntities(); return(dbcontext.Candidates.Take(pageSize).ToList()); }
public List <Candidate> GetCandidatesByName(string candidateName) { var dbcontext = new SQLAzureDemo.AramPerformanceTestDBEntities(); return(dbcontext.Candidates.Where(m => m.FirstName == candidateName).Take(50).ToList()); }
public List <Candidate> GetCandidateById(int candidateId) { var dbcontext = new SQLAzureDemo.AramPerformanceTestDBEntities(); return(dbcontext.Candidates.Where(m => m.CandidateId == candidateId).ToList()); }
public long GetLastCandidateId() { var dbcontext = new SQLAzureDemo.AramPerformanceTestDBEntities(); return(dbcontext.Candidates.Max(m => m.CandidateId)); }