internal IList <FuelStation> GetCityState(CityStateRequest filter) { Command = new SqlCommand { Connection = (SqlConnection)Connection, CommandType = CommandType.StoredProcedure, CommandText = "Operation.GetCityState" }; var param = new SqlParameter { ParameterName = "@SupplierID", DbType = DbType.Int32, Value = filter.SupplierId }; Command.Parameters.Add(param); 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); } Populate((SqlDataReader)Command.ExecuteReader()); return(_listResult); }
public IList <FuelStation> GetCityState(CityStateRequest filter) { _listResult = null; try { Connection.Open(); _listResult = _fuelStationDa.GetCityState(filter); } finally { if (Connection.State == ConnectionState.Open) { Connection.Close(); } } return(_listResult); }
public Response Get(CityStateRequest request) { return(_fuelStationBr.GetCityState(request)); }
public Response GetCityState(CityStateRequest request) { try { _listResult = _repository.GetCityState(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, Timestamp = DateTimeOperations.FormatTimeStamp() } }; } 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); }