public DALBills()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALProduct()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALCategory()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALProductFrom()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALCheckedLogin()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALCategory() {
contextDB = new CafeteriaAndRestaurantEntities();
}
public DALBills()
{
contextDB = new CafeteriaAndRestaurantEntities();
}
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);
}
}
}
