public void UpdateStatus(int id, Status status) { using (var context = new Applicants_DataDataContext(_connectionstring)) { context.ExecuteCommand("UPDATE Applicants SET Status = {0} WHERE Id = {1}", status, id); } }
public IEnumerable <Applicant> GetApplicants(Status status) { using (var context = new Applicants_DataDataContext(_connectionstring)) { return(context.Applicants.Where(a => a.Status == status).ToList()); } }
public Applicant GetApplicant(int id) { using (var context = new Applicants_DataDataContext(_connectionstring)) { return(context.Applicants.FirstOrDefault(a => a.Id == id)); } }
public void Add(Applicant applicant) { using (var context = new Applicants_DataDataContext(_connectionstring)) { context.Applicants.InsertOnSubmit(applicant); context.SubmitChanges(); } }
public ApplicantCounts GetCounts() { using (var context = new Applicants_DataDataContext(_connectionstring)) { return(new ApplicantCounts { Confirmed = context.Applicants.Count(a => a.Status == Status.Confirmed), Pending = context.Applicants.Count(a => a.Status == Status.Pending), Refused = context.Applicants.Count(a => a.Status == Status.Refused) }); } }