public void AddNow()
{
if ((textBox1.Text == "") || (textBox3.Text == ""))
{
MessageBox.Show("Information is not complete");
}
else
{
if (MessageBox.Show("Are you sure you want to add this category?", "Inventory System", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
{
query33 = "Insert Into suppliers Values('" + textBox1.Text.ToUpper() + "','" + textBox3.Text.ToUpper().Trim() + "','" + textBox2.Text.ToUpper().Trim() + "','" + "SUPP" + idcomponent() + "')";
}
dbQuery(query33);
MessageBox.Show("Supplier was successfuly added to the system");
Suppliers it = new Suppliers(userss);
it.Show();
this.Hide();
}
}
}
private void glassButton5_Click(object sender, EventArgs e)
{
Suppliers ss = new Suppliers(user);
ss.Show();
this.Hide();
}
private void pictureBox6_Click(object sender, EventArgs e)
{
Suppliers fm = new Suppliers(user);
fm.Show();
}