private void button6_Click_1(object sender, EventArgs e)
{
this.Hide();
Billingdetails bill = new Billingdetails();
bill.ShowDialog();
}
private void submit_btn_Click_1(object sender, EventArgs e)
{
string constring = "datasource=localhost;port=3306;username=root;password="******"insert into carsale.BillingDetails(BillNumber,CustomerID,VehicleID,PhoneNo,Email,HandOverTo,TotalAmount) values('" + this.bill_no.Text + "','" + this.cID_txt.Text + "','" + this.vID_txt.Text + "','" + this.bilPhone_txt.Text + "','" + this.bEmail_txt.Text + "','" + this.bHand_txt.Text + "','" + this.tMaount_txt.Text + "') ;";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDataBase = new MySqlCommand(query, conDataBase);
MySqlDataReader myReader;
Billingdetails f2 = new Billingdetails();
//f2.label14.Text = cID_txt.Text.ToString();
//f2.label15.Text = vID_txt.Text.ToString();
//f2.label16.Text = bilPhone_txt.Text.ToString();
//f2.label17.Text = bEmail_txt.Text.ToString();
//f2.label18.Text = bHand_txt.Text.ToString();
//f2.label19.Text = tMaount_txt.Text.ToString();
//int n1 = int.Parse(textBox5.Text);
//int n2 = int.Parse(textBox6.Text);
//int total = n1 + n2;
//f2.label15.Text = total.ToString();
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("Billing Details Successfully saved");// confirm data is saved
while (myReader.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
