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