protected void makeRequest_Click(object sender, EventArgs e) { var repository = new PurchaseOrder(); var repository_detail = new PurchaseOrderDetail(); int result = checkForCbTb(); if (result == 0) { this.ShowErrorNotification("Please select any product"); } else { tblPurchaseOrder tbl = new tblPurchaseOrder(); tblPurchaseOrderDetail tbl_detail = new tblPurchaseOrderDetail(); tbl.VendorId = Convert.ToInt32(vendorName.SelectedValue); tbl.OrderDate = DateTime.Now; // tbl.TotalValue = q; repository.Add(tbl); int poid = repository.GetId(); foreach (GridViewRow row in gridProduct.Rows) { CheckBox cb = (CheckBox)row.FindControl("CheckBox1"); if (cb.Checked) { int id = Convert.ToInt32(gridProduct.DataKeys[row.RowIndex].Value); TextBox txt = (TextBox)row.FindControl("TextBox1"); string quantity = txt.Text; tbl_detail.POId = poid; tbl_detail.ProductId = id; tbl_detail.Quantity = Convert.ToInt32(quantity); Product pObj = new Product(); tblProduct selectedProduct = pObj.Get(id); tbl.TotalValue += (selectedProduct.StandardCost * tbl_detail.Quantity); repository_detail.Add(tbl_detail); cb.Checked = false; txt.Text = ""; this.ShowSuccessfulNotification("Delivery Requested Successfully"); } } repository.Update(repository.Get(poid)); } }