public List <Offer> GetOffers(OffersRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_Offers", conn); AddInParameter(commandWrapper, "@TeamId", DbType.Int16, request.TeamId); AddInParameter(commandWrapper, "@Role", DbType.Int16, request.Role); IDataReader reader = null; List <Offer> tmp = new List <Offer>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillOffers(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_Offers"); return(tmp); } finally { if (reader != null) { reader.Close(); } commandWrapper.Dispose(); conn.Close(); } }
public OffersResponse GetOffers(OffersRequest request) { var response = new OffersResponse { ResponseStatus = ResponseStatus.Success }; var offersProvider = new OffersProvider(); try { if (request.ActionType == ActionType.Select) { response.Offers = offersProvider.GetOffers(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public async Task <IEnumerable <Offer> > GetAllOffersAsync(OffersRequest request) { var result = await context.Offers .Where(o => o.Lat >= request.LatMin && o.Lat <= request.LatMax) .Where(o => o.Lng >= request.LngMin && o.Lng <= request.LngMax) .ToListAsync(); var mapped = mapper.Map <IEnumerable <Offer> >(result); return(mapped); }
public OffersRequest GetOffersRequest(int id, Role role) { var request = new OffersRequest { Role = role, TeamId = id, ActionType = Requests.ActionType.Select }; return(request); }
public OffersResult GetOffers(OffersRequest request) { if (request == null) { throw new ArgumentNullException("request"); } OffersResult apiResult = new OffersResult(); try { var webRequest = CreateWebRequest(); if (!String.IsNullOrWhiteSpace(request.display)) { webRequest.AddParameter("display", request.display); } if (!String.IsNullOrWhiteSpace(request.name)) { webRequest.AddParameter("name", request.name); } if (!String.IsNullOrWhiteSpace(request.name_exact)) { webRequest.AddParameter("name.exact", request.name_exact); } webRequest.AddParameter("page", request.page.ToString()); webRequest.AddParameter("page.size", request.page_size.ToString()); var resource = String.Format("/ws/seller/{0}/catalog/offers", GetSellerId()); using (var webResponse = webRequest.GET(resource)) { apiResult.StatusCode = webResponse.StatusCode; if (webResponse.StatusCode != HttpStatusCode.OK) { apiResult.Error = GetError(webResponse); } using (var stream = new StreamReader(webResponse.GetResponseStream())) { apiResult.Offers = JsonConvert.DeserializeObject <List <Offer> >(stream.ReadToEnd()); } } } catch (Exception exception) { apiResult = ThreatException(exception, apiResult); } return(apiResult); }
public async Task <IActionResult> Get([FromQuery] OffersRequest request) { var result = await queries.GetAllOffersAsync(request); return(Ok(result)); }