public IHttpActionResult Get(string lastName = null, string firstName = null, int?departmentID = null, int?subDepartmentID = null) { TestDBEntities _entity = new TestDBEntities(); return(Ok(_entity.SelectEmployee(lastName, firstName, departmentID, subDepartmentID))); }
public ActionResult Index(string lastName = null, string firstName = null, int?departmentID = null, int?subDepartmentID = null) { lastName = (lastName == null || lastName.Trim() == "") ? null : lastName.Trim(); firstName = (firstName == null || firstName.Trim() == "") ? null : firstName.Trim(); TestDBEntities _entity = new TestDBEntities(); ViewData["deptList"] = new SelectList(_entity.Departments.ToList(), "DepartmentID", "DepartmentName"); ViewData["subDeptList"] = new SelectList(_entity.SubDepartments.ToList(), "SubDepartmentID", "SubDepartmentName"); return(View(_entity.SelectEmployee(lastName, firstName, departmentID, subDepartmentID))); }