public Product(int id, string name, string brand, string sku, long ean, ProductType productType, Category category) { ID = id; Name = name; Brand = brand; SKU = sku; EAN = ean; ProductType = productType; Category = category; }
public Product(int id, string name, string brand, string sku, long ean, double averageReviewScore, double price, ProductType productType, Category category) { ID = id; Name = name; Brand = brand; SKU = sku; EAN = ean; AverageReviewScore = averageReviewScore; Price = price; ProductType = productType; Category = category; }
public Product(string name, string brand, string sku, long ean, ProductType productType, Category category, List<ProductPicture> productPictures, List<ProductSpecification> productSpecifications, List<UserList> userLists, List<ProductReview> reviews, List<ShopPrice> shopPrices) { Name = name; Brand = brand; SKU = sku; EAN = ean; ProductType = productType; Category = category; ProductPictures = productPictures; ProductSpecifications = productSpecifications; UserLists = userLists; Reviews = reviews; ShopPrices = shopPrices; }
/// <summary> /// Constructor for getting a Product out of the database /// </summary> /// <param name="id"></param> /// <param name="name"></param> /// <param name="brand"></param> /// <param name="sku"></param> /// <param name="ean"></param> /// <param name="averageReviewScore"></param> /// <param name="price"></param> /// <param name="productType"></param> /// <param name="category"></param> /// <param name="productPictures"></param> /// <param name="productSpecifications"></param> /// <param name="userLists"></param> /// <param name="reviews"></param> /// <param name="shopPrices"></param> public Product(int id, string name, string brand, string sku, long ean, double averageReviewScore, double price, ProductType productType, Category category, List <ProductPicture> productPictures, List <ProductSpecification> productSpecifications, List <UserList> userLists, List <ProductReview> reviews, List <ShopPrice> shopPrices) { ID = id; Name = name; Brand = brand; SKU = sku; EAN = ean; AverageReviewScore = averageReviewScore; Price = price; Category = category; ProductType = productType; ProductPictures = productPictures; ProductSpecifications = productSpecifications; UserLists = userLists; Reviews = reviews; ShopPrices = shopPrices; }
/// <summary> /// Databasemethod that returns a Product instance from a database. /// </summary> /// <param name="record"></param> /// <returns></returns> private static Product GetProductFromDataRecord(IDataRecord record) { int id = Convert.ToInt32(record["ID"]); string name = Convert.ToString(record["NAME"]); string brand = Convert.ToString(record["BRAND"]); string sku = Convert.ToString(record["SKU"]); long ean = Convert.ToInt64(record["EAN"]); double ars = GetProductAverageReviewScore(Convert.ToInt32(record["ID"])); double price = GetProductPrice(Convert.ToInt32(record["ID"])); ProductType productType = record.IsDBNull(1) ? null : ProductType.FindById(Convert.ToInt32(record["PRODUCTTYPE_ID"])); Category category = Category.FindById(Convert.ToInt32(record["CATEGORY_ID"])); List <ProductPicture> productPictures = ProductPicture.FindAllProductPicturesForProduct(id); List <ProductSpecification> productSpecifications = ProductSpecification.FindAllSpecs(id); List <UserList> userLists = UserList.AllUserListsWithProduct(id); List <ProductReview> reviews = ProductReview.AllProductReviews(id); List <ShopPrice> shopPrices = ShopPrice.AllShopPriceOfProduct(id); if (productType == null) { return(new Product(id, name, brand, sku, ean, ars, price, category, productPictures, productSpecifications, userLists, reviews, shopPrices)); } return(new Product(id, name, brand, sku, ean, ars, price, productType, category, productPictures, productSpecifications, userLists, reviews, shopPrices)); }
public Product(int id, string name, string brand, string sku, long ean, double averageReviewScore, double price, ProductType productType, Category category, List<ProductPicture> productPictures, List<ProductSpecification> productSpecifications, List<UserList> userLists, List<ProductReview> reviews, List<ShopPrice> shopPrices) { ID = id; Name = name; Brand = brand; SKU = sku; EAN = ean; AverageReviewScore = averageReviewScore; Price = price; Category = category; ProductType = productType; ProductPictures = productPictures; ProductSpecifications = productSpecifications; UserLists = userLists; Reviews = reviews; ShopPrices = shopPrices; }