private void btnSupProd_Click(object sender, EventArgs e)
{
Supplier_Supplies sup = new Supplier_Supplies();
sup.prevform = this;
sup.user_id = this.user_id;
sup.type = this.user_type;
this.Hide();
sup.Show();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string add = "INSERT INTO product_supply VALUES (NULL, '" + txtCode.Text + "', '" + txtDesc.Text + "', '" + txtUP.Text + "', '" + txtQnt.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "', '" + this.user_id + "')";
conn.Open();
MySqlCommand comm = new MySqlCommand(add, conn);
comm.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Succesfully Added!", "");
Supplier_Supplies sup = new Supplier_Supplies();
sup.show();
}