private void SAVE_Click(object sender, EventArgs e)
{
if (Vehicle_ID.Text == "" || Trailer_No.Text == "" || Chasis_No.Text == "" || Engine_No.Text == "" || Model_No.Text == "" || Permit_No.Text == "" || Driver_Name.Text == "" || Conductor_Name.Text == "" || Route.Text == "")
{
MessageBox.Show("PLEASE_FILLALL_DATA__!!!");
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO VEHICLE (Vehicle_ID,Trailer_No,Chasis_No,Engine_No,Model_No,Permit_No,Driver_Name,Conductor_Name,Route,Date)VALUES('" + Vehicle_ID.Text + "','" + Trailer_No.Text + "','" + Chasis_No.Text + "','" + Engine_No.Text + "','" + Model_No.Text + "','" + Permit_No.Text + "','" + Driver_Name.Text + "','" + Conductor_Name.Text + "','" + Route.Text + "','" + Date.Text + "')", con);
sda.SelectCommand.ExecuteNonQuery();
con.Close();
Trailer_No.Text = "";
Chasis_No.Text = "";
Engine_No.Text = "";
Model_No.Text = "";
Permit_No.Text = "";
Driver_Name.Text = "";
Conductor_Name.Text = "";
Route.Text = "";
Vehicle_ID.Text = "";
Date.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("SAVE SUCCESSFULLY-!!!!");
Add_Vehicle_Details ds = new Add_Vehicle_Details();
this.Dispose(false);
ds.Show();
}
}
private void CLEAR_Click(object sender, EventArgs e)
{
Vehicle_ID.Text = "";
Trailer_No.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("ALL_CLEARED__!!!");
}
private void CLEAR_Click(object sender, EventArgs e)
{
Vehicle_ID.Text = "";
Vehicle_No.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("DATA_DELETED_SUCCESSFULLY___!!!");
}
private void CLEAR_Click(object sender, EventArgs e)
{
Vehicle_ID.Text = "";
Vehicle_No.Text = "";
Insurance_Date.Text = "";
PUC_Date.Text = "";
Fitness_Date.Text = "";
Tax_Date.Text = "";
Permit_Date.Text = "";
Permit_Type.Text = "";
Date.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("ALL_CLEAR_SUCCESSFULLY___!!!");
}
private void CLEAR_Click(object sender, EventArgs e)
{
Vehicle_ID.Text = "";
Trailer_No.Text = "";
Chasis_No.Text = "";
Engine_No.Text = "";
Model_No.Text = "";
Permit_No.Text = "";
Driver_Name.Text = "";
Conductor_Name.Text = "";
Route.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("CLEAR_SUCCESSFULLY__");
}
private void DELETE_Click(object sender, EventArgs e)
{
if (Vehicle_ID.Text == "" || Vehicle_No.Text == "")
{
MessageBox.Show("PLEASE_FILL_ALL_RECOMMENDED_DATA_FIRST_!!");
}
else
{
con.Open();
SqlCommand scd = new SqlCommand("DELETE FROM Vehicle_Paper WHERE Vehicle_ID='" + Vehicle_ID.Text + "' and Vehicle_Number='" + Vehicle_No.Text + "'", con);
scd.ExecuteNonQuery();
con.Close();
Vehicle_ID.Text = "";
Vehicle_No.Text = "";
Vehicle_ID.Focus();
MessageBox.Show("DATA_DELETED_SUCCESSFULLY___!!!");
}
}
