public async Task<List<DeviceTest>> RequestAsync()
        {
            using HttpClient client = new HttpClient();

            string content = "";
            HttpResponseMessage response = await client.GetAsync(_url);
            if (response.IsSuccessStatusCode)
            {
                content = await response.Content.ReadAsStringAsync();
            }

            List<DeviceTest> devices = JsonSerializer.Deserialize<List<DeviceTest>>(content);
            return devices;
        }

        public List<DeviceTest> GetDummyData(int lokatieId)
        {
            DatabaseConnection testConnection = new DatabaseConnection("multipass_test");
            List<string> devIds = testConnection.ExecuteSQLCommand("SELECT DevID FROM devices WHERE Lokatie=" + lokatieId);
            List<string> lastAccessDate = testConnection.ExecuteSQLCommand("SELECT lastAccessDate  FROM devices WHERE Lokatie=" + lokatieId);
            List<string> lastAccessTime = testConnection.ExecuteSQLCommand("SELECT lastAccessTime  FROM devices WHERE Lokatie=" + lokatieId);

            List<DeviceTest> dummyData = new List<DeviceTest>();

            for (int i = 0; i < devIds.Count; i++)
            {
                dummyData.Add(new DeviceTest(DateTime.Parse(lastAccessDate[i] + " " + lastAccessTime[i]), devIds[i]));
            }
            return dummyData;
        }

        public void GenerateJSON(List<LocationAPI> list)
        {
            string json = JsonSerializer.Serialize(list);
            File.WriteAllText(@"C:\Users\werkplaats\Downloads\" + "test" + ".json", json);
        }

        public List<DeviceTest> GetJSONData()
        {
            string path = @"C:\Users\werkplaats\Downloads\" + _url.Split("/")[2];
            List<DeviceTest> devices = new List<DeviceTest>();
            if (!File.Exists(path))
            {
                using (StreamReader sr = File.OpenText(path + ".json"))
                {
                    devices = JsonSerializer.Deserialize<List<DeviceTest>>(sr.ReadLine());
                }
            }
            return devices;
        }