private void Load_Data_Grid()
        {
            PurchaseOrderDetail repository = new PurchaseOrderDetail();
            int id     = Convert.ToInt32(DropDownList1.SelectedValue);
            var result = repository.GetAll(id).Select(r => new { r.PODetailId, r.POId, r.ProductId, ProductName = r.tblProduct.ProductName, r.Quantity }).ToArray();

            gridProduct.DataSource = result;
            gridProduct.DataBind();
        }
        protected void btnDeliver_Click(object sender, EventArgs e)
        {
            PurchaseOrderDetail repository = new PurchaseOrderDetail();
            PurchaseOrder       rep_po     = new PurchaseOrder();
            int id     = Convert.ToInt32(DropDownList1.SelectedValue);
            var result = repository.GetAll().Where(r => r.POId == id).ToArray();
            var pp     = rep_po.Get(id);

            pp.Deleted = true;
            rep_po.Update(pp);
            Product    rep  = new Product();
            tblProduct prod = new tblProduct();

            foreach (var item in result)
            {
                var p = rep.Get(item.ProductId);
                p.Quantity += item.Quantity;
                rep.Update(p);
            }
            this.ShowSuccessfulNotification("Products Delivered");
            gridProduct.Visible = false;
        }