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