private void LoadProductList()
{
gvproductlist.Rows.Clear();
CafeteriaAndRestaurantEntities contextDB = new CafeteriaAndRestaurantEntities();
var list = from product in contextDB.Products
from producttype in contextDB.ProductFroms
from category in contextDB.Categories
where category.ProductFromId == producttype.ProductFromId && product.CategoryId == category.CategoryId
orderby product.ProductId descending
select new
{
productId = product.ProductId,
categoryId = category.CategoryId,
categoryName = category.CategoryName,
productTypeId = producttype.ProductFromId,
productTypeName = producttype.ProductFromName,
productName = product.ProductName,
productUnit = product.ProductUnit,
productPrice = product.OriginalPrice,
productDes = product.Description
};
if (list != null)
{
foreach (var l in list.ToList())
{
gvproductlist.Rows.Add(l.productId, l.productName, l.productUnit, l.productPrice, l.categoryName, l.productDes, Properties.Resources.DeleteRed, l.categoryId, l.productTypeId);
}
}
}
public DALCheckedLogin()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
