public ActionResult Index(EmployeesListVM employees)
{
DataAccess.NORTHWNDEntities entities = new DataAccess.NORTHWNDEntities();
var allEmployeesQry = entities.Employees.AsQueryable();
if (!string.IsNullOrEmpty(employees.SearchText))
{
allEmployeesQry = allEmployeesQry.Where(W => W.FirstName.Contains(employees.SearchText)).AsQueryable();
}
var employeeList = allEmployeesQry.Select(s => new EmployeesItemVM
{
Name = s.FirstName,
Telephone = s.HomePhone,
Tittle = s.Title,
}).ToList();
employees.Employees = employeeList;
return(View(employees));
}
public ActionResult List(CustomersVM model)
{
DataAccess.NORTHWNDEntities entities = new DataAccess.NORTHWNDEntities();
var customerQry = entities.Customers.AsQueryable();
if (!string.IsNullOrWhiteSpace(model.SearchText))
{
customerQry = customerQry.Where(w => w.ContactName.Contains(model.SearchText) || w.Phone.Contains(model.SearchText));
}
model.Customers = customerQry.Select(cust => new CustometItemVM
{
Company = cust.CompanyName,
Address = cust.Address + " " + cust.City + " " + cust.Country,
Phone = cust.Phone,
CustomerName = cust.ContactName
}).ToList();
return(View(model));
}
