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