private void caricaDatiDiTest() { UtilsDatabase u = new UtilsDatabase(connStr); //u.CreateTableCars(); //UtilsDatabase.CreateTable("Auto"); //UtilsDatabase.CreateTable("Moto"); //UtilsDatabase.CreateTableCars("Moto"); //UtilsDatabase.CreateTableCars("Auto"); if (UtilsDatabase.first) { UtilsDatabase.CreateTableCars("cars"); UtilsDatabase.AddNewCar("Moto", "Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, 12000, "Quintino", 0); UtilsDatabase.AddNewCar("Auto", "Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 32500, "/", 8); } Moto m = new Moto(); bindingListVeicoli.Add(m); m = new Moto("Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, "Quintino"); bindingListVeicoli.Add(m); //UtilsDatabase.AddNewItem("Moto", "Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, 12000, 0, "Quintino"); Auto a = new Auto("Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 8); bindingListVeicoli.Add(a); //UtilsDatabase.AddNewItem("Auto", "Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 32500, /*"",*/ 8, ""); }
private void btnAggiungi_Click(object sender, EventArgs e) { //MessageBox.Show(cmbTipoVeicolo.SelectedItem + " - " + txtMarca.Text + " - "); if (cmbTipoVeicolo.SelectedIndex == 0) { VenditaVeicoliDLLProject.Moto m = new VenditaVeicoliDLLProject.Moto(txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToInt32(nmrPotenza.Value), dtpImmatricolazione.Value, rdbNo.Checked? false : true, rdbNoZ.Checked? false : true, Convert.ToInt32(nmrKmPercorsi.Value), txtMarcaSella.Text); bindingListaVeicoli.Add(m); UtilsDatabase.AddNewCar("Moto", txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToInt32(nmrPotenza.Value), Convert.ToDateTime(dtpImmatricolazione.Value), rdbNo.Checked ? false : true, rdbNoZ.Checked ? false : true, Convert.ToInt32(nmrKmPercorsi.Value), Convert.ToInt32(nmrPrezzo.Value), txtMarcaSella.Text, 0); //UtilsDatabase.AddNewItem("Moto", txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToDouble(nmrPotenza.Value), Convert.ToDateTime(dtpImmatricolazione.Value), rdbNo.Checked?false:true, rdbNoZ.Checked?false:true, Convert.ToInt32(nmrKmPercorsi), Convert.ToDouble(nmrPrezzo), Convert.ToInt32(nmrNumAirbag), txtMarcaSella.Text); } else { VenditaVeicoliDLLProject.Auto a = new VenditaVeicoliDLLProject.Auto(txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToInt32(nmrPotenza.Value), dtpImmatricolazione.Value, rdbNo.Checked ? false : true, rdbNoZ.Checked ? true : false, Convert.ToInt32(nmrKmPercorsi.Value), Convert.ToInt32(nmrNumAirbag.Value)); bindingListaVeicoli.Add(a); UtilsDatabase.AddNewCar("Auto", txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToInt32(nmrPotenza.Value), Convert.ToDateTime(dtpImmatricolazione.Value), rdbNo.Checked ? false : true, rdbNoZ.Checked ? false : true, Convert.ToInt32(nmrKmPercorsi.Value), Convert.ToInt32(nmrPrezzo.Value), "/", Convert.ToInt32(nmrNumAirbag.Value)); //UtilsDatabase.AddNewItem("Auto", txtMarca.Text, txtModello.Text, cmbColore.SelectedItem.ToString(), Convert.ToInt32(nmrCilindrata.Value), Convert.ToDouble(nmrPotenza.Value), Convert.ToDateTime(dtpImmatricolazione.Value), rdbNo.Checked ? false : true, rdbNoZ.Checked ? false : true, Convert.ToInt32(nmrKmPercorsi), Convert.ToDouble(nmrPrezzo), Convert.ToInt32(nmrNumAirbag), txtMarcaSella.Text); } this.Close(); }
static void Main(string[] args) { UtilsDatabase u = new UtilsDatabase(connStr); //u.CreateTableCars(); using (StreamReader sr = new StreamReader(file)) { String line = sr.ReadToEnd(); if (line == "true") { UtilsDatabase.first = true; } else { UtilsDatabase.first = false; } } Console.WriteLine("*** SALONE VENDITA VEICOLI NUOVI E USATI ***"); //Moto m = new Moto(); //Console.WriteLine(m); //Auto a = new Auto(); //Console.WriteLine(a); char scelta; do { menu(); Console.Write("DIGITA LA TUA SCELTA "); scelta = Console.ReadKey().KeyChar; switch (scelta) { case '1': if (UtilsDatabase.first) { UtilsDatabase.CreateTableCars("cars"); } else { Console.WriteLine("\nLa tabella cars è già esistente\n\n\n"); } break; case '2': setParameters(); if (veicolo == "Moto") { UtilsDatabase.AddNewCar(veicolo, marca, modello, colore, cilindrata, potenza, immatricolazione, usata, kmZero, kmPercorsi, prezzo, marcaSella, 0); } else { UtilsDatabase.AddNewCar(veicolo, marca, modello, colore, cilindrata, potenza, immatricolazione, usata, kmZero, kmPercorsi, prezzo, "", numAirbag); } break; case '3': int id; Console.WriteLine("\nId da eliminare: "); object aus = Console.ReadLine(); if (Double.IsNaN(Convert.ToDouble(aus))) { Console.WriteLine("Input non valido"); } else { id = Convert.ToInt32(aus); UtilsDatabase.DeleteElement("cars", id); } break; case '4': DropTable("cars"); break; case '5': Console.Clear(); break; default: break; } } while (scelta != 'X' && scelta != 'x'); using (StreamWriter sw = new StreamWriter(file)) { sw.WriteLine(UtilsDatabase.first.ToString()); } }