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