public static Veicolo searchElement(string targa)
{
Veicolo v = null;
if (connStr != null)
{
OleDbConnection con = new OleDbConnection(connStr);
using (con)
{
con.Open();
try
{
foreach (Veicolo item in bindingListVeicoli)
{
if (item.Targa == targa)
{
v = item;
}
}
}
catch (OleDbException exc)
{
Console.WriteLine("\n " + exc.Message);
System.Threading.Thread.Sleep(5000);
}
}
}
return(v);
}
public void Update(Veicolo v, string connString)
{
using (OleDbConnection connection = new OleDbConnection(connString)) //data reader: oggetto per recuperare dati
{
connection.Open();
UpdateVeicoloCommand u = new UpdateVeicoloCommand(connection);
OleDbCommand cmd = u.GetCommand();
u.AggiungiParametri(v);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
}
public void Insert(Veicolo v, string connString)
{
using (OleDbConnection connection = new OleDbConnection(connString)) //data reader: oggetto per recuperare dati
{
connection.Open();
InsertVeicoloCommand i = new InsertVeicoloCommand(connection);
OleDbCommand cmd = i.GetCommand();
i.AggiungiParametri(v);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
}
public SerializableBindingList <Veicolo> GetVeicoliList(DataTable t)
{
SerializableBindingList <Veicolo> l = new SerializableBindingList <Veicolo>();
foreach (DataRow r in t.Rows)
{
if (Convert.ToInt32(r["AutoMoto"]) == 1)
{
l.Add(new Auto(Veicolo.SetArray(r)));
}
else
{
l.Add(new Moto(Veicolo.SetArray(r)));
}
}
return(l);
}
public void AggiungiParametri(Veicolo v)
{
cmd.Parameters.Add("@targa", OleDbType.VarChar, 255).Value = v.Targa;
cmd.Parameters.Add("@automoto", OleDbType.Boolean).Value = (v is Auto);
cmd.Parameters.Add("@marca", OleDbType.VarChar, 255).Value = v.Marca;
cmd.Parameters.Add("@modello", OleDbType.VarChar, 255).Value = v.Modello;
cmd.Parameters.Add("@cilindrata", OleDbType.Integer).Value = v.Cilindrata;
cmd.Parameters.Add("@potenzakw", OleDbType.Double).Value = v.PotenzaKw;
cmd.Parameters.Add("@immatricolazione", OleDbType.DBDate).Value = v.Immatricolazione;
cmd.Parameters.Add("@usato", OleDbType.Boolean).Value = v.IsUsato;
cmd.Parameters.Add("@kmzero", OleDbType.Boolean).Value = v.IsKmZero;
cmd.Parameters.Add("@kmpercorsi", OleDbType.Integer).Value = v.KmPercorsi;
cmd.Parameters.Add("@colore", OleDbType.VarChar, 255).Value = v.Colore;
cmd.Parameters.Add("@prezzo", OleDbType.Double).Value = v.Prezzo;
cmd.Parameters.Add("@imagepath", OleDbType.VarChar, 255).Value = v.ImagePath;
string c = (v is Auto ? (v as Auto).NumeroAirBag.ToString() : (v as Moto).MarcaSella);
cmd.Parameters.Add("@caratteristica", OleDbType.VarChar, 255).Value = c;
}
public new void AggiungiParametri(Veicolo v)
{
cmd.Parameters.Add("@targa", OleDbType.VarChar, 255).Value = v.Targa;
}
