/// <summary>
/// Deletes all the records in the BuildingDistance table
/// </summary>
public void DeleteAllRecords()
{
using (UofTDataContext db = new UofTDataContext())
{
db.ExecuteCommand("DELETE FROM BuildingDistances");
db.ExecuteCommand("DBCC CHECKIDENT ('BuildingDistances', RESEED, 0)");
}
}
/// <summary>
/// Deletes all building records in the database and repopulates it with new data
/// </summary>
public void RedoBuildingList()
{
db.ExecuteCommand("DELETE FROM BuildingDistances");
db.ExecuteCommand("DELETE FROM Building");
Browser.Initialize();
Browser.WebInstance.Url = "http://map.utoronto.ca/c/buildings";
using (UofTDataContext db = new UofTDataContext())
{
IWebElement buildingsList = Browser.WebInstance.FindElement(By.ClassName("buildinglist"));
IReadOnlyList <IWebElement> buildingElements = buildingsList.FindElements(By.TagName("li"));
foreach (IWebElement building in buildingElements)
{
string[] description = building.FindElement(By.XPath("./dl/dt")).Text.Split('|');
string address = building.FindElement(By.XPath("./dl/dd[1]")).Text.Trim();
string buildingName = description[0].Trim();
string buildingCode = description[1].Trim();
Building newBuilding = new Building
{
Address = address + " Toronto, Canada",
BuildingCode = buildingCode,
BuildingName = buildingName,
Latitude = null,
Longitude = null
};
db.Buildings.InsertOnSubmit(newBuilding);
}
db.SubmitChanges();
}
Browser.Close();
}
/// <summary>
/// Deletes all existing course data from the database
/// </summary>
private void RemoveAllCourseSchedules()
{
// Delete all entities
db.ExecuteCommand("DELETE FROM Session");
db.ExecuteCommand("DELETE FROM InstructorToSection");
db.ExecuteCommand("DELETE FROM Instructor");
db.ExecuteCommand("DELETE FROM Section");
db.ExecuteCommand("DELETE FROM Activity");
db.ExecuteCommand("DELETE FROM Course");
// Reset the primary key
db.ExecuteCommand("DBCC CHECKIDENT ('Session', RESEED, 0)");
db.ExecuteCommand("DBCC CHECKIDENT ('InstructorToSection', RESEED, 0)");
db.ExecuteCommand("DBCC CHECKIDENT ('Instructor', RESEED, 0)");
db.ExecuteCommand("DBCC CHECKIDENT ('Section', RESEED, 0)");
db.ExecuteCommand("DBCC CHECKIDENT ('Activity', RESEED, 0)");
db.ExecuteCommand("DBCC CHECKIDENT ('Course', RESEED, 0)");
}