protected void loadgrid()
{
tokobediaModelContainer db = new tokobediaModelContainer();
var query = from g in db.Products
join m in db.ProductTypes on g.ProductTypeID equals m.ID
select new
{
Id = g.ID,
Name = g.Name,
ProductType = m.Name,
Stock = g.Stock,
Price = g.Price
};
GridAllItem.DataSource = query.ToList();
GridAllItem.DataBind();
}
private void ShowAllItem()
{
List <Product> product = ViewProductController.GetAllProductController();
var filtered = product.Select(i => new {
Id = i.ID,
Name = i.Name,
ProductType = i.ProductType.Name,
Stock = i.Stock,
Price = i.Price
});
if (filtered.Count() > 0)
{
GridAllItem.DataSource = filtered;
GridAllItem.DataBind();
}
}