public void DeleteProduct(int id) { NonResultQuerry(ProductSql.DeleteProduct(id)); }
public void InsertProduct(ProductDto product) { NonResultQuerry(ProductSql.InsertProduct(product)); }
public void UpdateProduct(ProductDto product) { NonResultQuerry(ProductSql.UpdateProduct(product)); }
public ProductDto GetProductById(int productId) { return(QueryForObject <ProductDto>(ProductSql.GetProductById(productId))); }
public IEnumerable <ProductDto> GetAllProducts() { return(QuerryForList <ProductDto>(ProductSql.GetAllProducts())); }
public IEnumerable <ProductDto> GetAllActiveProductsWithStatus(int statusId) { return(QuerryForList <ProductDto>(ProductSql.GetProductByStatus(statusId))); }
public IEnumerable <ProductDto> GetAllActiveProductsForZones(List <ZoneDto> zones) { return(QuerryForList <ProductDto>(ProductSql.GetProductByZones(string.Join(",", zones.Select(x => x.Id.ToString()))))); }
public IEnumerable <ProductSearchTypeDto> GetAllActiveProductSearches() { return(QuerryForList <ProductSearchTypeDto>(ProductSql.GetAllActiveProductSearches())); }