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