private void button2_Click(object sender, EventArgs e) { if (newSO != null) { int prid = Convert.ToInt32(comboBox2.SelectedValue); var q = db.Products.Where(p => p.Product_ID == prid).FirstOrDefault(); var q1 = db.Supplier_Order_Line.Where(sol => sol.Product_ID == prid && sol.Supplier_Order_Id == newSO.Supplier_Order_Id).FirstOrDefault(); if (newSOL == null) { newSOL = new Supplier_Order_Line() { Supplier_Order_Id = newSO.Supplier_Order_Id, Product_ID = Convert.ToInt32(comboBox2.SelectedValue), Quantity = Convert.ToInt32(numericUpDown1.Value) }; db.Supplier_Order_Line.Add(newSOL); db.SaveChanges(); var q2 = db.Supplier_Order.Where(x => x.Supplier_Order_Id == newSO.Supplier_Order_Id).First(); dataGridView1.DataSource = db.GetSOL(newSO.Supplier_Order_Id).Where(x => x.SO_Number == q2.SO_Number).ToList(); } else { var q3 = db.Supplier_Order.Where(x => x.Supplier_Order_Id == newSO.Supplier_Order_Id).First(); if (q1 == null) { newSOL = new Supplier_Order_Line() { Supplier_Order_Id = newSO.Supplier_Order_Id, Product_ID = Convert.ToInt32(comboBox2.SelectedValue), Quantity = Convert.ToInt32(numericUpDown1.Value) }; db.Supplier_Order_Line.Add(newSOL); //q.Available_Quantity -= Convert.ToInt32(numericUpDown1.Value); db.SaveChanges(); dataGridView1.DataSource = db.GetSOL(newSO.Supplier_Order_Id).Where(x => x.SO_Number == q3.SO_Number).ToList(); } else { var q4 = db.Supplier_Order_Line.Where(sol => sol.Supplier_Order_Id == newSO.Supplier_Order_Id && sol.Supplier_Order_Line_ID == q1.Supplier_Order_Line_ID). FirstOrDefault(); q4.Quantity += Convert.ToInt32(numericUpDown1.Value); //q.Available_Quantity -= Convert.ToInt32(numericUpDown1.Value); db.SaveChanges(); dataGridView1.DataSource = db.GetSOL(newSO.Supplier_Order_Id).Where(x => x.SO_Number == q3.SO_Number).ToList(); } } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow r = this.dataGridView1.Rows[e.RowIndex]; string sonum = r.Cells[0].Value.ToString(); var q = db.Supplier_Order.Where(c => c.SO_Number == sonum).FirstOrDefault(); int soid = Convert.ToInt32(q.Supplier_Order_Id.ToString()); getSOLResultBindingSource.DataSource = db.GetSOL(soid); }
private void button4_Click(object sender, EventArgs e) { try { button4.Enabled = false; frmScanQR scanQR = new frmScanQR(); scanQR.Dock = DockStyle.Fill; scanQR.BringToFront(); scanQR.ShowDialog(); textBox1.Text = scanQR.DecodeID; var q = db.Supplier_Order.Where(so => so.SO_Number == textBox1.Text).FirstOrDefault(); dataGridView1.DataSource = db.GetSOL(q.Supplier_Order_Id).ToList(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }