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());
}
}
