public static void GetFreeSlots()
{
ParkItems.Clear();
DockItems.Clear();
using var conn = new SqlConnection(Properties.Settings.Default.ConnectionString);
conn.Open();
string qry = "SELECT * FROM Parking WHERE ParkedVehicle = 0;";
var cmd = new SqlCommand(qry, conn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var parkItem = new ParkItem(reader);
// Place item based on Type
switch (reader["slotType"].ToString())
{
case "P":
FreeParking.Add(parkItem);
break;
case "D":
FreeDocking.Add(parkItem);
break;
default:
break;
}
}
}
