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___!!!"); } }