public static Product LoadCompleteProduct(int productId) { SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter prodTA = new SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter(); SimplicityCommLib.DataSets.Common.Products.ProductsRow productDS = DatabaseUtility.Instance.GetProduct(productId); if (productDS != null) { Product product = new Product(); product.ProductDS = productDS; ProductsTableAdapters.ProductDetailTableAdapter detailTA = new ProductsTableAdapters.ProductDetailTableAdapter(); IEnumerator<Products.ProductDetailEntityRow> details = detailTA.GetDetailsByProduct(productId).GetEnumerator(); double totalPrice = 0; while (details.MoveNext()) { if (details.Current.mandatory) { product.mandatoryDetails.Add(details.Current); totalPrice += details.Current.price; } else { product.optionalDetails.Add(details.Current); } } ProductsTableAdapters.ProductVersionTableAdapter versionTA = new ProductsTableAdapters.ProductVersionTableAdapter(); IEnumerator<Products.ProductVersionEntityRow> versions = versionTA.GetVersionByProduct(productId).GetEnumerator(); while (versions.MoveNext()) { product.versions.Add(versions.Current); } return product; } else { return null; } }
public static Products.ProductVersionEntityRow GetVersion(int versionId) { Products.ProductVersionEntityRow version = null; ProductsTableAdapters.ProductVersionTableAdapter ta = new ProductsTableAdapters.ProductVersionTableAdapter(); IEnumerator<Products.ProductVersionEntityRow> versions = ta.GetVersionById(versionId).GetEnumerator(); if (versions.MoveNext()) { version = versions.Current; } return version; }