public ICollection <API.Resource.Vendor> getVendors(int productID) { DB.Models.Product product = _context.Product.Include(p => p.VendorProduct).ThenInclude(vp => vp.Vendor).Where(p => p.ID == productID).SingleOrDefault(); if (product == null) { return(null); } ; ICollection <DB.Models.Vendor> vendors = product.VendorProduct.Select(vp => vp.Vendor).ToList(); return(mapper.Map <ICollection <API.Resource.Vendor> >(vendors)); }
public int setType(int productID, Resource.ProductType type) { DB.Models.ProductType dbProductType = mapper.Map <DB.Models.ProductType>(type); DB.Models.Product product = _context.Product.Where(p => p.ID == productID).SingleOrDefault(); if (product == null) { return(0); } _context.Attach(dbProductType); product.ProductType = dbProductType; _context.Update(product); return(_context.SaveChanges()); }
public void insertProduct(API.Resource.Product product, API.Resource.ProductType type, API.Resource.Brand brand) { DB.Models.Product insertProduct = mapper.Map <DB.Models.Product>(product); _context.Product.Add(insertProduct); if (type != null && type.ID == 0) { _context.ProductType.Add(mapper.Map <DB.Models.ProductType>(type)); } if (brand != null && brand.brandID == 0) { _context.Brand.Add(mapper.Map <DB.Models.Brand>(brand)); } }
public void Handle(CreateProductCommand command) { var productId = Guid.NewGuid(); var productToCreate = new DB.Models.Product { Id = productId, BrandName = command.BrandName, Name = command.Name, Count = command.Count, Price = command.Price }; productRepository.Create(productToCreate); }
public void Create(ProductCreateDTO productCreateDTO) { var productId = Guid.NewGuid(); var productToCreate = new DB.Models.Product { Id = productId, BrandName = productCreateDTO.BrandName, Name = productCreateDTO.Name, Count = productCreateDTO.Count, Price = productCreateDTO.Price }; productRepository.Create(productToCreate); }
public void Handle(object command) { CreateProductCommand commandToExecute = (CreateProductCommand)command; var productId = Guid.NewGuid(); var productToCreate = new DB.Models.Product { Id = productId, BrandName = commandToExecute.BrandName, Name = commandToExecute.Name, Count = commandToExecute.Count, Price = commandToExecute.Price }; productRepository.Create(productToCreate); }
public API.Resource.Product createProduct(API.Resource.Product newProduct) { DB.Models.Product dbProduct = mapper.Map <DB.Models.Product>(newProduct); dbProduct.Created = DateTime.Now; dbProduct.LastModified = DateTime.Now; _context.Product.Add(dbProduct); _context.SaveChanges(); DB.Models.Product savedProduct = _context.Product.Where(p => p.SKU == newProduct.SKU).SingleOrDefault(); if (savedProduct == null) { return(null); } return(mapper.Map <API.Resource.Product>(savedProduct)); }
public ICollection <Resource.Product> getRelatedProducts(int id, int results, int page) { DB.Models.Product product = _context.Product.Include(p => p.RelatedProduct).ThenInclude(p => p.Product).Where(p => p.ID == id).SingleOrDefault(); if (product == null) { return(null); } ; IEnumerable <DB.Models.Product> relatedProducts = product.RelatedProduct.Select(p => p.Product); if (relatedProducts.Count() == 0) { return(null); } ICollection <DB.Models.Product> Products = relatedProducts.ToList(); return(mapper.Map <ICollection <API.Resource.Product> >(Products)); }
public ICollection <API.Resource.ProductAttribute> getAttributes(int productID) { List <API.Resource.ProductAttribute> attributes = new List <Resource.ProductAttribute>(); DB.Models.Product product = _context.Product.Include(p => p.ProductAttributeOption) .ThenInclude(p => p.AttributeOption).ThenInclude(ap => ap.Attribute).ThenInclude(at => at.AttributeType) .Include(p => p.ProductAttributeValue).ThenInclude(p => p.Attribute).ThenInclude(at => at.AttributeType).Where(p => p.ID == productID).SingleOrDefault(); if (product == null) { return(attributes); } ; foreach (DB.Models.ProductAttributeValue pod in product.ProductAttributeValue) { attributes.Add(mapper.Map <API.Resource.ProductAttribute>(pod)); } foreach (DB.Models.ProductAttributeOption pod in product.ProductAttributeOption) { attributes.Add(mapper.Map <API.Resource.ProductAttribute>(pod)); } return(attributes); }
public API.Resource.Product getProductByID(int productID) { IQueryable <DB.Models.Product> productQuery = _context.Product .Include(p => p.Brand) .Include(p => p.ChannelProduct) .ThenInclude(cp => cp.Channel) .Include(p => p.ProductType) .Include(p => p.RelatedProduct) .Include(p => p.RelatedProductNavigation) .Include(p => p.VendorProduct) .ThenInclude(vp => vp.Vendor) .Include(p => p.ProductAttributeOption) .ThenInclude(pao => pao.AttributeOption) .ThenInclude(pao => pao.Attribute) .ThenInclude(pao => pao.AttributeType) .Include(p => p.ProductAttributeValue) .ThenInclude(pao => pao.Attribute) .ThenInclude(pao => pao.AttributeType) .Include(p => p.ParentProduct) .Where <DB.Models.Product>(dbProduct => dbProduct.ID == productID); DB.Models.Product product = productQuery.FirstOrDefault(); return(product != null?mapper.Map <DB.Models.Product, API.Resource.Product>(product) : null); }
public void deleteProduct(int productID) { DB.Models.Product tbd = _context.Product.Where <DB.Models.Product>(product => product.ID == productID).Single(); _context.Product.Remove(tbd); }