public IList <FuelStation> Search(SimpleSearchRequest filter)
{
_listResult = null;
try
{
Connection.Open();
_listResult = _fuelStationDa.Search(filter);
}
finally
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
}
return(_listResult);
}
public Response Search(SimpleSearchRequest request)
{
try
{
_listResult = _repository.Search(request);
var numberItems = _listResult.Count;
if (numberItems == 0)
{
_response = new Response
{
IsSuccess = true,
NumberItems = numberItems,
//Obsolete = _listResult,
StatusResponse = new StatusResponse
{
Status = 404,
Message = Default.LblHttpStatusCode404,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
return(_response);
}
_response = new Response
{
IsSuccess = true,
NumberItems = numberItems,
//Obsolete = request.SortedBy.HasValue ? Sorting.Sort(_listResult, request.SortedBy.Value) : _listResult,
StatusResponse = new StatusResponse
{
Status = 200,
Message = Default.LblHttpStatusCode200
}
};
}
catch (Exception exception)
{
var exceptionLog = new ExceptionLog
{
ApplicationName = $"{ConfigurationManager.AppSettings["SolutionName"]} - {ConfigurationManager.AppSettings["UserFuelServices"]}",
Message = exception.Message
};
var exceptionRepository = new ExceptionLogRepository("MetadataConnection");
var exceptionId = exceptionRepository.Add(exceptionLog);
_response = new Response
{
IsSuccess = false,
//Obsolete = null,
StatusResponse = new StatusResponse
{
Status = 500,
Message = Default.LblHttpStatusCode500,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
}
return(_response);
}
internal IList <FuelStation> Search(SimpleSearchRequest filter)
{
Command = new SqlCommand
{
Connection = (SqlConnection)Connection,
CommandType = CommandType.StoredProcedure,
CommandText = "Operation.SearchCityStateZipCodeSimple"
};
if (!string.IsNullOrEmpty(filter.City))
{
var paramOpc = new SqlParameter
{
ParameterName = "@City",
DbType = DbType.String,
Value = filter.City
};
Command.Parameters.Add(paramOpc);
}
if (!string.IsNullOrEmpty(filter.State))
{
var paramOpc = new SqlParameter
{
ParameterName = "@State",
DbType = DbType.String,
Value = filter.State
};
Command.Parameters.Add(paramOpc);
}
if (!string.IsNullOrEmpty(filter.ZipCode))
{
var paramOpc = new SqlParameter
{
ParameterName = "@ZipCode",
DbType = DbType.String,
Value = filter.ZipCode
};
Command.Parameters.Add(paramOpc);
}
var param = new SqlParameter
{
ParameterName = "@Product",
DbType = DbType.String,
Value = filter.ProductName
};
Command.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@SupplierID",
DbType = DbType.String,
Value = filter.SupplierId
};
Command.Parameters.Add(param);
Populate((SqlDataReader)Command.ExecuteReader());
return(_listResult);
}
public Response Get(SimpleSearchRequest request)
{
return(_fuelStationBr.Search(request));
}
