private async void Loadstart() { SQLExecute sqlexec = new SQLExecute(); allTaxi.AddRange(await sqlexec.SQLGetTaxi(Properties.Settings.Default.DBName, 0, "none", 0, "none", "none", "none", 0, "none", "none", 0, DateTime.Today, "none", true)); allDrivers.AddRange(await sqlexec.SQLGetPerson(Properties.Settings.Default.DBName, 0, "none", "none", "none", 0, 0, "none", 0, DateTime.Today, "none", 1, false)); allPrimaryDriver.AddRange(await sqlexec.SQLGetPrimaryDriver(Properties.Settings.Default.DBName, 0, 0, 0, true)); }
private async Task SaveIfPrimaryDriver(List <PrimaryDriver> primedriver) { SQLExecute sqlexec = new SQLExecute(); foreach (PrimaryDriver pr in primedriver) { List <PrimaryDriver> primedr = new List <PrimaryDriver>(); primedr = await sqlexec.SQLGetPrimaryDriver(Properties.Settings.Default.DBName, 0, pr.TaxiID, pr.PersonID, false); if (primedr.Count == 0) { List <PrimaryDriver> temp = new List <PrimaryDriver>(); temp.Add(pr); await sqlexec.SqlInsertPrimaryDriver(Properties.Settings.Default.DBName, temp); } } }