private async Task <List <Person> > GetDriverComboBox(int id)
        {
            if (id == 0)
            {
                return(allDrivers);
            }
            List <PrimaryDriver> templist   = new List <PrimaryDriver>();
            List <Person>        tempPerson = new List <Person>();


            SQLExecute sqlexec = new SQLExecute();

            return(await Task.Run(() => sqlexec.SqlGetDriversForTaxi(Properties.Settings.Default.DBName, id)));

            //templist.AddRange( allPrimaryDriver.Where(p => p.TaxiID == id).ToList());
            //foreach (PrimaryDriver pd in templist)
            //{
            //    tempPerson.AddRange(allDrivers.Where(Person => Person.PersonID == pd.PersonID).ToList());
            //}
            //return tempPerson;
        }