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));
}
