public static List <Person> GetFilteredData(string firstName, string lastName, string office, string department, bool active) { IQueryable <Person> oDataQuery = StaticCache.GetEmployees().AsQueryable(); if (firstName.Trim().Length > 0) { oDataQuery = oDataQuery.Where(a => a.FirstName.StartsWith(firstName, true, CultureInfo.InvariantCulture)); } if (lastName.Trim().Length > 0) { oDataQuery = oDataQuery.Where(a => a.LastName.StartsWith(lastName, true, CultureInfo.InvariantCulture)); } if (office.Trim().Length > 0) { oDataQuery = oDataQuery.Where(a => a.Office.Id.ToString().Equals(office.ToString())); } if (department.Trim().Length > 0) { oDataQuery = oDataQuery.Where(a => a.Department.Id.ToString().Equals(department.ToString())); } return(oDataQuery.ToList()); }
public static Person FindPersonById(string Id) { List <Person> employees = StaticCache.GetEmployees(); //Person foundPerson = (Person)employees.FirstOrDefault(a => a.EmployeeNumber.Equals(Id)); return(employees.Find(a => a.EmployeeNumber.Equals(Id))); }
public static object GetPersonById(string id) { try { List <Person> employees = StaticCache.GetEmployees(); var filtered = employees.Where(x => x.EmployeeNumber.ToString() == id).ToList(); return(JsonConvert.SerializeObject(filtered, Formatting.Indented)); } catch (Exception exception) { throw new Exception(string.Format("Error Loading Instance with id {0}, Error: {1}", id, exception)); } }