public IEnumerable <EmployeeViewModel> GetAllEmployeesDetail(out int count)
{
IEnumerable <EmployeeViewModel> results = null;
using (var db = new LabEmployeeDB(this.ConnectionName))
{
var selector = db.Identities
.Select(p => new EmployeeViewModel
{
Id = p.Employee.Id,
Name = p.Employee.Name,
Age = p.Employee.Age,
SequenceId = p.Employee.SequenceId,
Account = p.Account,
Password = p.Password
});
count = selector.Count();
if (count == 0)
{
return(results);
}
selector = selector.OrderBy(p => p.SequenceId);
results = selector.ToList();
}
return(results);
}
public object GetAll(out int count)
{
IEnumerable <Employee> results = null;
using (var db = new LabEmployeeDB(this.ConnectionName))
{
var selector = db.Employees.AsQueryable();
count = selector.Count();
if (count == 0)
{
return(results);
}
selector = selector.OrderBy(p => p.SequenceId);
results = selector.ToList();
}
return(results);
}
public IEnumerable <EmployeeViewModel> GetAllEmployees(out int count)
{
IEnumerable <EmployeeViewModel> results = null;
using (var db = new LabEmployeeDB(this.ConnectionName))
{
var selector = db.Employees
.Select(p => new EmployeeViewModel
{
Id = p.Id,
Name = p.Name,
Age = p.Age,
SequenceId = p.SequenceId
})
.Where(p => p.SequenceId > 0)
.OrderBy(p => p.SequenceId);
results = selector.ToList();
count = results.Count();
}
return(results);
}