public List <ConfigPositions> GetConfigPositions(int configId)
{
string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;
List <ConfigPositions> configPositionList = new List <ConfigPositions>();
SqlConnection con = new SqlConnection(connectionString);
string selectSQL = String.Format("SELECT Activity.Activity, XPos, YPos FROM ActivityPosition INNER JOIN Activity ON ActivityPosition.ActivityId = Activity.ActivityId");
try
{
con.Open();
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
ConfigPositions configPosition = new ConfigPositions();
configPosition.Activity = Convert.ToString(dr["Activity"]);
configPosition.XPos = Convert.ToDouble(dr["XPos"]);
configPosition.YPos = Convert.ToDouble(dr["YPos"]);
configPositionList.Add(configPosition);
}
}
con.Close();
}
catch (Exception ex)
{
ActivityViewModel.ShowMessageBox(ex.ToString(), "Error!");
}
return(configPositionList);
}
//Method to connect locations and activities in the config list
public void AddActivityLocations()
{
DatabaseHandler dbHandler = new DatabaseHandler();
List <string> activityList = new List <string>();
activityList = dbHandler.GetActivityList();
for (int i = 0; i < activityList.Count; i++)
{
ConfigPositions configPosition = new ConfigPositions();
configPosition.Activity = activityList[i];
switch (activityList[i])
{
case "Sleeping":
configPosition.ActivityLocation = "Bed";
break;
case "Toileting":
configPosition.ActivityLocation = "Toilet";
break;
case "Showering":
configPosition.ActivityLocation = "ShowerArea";
break;
case "Breakfast":
configPosition.ActivityLocation = "DiningTable";
break;
case "Grooming":
configPosition.ActivityLocation = "Basin";
break;
case "SpareTime/TV":
configPosition.ActivityLocation = "Sofa";
break;
case "Leaving":
configPosition.ActivityLocation = "Entrance";
break;
case "Lunch":
configPosition.ActivityLocation = "DiningTable";
break;
case "Snack":
configPosition.ActivityLocation = "DiningTable";
break;
}
configPositionList.Add(configPosition);
}
}