public static DataSources.dsData.RoutesRow GetRouteNumber(string RouteNumber, DataSources.dsData.RoutesDataTable tbl)
        {
            //DataRow[] rows = tbl.Select("RouteNumber = " + RouteNumber);
            //if (rows.Length == 0)
            //    return DataManager.defaultInstance.UnknownRouteId;
            //else
            //    return (int)rows[0]["RouteId"];

            RouteNumber = RouteNumber.ToUpper();

            for (int i = 0; i < tbl.Count; i++)
            {
                if (tbl[i].RouteNumber == RouteNumber)
                    return tbl[i];
            }
            DataSources.dsData.RoutesRow row = tbl.NewRoutesRow();
            Route.CreateDefaultRoute(ref row);
            return row;
        }