internal IList <FuelStation> GetZipCode(ZipCodeRequest filter) { Command = new SqlCommand { Connection = (SqlConnection)Connection, CommandType = CommandType.StoredProcedure, CommandText = "Operation.GetZipCode" }; var param = new SqlParameter { ParameterName = "@ZipCode", DbType = DbType.String, Value = filter.ZipCode }; Command.Parameters.Add(param); param = new SqlParameter { ParameterName = "@SupplierID", DbType = DbType.Int32, Value = filter.SupplierId }; Command.Parameters.Add(param); Populate((SqlDataReader)Command.ExecuteReader()); return(_listResult); }
public MainResponse GetAllZipCodes(ZipCodeRequest request) { var zipCodes = _zipCodeRepository2.GetAll(x => x.City == request.cityname && x.StateAbbrv == request.statecode).OrderBy(x => x.ZipCode); var zipCodeResponse = _mapper.Map <List <GetZipCodes> >(zipCodes); ZipCodeResponse response = new ZipCodeResponse(); response.ZipCode = zipCodeResponse; _mainResponse.ZipCodeResponse = response; _mainResponse.Success = true; return(_mainResponse); }
public IList <FuelStation> GetZipCode(ZipCodeRequest filter) { _listResult = null; try { Connection.Open(); _listResult = _fuelStationDa.GetZipCode(filter); } finally { if (Connection.State == ConnectionState.Open) { Connection.Close(); } } return(_listResult); }
public IActionResult GetZipCodes(ZipCodeRequest request) { _mainResponse = _globalCodeService.GetAllZipCodes(request); _jsonString = Mapper.Convert <ZipCodeResponse>(_mainResponse); return(new OkObjectResult(_jsonString)); }
public Response GetZipCode(ZipCodeRequest request) { try { _listResult = _repository.GetZipCode(request); var numberItems = _listResult.Count; if (numberItems == 0) { _response = new Response { IsSuccess = true, //Obsolete = _listResult, NumberItems = numberItems, 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); }
public Response Get(ZipCodeRequest request) { return(_fuelStationBr.GetZipCode(request)); }