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