private void add_button_Click(object sender, EventArgs e)
{
// Insert add function
if (plate_input.Text == "" || category == "" || owner_input.Text == "" || vehicle_make_input.Text == "" || vehicle_model_input.Text == "" || year.Text == "")
{
MessageBox.Show("Please input required field.");
}
else
{
string j = "select * from vehicle where plate_number = '" + plate_input.Text + "'";
DataTable dt = new DataTable();
dt = main.SELECT_Statement(j);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Vehicle Already Exists!", "BOX", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string query =
"set foreign_key_checks=0;" +
"INSERT INTO vehicle(plate_number,cust_id_vehicle_fk,vehicle_type_fk,vehicle_make,vehicle_model, vehicle_year)" +
"VALUES('" + plate_input.Text + "','" + cust_id.Text + "','" + vehiclecategory + "','" + vehicle_make_input.Text + "','" + vehicle_model_input.Text + "','" + year.Text + "');" +
"set foreign_key_checks=1;";
main.CUD_Statement(query);
MessageBox.Show("Vehicle Added!", "BOX", MessageBoxButtons.OK, MessageBoxIcon.Information);
Profile_Customer g = new Profile_Customer();
g.Show();
this.Hide();
}
}
}
private void Customer_Link_Click(object sender, EventArgs e)
{
Profile_Customer g = new Profile_Customer();
g.Show();
this.Hide();
}
private void cancel_button_Click(object sender, EventArgs e)
{
Profile_Customer g = new Profile_Customer();
g.Show();
this.Hide();
}
