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;
}
}
}
private void OnLoaded(object sender, RoutedEventArgs e)
{
this.Loaded -= new RoutedEventHandler(OnLoaded);
foreach (DockItem item in DockItems)
{
ShowAction showAction = item.ShowAction;
if (showAction != null)
{
item.ShowAction = null;
showAction.Source = DockItems.IndexOf(item);
showAction.Run(this);
}
}
}
