}//FUNZIONE CHE RITORNA BOOLEANO SE STRINGA E' CONTENUTA NELL'OGGETTO
public static SerializableBindingList <Veicolo> Search(string s, System.Collections.Generic.List <Veicolo> lst, char sep = ' ')
{
string[] search = s.Split(sep);
SerializableBindingList <Veicolo> results = new SerializableBindingList <Veicolo>();//LISTA RISULTATI
foreach (Veicolo item in lst)
{
if (item.Contains(search[0]))
{
results.Add(item);
}
}
for (int i = 0; i < search.Length; i++)
{
for (int j = 0; j < results.Count; j++)
{
if (!results[j].Contains(search[i]))
{
results.Remove(results[j]);
j--;
if (results.Count == 1)
{
break;
}
}
}
if (results.Count == 1)
{
break;
}
}
return(results);
}
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 static void CreateListCars()
{
bindingListVeicoli.Clear();
if (connStr != null)
{
OleDbConnection con = new OleDbConnection(connStr);
using (con)
{
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
try
{
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Veicoli", con);
DataTable table = new DataTable();
adapter.Fill(table);
foreach (DataRow item in table.Rows)
{
if (int.TryParse(item.ItemArray[10].ToString(), out _))
{
Auto a = new Auto(item.ItemArray[0].ToString(), item.ItemArray[1].ToString(), item.ItemArray[2].ToString(), item.ItemArray[3].ToString(), Convert.ToInt32(item.ItemArray[4]), Convert.ToDouble(item.ItemArray[5]),
Convert.ToDateTime(item.ItemArray[6]), Convert.ToBoolean(item.ItemArray[7]), Convert.ToBoolean(item.ItemArray[8]), Convert.ToInt32(item.ItemArray[9]),
Convert.ToInt32(item.ItemArray[10]));
bindingListVeicoli.Add(a);
}
else
{
Moto m = new Moto(item.ItemArray[0].ToString(), item.ItemArray[1].ToString(), item.ItemArray[2].ToString(), item.ItemArray[3].ToString(), Convert.ToInt32(item.ItemArray[4]), Convert.ToDouble(item.ItemArray[5]),
Convert.ToDateTime(item.ItemArray[6]), Convert.ToBoolean(item.ItemArray[7]), Convert.ToBoolean(item.ItemArray[8]), Convert.ToInt32(item.ItemArray[9]),
item.ItemArray[10].ToString());
bindingListVeicoli.Add(m);
}
}
}
catch (OleDbException exc)
{
Console.WriteLine("\n " + exc.Message);
System.Threading.Thread.Sleep(4000);
return;
}
}
}
}
