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;
}
