예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var context = new LogicUniversityEntities();
            var recentRequisitionOrders = context.getLowStockItemsByCategory();

            LowStockItemGridView.DataSource = recentRequisitionOrders.ToList();
            LowStockItemGridView.DataBind();
        }
예제 #2
0
        public List <WCF_Item> getLowStockItemsByCategory()
        {
            List <WCF_Item> wcfList = new List <WCF_Item>();

            var context = new LogicUniversityEntities();
            var result  = context.getLowStockItemsByCategory();

            foreach (var i in result.ToList())
            {
                wcfList.Add(new WCF_Item(i.item_number, i.description, i.current_quantity, i.reorder_level));
            }

            return(wcfList);
        }