protected void Page_Load(object sender, EventArgs e)
{
GoodEatsFarmDataContext db = new GoodEatsFarmDataContext();
Guid catID = new Guid("b6385b44-1b6d-41ab-81df-d265d363dea7");
var data = db.uspProductsGetbyCat("e4db916e-5427-42d0-8a94-6ced86bedabe").ToArray();
int rows = data.Length;
for (int i = 0; i < rows; i++)
{
Image picture = new Image();
picture.ID = "picture" + i;
//picture.Width = 306;
//picture.Height = 204;
picture.Attributes.Add("class", "productImage");
TableRow row = new TableRow();
TableCell cellOne = new TableCell();
TableCell cellTwo = new TableCell();
string prodID = data[i].ProductID.ToString();
string prodName = data[i].Name;
string prodPriceInfo = data[i].PriceInfo;
string prodDesc = data[i].Description;
picture.ImageUrl = data[i].ImagePath;
cellOne.Controls.Add(picture);
cellTwo.Text = "<p class=\"content-words\"><b>" + prodName + "</b><br />" + prodPriceInfo + "<br />" + prodDesc + "</p>";
cellTwo.HorizontalAlign = HorizontalAlign.Left;
//cellOne.Width = 320;
row.Cells.Add(cellOne);
row.Cells.Add(cellTwo);
Table1.Rows.Add(row);
}
}
protected void chkbxCategory2_SelectedIndexChanged(object sender, EventArgs e)
{
prodViewCat = chkbxCategory2.SelectedValue;
if (prodViewCat != "" && prodViewCat != "none")
{
GoodEatsFarmDataContext db = new GoodEatsFarmDataContext();
var prodData = db.uspProductsGetbyCat(prodViewCat);
gvProducts.DataSource = prodData;
gvProducts.DataBind();
}
}
protected void ddlCategory2_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCategory2.SelectedValue != "67a6ec19-a89b-43c9-8b69-a6711673c77e")
{
chkbxCategory2.Visible = false;
prodViewCat = ddlCategory2.SelectedValue;
}
else
{
chkbxCategory2.Visible = true;
}
if (prodViewCat != "" && prodViewCat != "none")
{
GoodEatsFarmDataContext db = new GoodEatsFarmDataContext();
var prodData = db.uspProductsGetbyCat(prodViewCat);
gvProducts.DataSource = prodData;
gvProducts.DataBind();
}
}