private void btAdd_Click(object sender, EventArgs e) { string factQuery; FormCars fc = new FormCars(); factQuery = "(`number_sts`, `brand`, `model`, `year_created`, `date_to`) VALUES('" + tbNumSTS.Text + "', '" + tbBrand.Text + "', '" + tbModel.Text + "', '" + tbYear.Text + "', '" + tbDateTO.Text + "');"; db.Add("cars", factQuery, fc.dataGridView1); Hide(); }
private void AddClientToDB(string surname, string name, string patronimyc, string phone, string brand, string model, string year, string sts) { //Сначала делаем запрос к таблице с машинами потому что клиенты связаны с машинами string factQuery; FormCars fc = new FormCars(); factQuery = "(`number_sts`, `brand`, `model`, `year_created`) VALUES('" + sts + "', '" + brand + "', '" + model + "', '" + year + "');"; db.Add("cars", factQuery, fc.dataGridView1); FormClients fm = new FormClients(); factQuery = "(`surname`, `name`, `patronimyc`,`phone_number` ,`cars_number_sts`) VALUES('" + surname + "', '" + name + "', '" + patronimyc + "', '" + phone + "', '" + sts + "');"; db.Add("clients", factQuery, fm.dataGridView1); }
private void btCars_Click(object sender, EventArgs e) { FormCars fCars = new FormCars(); fCars.ShowDialog(); }