public HttpResponseMessage GetByCategoryIdAndRadiusAndDesignation([FromUri] ProductByCategoryRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemsResponse <SupplierDomain> response = new ItemsResponse <SupplierDomain>(); response.Items = _CompanyService.GetByCategoryIdAndRadiusAndDesignation(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public async Task <List <ProductModel> > GetProductsByCategoryId(string categoryId, int pageIndex, int pageSize = GlobalSettings.AppConst.PageSize) { var builder = new UriBuilder(GlobalSettings.WooCommerceProductByCategoryEndpoint); var request = new ProductByCategoryRequest() { Category = categoryId, Page = pageIndex, PageSize = pageSize }; var queryParams = request.GetQueryString(); builder.Query = queryParams; var uri = builder.ToString(); return(await _requestService.GetAsync <List <ProductModel> >(uri)); }
// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public List <SupplierDomain> GetByCategoryIdAndRadiusAndDesignation(ProductByCategoryRequest model) { List <SupplierDomain> companyList = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.Suppliers_GetByCategoryIdAndRadiusAndDesignation" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@CategoryId", model.CategoryId); paramCollection.AddWithValue("@latpoint", model.Latitude); paramCollection.AddWithValue("@lngpoint", model.Longitude); paramCollection.AddWithValue("@radius", model.Radius); paramCollection.AddWithValue("@designations", model.Designations); } , map : delegate(IDataReader reader, short set) { SupplierDomain singleCompany = new SupplierDomain(); int startingIndex = 0; //startingOrdinal singleCompany.CompanyName = reader.GetSafeString(startingIndex++); singleCompany.Designations = reader.GetSafeInt32(startingIndex++); singleCompany.URL = reader.GetSafeString(startingIndex++); singleCompany.Email = reader.GetSafeString(startingIndex++); singleCompany.MediaUrl = reader.GetSafeString(startingIndex++); singleCompany.Phone = reader.GetSafeString(startingIndex++); singleCompany.CompanyId = reader.GetSafeInt32(startingIndex++); singleCompany.ProductName = reader.GetSafeString(startingIndex++); singleCompany.Category = reader.GetSafeString(startingIndex++); singleCompany.ProductDescription = reader.GetSafeString(startingIndex++); singleCompany.Cost = reader.GetSafeDecimal(startingIndex++); singleCompany.Quantity = reader.GetSafeInt32(startingIndex++); singleCompany.Threshold = reader.GetSafeInt32(startingIndex++); singleCompany.MinPurchase = reader.GetSafeInt32(startingIndex++); singleCompany.ProductMediaId = reader.GetSafeInt32(startingIndex++); singleCompany.CategoryId = reader.GetSafeInt32(startingIndex++); singleCompany.Latitude = reader.GetSafeDecimal(startingIndex++); singleCompany.Longitude = reader.GetSafeDecimal(startingIndex++); singleCompany.Address1 = reader.GetSafeString(startingIndex++); singleCompany.City = reader.GetSafeString(startingIndex++); singleCompany.State = reader.GetSafeString(startingIndex++); singleCompany.ZipCode = reader.GetSafeString(startingIndex++); singleCompany.distance_in_mi = (decimal)reader.GetSafeDouble(startingIndex++); if (companyList == null) { companyList = new List <SupplierDomain>(); } companyList.Add(singleCompany); } ); } catch (Exception ex) { throw ex; } return(companyList); }