public List <FoodTruckCompany> SearchFoodTruckCompany(FoodTruckCompanySearchCriteria criteria) { if (_authenticatedUser.Role != UserRoleEnum.Admin) { throw new AuthenticationException("Invalid Role"); } return(_foodTruckCompanySqlAccess.SearchFoodTruckCompany(criteria)); }
public List <FoodTruckCompany> SearchFoodTruckCompany(FoodTruckCompanySearchCriteria criteria) { var result = new List <FoodTruckCompany>(); using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString())) { var spName = "SearchFoodTruckCompanies"; using (var cmd = new SqlCommand(spName, sqlConn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BusinessName", criteria.BusinessName); cmd.Parameters.AddWithValue("@Zipcode", criteria.Zipcode); cmd.Parameters.AddWithValue("@City", criteria.City); if (criteria.Latitude != 0) { cmd.Parameters.AddWithValue("@Latitude", criteria.Latitude); } if (criteria.Longitude != 0) { cmd.Parameters.AddWithValue("@Longiture", criteria.Longitude); } if (criteria.Radius != 0) { cmd.Parameters.AddWithValue("@Radius", criteria.Radius); } sqlConn.Open(); var reader = cmd.ExecuteReader(); while (reader.HasRows) { var ftcItem = new FoodTruckCompany(); ReadFoodTrackCompanyInfoFromReader(ftcItem, reader); result.Add(ftcItem); } } } return(result); }
public IActionResult Search(FoodTruckCompanySearchCriteria criteria) { var searchResult = _businessLayer.SearchFoodTruckCompany(criteria); return(Ok(searchResult)); }