public int getConfirmedCount() { using (var context = new CandidateDBDataContext(_connectionString)) { return(context.CandidateDBs.Where(c => c.status == true).Count());; } }
public int getPendingCount() { using (var context = new CandidateDBDataContext(_connectionString)) { return(context.CandidateDBs.Where(c => c.status == null).Count());; } }
public void UpdateCandidate(int Id, bool action) { using (var context = new CandidateDBDataContext(_connectionString)) { context.ExecuteCommand("UPDATE CandidateDB SET status = {0} WHERE Id = {1}", action, Id); } }
public void AddCandidate(CandidateDB person) { using (var context = new CandidateDBDataContext(_connectionString)) { context.CandidateDBs.InsertOnSubmit(person); context.SubmitChanges(); } }
public IEnumerable <CandidateDB> getAllCandidate(string action) { using (var context = new CandidateDBDataContext(_connectionString)) { if (action == "Pending") { return(context.CandidateDBs.Where(c => c.status == null).ToList()); } else if (action == "Refused") { return(context.CandidateDBs.Where(c => c.status == false).ToList()); } else { return(context.CandidateDBs.Where(c => c.status == true).ToList()); } } }