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