protected void Page_Load(object sender, EventArgs e)
{
SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter prodTA = new SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter();
//IEnumerator<SimplicityCommLib.DataSets.Common.Products.ProductsRow> ieProducts = .GetEnumerator();
rptProds.DataSource = prodTA.GetAllProducts();
rptProds.DataBind();
if (Request[WebConstants.Request.PRODUCT_ID] != null)
{
int productId = int.Parse(Request[WebConstants.Request.PRODUCT_ID]);
ProductsTableAdapters.ProductVideoTableAdapter videoTA = new ProductsTableAdapters.ProductVideoTableAdapter();
rptVideos.DataSource = videoTA.GetVideosByProduct(productId);
rptVideos.DataBind();
lblContent.Visible = false;
SimplicityCommLib.DataSets.Common.Products.ProductsRow product = DatabaseUtility.Instance.GetProduct(productId);
if(product != null)
{
lblProdName.Text = product.Name;
lblProdName.Visible = true;
}
}
else
{
lblContent.Visible = true;
lblProdName.Visible = false;
}
}
public SimplicityCommLib.DataSets.Common.Products.ProductsRow GetProduct(int productId)
{
SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter prodTA = new SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter();
IEnumerator<SimplicityCommLib.DataSets.Common.Products.ProductsRow> ieProducts = prodTA.GetProductById(productId).GetEnumerator();
if (ieProducts.MoveNext())
{
return ieProducts.Current;
}
return null;
}
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;
}
}