private void btnPOUpdate_Click_1(object sender, EventArgs e) { dgvPOL.Enabled = true; loadPurcaseOrderLineResultBindingSource.DataSource = db.GetPOL(poid).ToList(); xPO = db.Client_Purchase_Order.Single(po => po.Client_Purchase_Id == poid); if (dgvPOL != null) { i = dgvPOL.RowCount - 1; } else { i = 0; } }
private void button4_Click(object sender, EventArgs e) { try { var q1 = db.Client_Purchase_Order.Where(c => c.Supplier_Order_Id == null) .Select(c => c.Client_Purchase_Id).ToList(); var q = db.Client_Purchase_Order_Line.OrderBy(c => c.Product_ID).GroupBy(c => c.Product_ID). Select(s => new { Client_Purchase_Order_Line = s.Key, totalquantity = s.Sum(r => r.Quantity), }).ToList(); var q2 = db.GetTotalQty().ToList(); if (MessageBox.Show("Are you sure you want to place order?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (q2.FirstOrDefault() != null) { addNewSO(); foreach (var item in q2) { newSOL = new Supplier_Order_Line() { Supplier_Order_Id = newSO.Supplier_Order_Id, Product_ID = item.Product_ID, Quantity = Convert.ToInt32(item.Total_Quantity) }; db.Supplier_Order_Line.Add(newSOL); } foreach (var item in q1) { Client_Purchase_Order xpo = db.Client_Purchase_Order.Single(po => po.Client_Purchase_Id == item); xpo.Supplier_Order_Id = newSO.Supplier_Order_Id; } db.SaveChanges(); dataGridView1.DataSource = db.GetSOL(newSO.Supplier_Order_Id).ToList(); } else { MessageBox.Show("There are no client orders to be added"); } } } catch (Exception) { throw; } }
private void btnPOLSave_Click(object sender, EventArgs e) { if (add == true) { newPO.Gross_Amount = Convert.ToDecimal(db.GetPOL(newPO.Client_Purchase_Id).Sum(pol => pol.Subtotal));; newPO.Purchase_Order_Status_ID = 1; if (MessageBox.Show("Would you like to have your order delivered", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { newPO.Dispatch_Type_Id = 1; } else { newPO.Dispatch_Type_Id = 2; } db.Client_Purchase_Order.Add(newPO); newPO = null; } else if (update == true) { xPO.Gross_Amount = Convert.ToDecimal(db.GetPOL(newPO.Client_Purchase_Id).Sum(pol => pol.Subtotal));; //db.Client_Purchase_Order.Add(newPO); xPO = null; } db.SaveChanges(); dgvPOL.Refresh(); dgvPO.Refresh(); //dgvPOL.DataSource = db.GetPOL(pol.Client_Purchase_Id).ToList(); CalculateSubtotal(); //CalculateGrossAmount(); }