/// <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)"); }