private void button14_Click_2(object sender, EventArgs e)
{
Supplier_Orders_Add so = new Supplier_Orders_Add();
so.ShowDialog();
Supplier_Orders s = new Supplier_Orders();
s.Close();
}
private void btnPlace_Click(object sender, EventArgs e)
{
try
{
if (dBConnection.IsConnect())
{
string query = "INSERT INTO `supplier_order` (`supplier_id`, `supplier_order_date_placed`, `supplier_order_status_id`) VALUES";
query += "('" + Globals.SupplierID + "', '" + Convert.ToDateTime(dateTimePicker1.Value).Date.ToString("yyyy-M-dd") + "', '" + 1 + "')";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
query = "SELECT MAX(supplier_order_id) FROM supplier_order";
var cmd = new MySqlCommand(query, dBConnection.Connection);
var reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
supplier_order_id = reader[0].ToString();
}
reader.Close();
for (int i = 0; i < dgvOrderProductList.Rows.Count; i++)
{
query = "INSERT INTO `supplier_order_line` (`supplier_order_id`, `product_id`, `supplier_order_line_quantity` ) VALUES('" + Convert.ToInt16(supplier_order_id) + "', " +
"'" + dgvOrderProductList.Rows[i].Cells[0].Value + "', '" + dgvOrderProductList.Rows[i].Cells[2].Value + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
Supplier_Orders so = new Supplier_Orders();
so.Refresh();
MessageBox.Show("Order has been placed");
}
}
catch (Exception er)
{
MessageBox.Show("Error: " + er.Message);
}
this.Close();
}
private void Button22_Click(object sender, EventArgs e)
{
Supplier_Orders supplier_Orders = new Supplier_Orders();
supplier_Orders.Show();
}
private void activateOrders(object sender, EventArgs e)
{
Supplier_Orders so = new Supplier_Orders();
so.Refresh();
}
