public List <ProductDataAccessResponse> GetCatalogSearchBar(GetSearchBarRequest request) { List <ProductDataAccessResponse> _dataAccessResponse = new List <ProductDataAccessResponse>(); try { MASFARMACIADEVContext context = new MASFARMACIADEVContext(); var query = from p in context.ProductsEntity join m in context.MarcasEntity on p.IdMarca equals m.IdMarca join path in context.ResourcesEntity on p.IdResoruce equals path.IdResource join cat in context.CategorysEntity on p.IdCategory equals cat.IdCategory join subcat in context.SubCategorysEntity on p.IdSubCategory equals subcat.IdSubCategory where (m.Description.Contains(request.SearchBarText) || p.Description.Contains(request.SearchBarText)) && p.Stock > 0 select new { ProductDataAccessResponse = new ProductDataAccessResponse { ProductCard = new ProductCardResponse { IdProduct = p.IdProduct, Name = p.Name, Marca = m.Description, Price = p.Price, Path = path.Path }, CategoryUsed = new CategorysEntity { IdCategory = p.IdCategory, Description = cat.Description }, SubCategoryUsed = new SubCategorysEntity { IdSubCategory = p.IdSubCategory, Description = subcat.Description, IdCategory = subcat.IdCategory }, MarcaUsed = new MarcasEntity { IdMarca = m.IdMarca, Description = m.Description } } }; if (query != null) { foreach (var obj in query) { _dataAccessResponse.Add(obj.ProductDataAccessResponse); } } } catch (Exception ex) { Console.WriteLine("ProductDataAccess.GetCatalogSearchBar : ERROR : " + ex.Message); throw; } return(_dataAccessResponse); }
public GetCatalogResponse GetCatalogSearchBar(GetSearchBarRequest request) { var getCatalogResponse = new GetCatalogResponse(); try { var _dataAccessResponse = _productDataAccess.GetCatalogSearchBar(request); if (_dataAccessResponse != null) { getCatalogResponse = _productHelper.CreateList(_dataAccessResponse); } } catch (Exception ex) { Console.WriteLine("ProductModel.GetCatalogSearchBar : ERROR : " + ex.Message); throw; } return(getCatalogResponse); }
public List <ProductDataAccessResponse> GetCatalogSearchBar(GetSearchBarRequest request) { var _dataAccessResponse = new List <ProductDataAccessResponse>(); try { var query = from p in context.ProductsEntity join m in context.MarcasEntity on p.IdMarca equals m.IdMarca join cat in context.CategorysEntity on p.IdCategory equals cat.IdCategory join subcat in context.SubCategorysEntity on p.IdSubCategory equals subcat.IdSubCategory where (m.Description.Contains(request.SearchBarText) || p.Description.Contains(request.SearchBarText)) && p.Stock > 0 select new { ProductDataAccessResponse = new ProductDataAccessResponse { ProductEntity = new GetProductResponse { IdProduct = p.IdProduct, Description = p.Description, Name = p.Name, IdMarca = p.IdMarca, Marca = m.Description, Price = p.Price, Stock = p.Stock, IdCategory = p.IdCategory, Category = cat.Description, IdSubCategory = p.IdSubCategory, SubCategory = subcat.Description, EAN = p.EAN, ImgCount = p.ImgCount }, CategoryUsed = new CategorysEntity { IdCategory = p.IdCategory, Description = cat.Description }, SubCategoryUsed = new SubCategorysEntity { IdSubCategory = p.IdSubCategory, Description = subcat.Description, IdCategory = subcat.IdCategory }, MarcaUsed = new MarcasEntity { IdMarca = p.IdMarca, Description = m.Description } } }; if (query != null) { foreach (var obj in query) { _dataAccessResponse.Add(obj.ProductDataAccessResponse); } } } catch (Exception ex) { Console.WriteLine("ProductDataAccess.GetCatalogSearchBar : ERROR : " + ex.Message); throw; } return(_dataAccessResponse); }