private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty)
{
MessageBox.Show("product name field can't be empty, please enter a value!");
return;
}
if (textBox2.Text == string.Empty)
{
MessageBox.Show("description of product field can't be empty, please enter a value!");
return;
}
if (textBox3.Text == string.Empty)
{
MessageBox.Show("unit price field can't be empty, please enter a value!");
return;
}
if (textBox4.Text == string.Empty)
{
MessageBox.Show("quantity field can't be empty, please enter a value!");
return;
}
if (textBox5.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox6.Text == string.Empty)
{
MessageBox.Show("product id field can't be empty, please enter a value!");
return;
}
if (textBox31.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox32.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox33.Text == string.Empty)
{
MessageBox.Show("sales rep field can't be empty, please enter a value!");
return;
}
if (textBox34.Text == string.Empty)
{
MessageBox.Show("name of customer field can't be empty, please enter a value!");
return;
}
if (textBox35.Text == string.Empty)
{
MessageBox.Show("month field can't be empty, please enter a numeric value! eg 1 for january, 6 for june.");
return;
}
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=erp_crm");
con.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO salesreg(`name_prd`, `desc`, `unit_price`, `qty`, `total`,`prd_id`,`name_cus`, `sales_rep`, `grand_total`, `invoice_no`, `month`) VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "', '" + textBox4.Text + "','" + textBox5.Text + "', '" + textBox6.Text + "','" + textBox34.Text + "', '" + textBox33.Text + "','" + textBox31.Text + "', '" + textBox32.Text + "', '" + textBox35.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("record has been succesfully inserted in the database, Click Ok to proceed in prinitng receipt");
Form8 myform = new Form8();
this.Hide();
myform.Show();
con.Close();
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox2.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox3.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox4.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox5.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox6.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox31.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox32.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox33.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox34.Text == string.Empty)
{
MessageBox.Show("field can't be empty, please enter a value!");
return;
}
if (textBox35.Text == string.Empty)
{
MessageBox.Show("field for month can't be empty, please enter a value!");
return;
}
{
long ticks = DateTime.Now.Ticks;
byte[] bytes = BitConverter.GetBytes(ticks);
string id = Convert.ToBase64String(bytes)
.Replace('+', '_')
.Replace('/', '-')
.TrimEnd('=');
textBox32.Text = id.ToString();
DateTime.Now.ToString("yyMMddHHmmssff");
textBox32.Text = DateTime.Now.ToLongTimeString();
}
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=erp_crm");
con.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO salesreg(`name_prd`, `desc`, `unit_price`, `qty`, `total`,`prd_id`,`name_cus`, `sales_rep`, `grand_total`, `invoice_no`, `month`) VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "', '" + textBox4.Text + "','" + textBox5.Text + "', '" + textBox6.Text + "','" + textBox34.Text + "', '" + textBox33.Text + "','" + textBox31.Text + "', '" + textBox32.Text + "', '" + textBox35.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("record has been succesfully inserted in the database, Click Ok to proceed in prinitng receipt");
Form8 myform = new Form8();
this.Hide();
myform.Show();
con.Close();
}
