public PartRoute(int id, DateTime pickUpTime, Battery battery, Route route)
{
_id = id;
_pickUpTime = pickUpTime;
_battery = battery;
_route = route;
}
public PartRoute(DateTime pickUpTime, Battery battery, Route route)
{
_id = -1;
_pickUpTime = pickUpTime;
_battery = battery;
_route = route;
}
public void searchBatteryIDTest()
{
DBBattery target = new DBBattery(); // TODO: Initialize to an appropriate value
int id = 1; // TODO: Initialize to an appropriate value
Battery expected = new Battery(1,Battery.Status.Charged,new Station(1,"TRAFIKCENTER SÆBY SYD","20",9300)); // TODO: Initialize to an appropriate value
Battery actual;
actual = target.searchBatteryID(id);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
//static IRouteplanner rp = new RoutePlanner();
static void Main(string[] args)
{
/*Node testNode1 = new Node(new Station("Løkkegade", "27, 3. th.", 9000));
Node testNode2 = new Node(new Station("Løkkegade", "28, 3. th.", 9000));
Graph graph1 = rp.getGraph();
Graph graph2 = rp.getGraph().DeepClone();
graph2.AddNode(testNode1);
graph2.AddNode(testNode2);
//List<Node> result = graph.ShortestPath(testNode1, testNode2);
/*List<Node> result = graph1.ShortestPath(graph1.Nodes.ElementAt(0), graph1.Nodes.ElementAt(5));
//Console.WriteLine(result.Count.ToString());
foreach (Node n in result)
{
Console.WriteLine(n.Data._street+" "+n.Data._streetNo);
}
foreach (Node n in graph1.Nodes)
{
Console.WriteLine(n.Data._street + " " + n.Data._streetNo);
}
Console.WriteLine("------------------------------------------------");
/*result = graph2.ShortestPath(graph2.Nodes.ElementAt(0), graph2.Nodes.ElementAt(5));
Console.WriteLine(result.Count.ToString());
foreach (Node n in result)
{
Console.WriteLine(n.Data._street + " " + n.Data._streetNo);
}
foreach (Node n in graph2.Nodes)
{
Console.WriteLine(n.Data._street + " " + n.Data._streetNo);
}
Console.ReadLine();*/
/*IDBNode dbNode = new DBNode();
List<Node> nodes = dbNode.getAllNodes();
foreach(Node node in nodes)
{
Console.WriteLine("NodeID: "+node.Id);
Console.WriteLine("Street: "+node.Data._street);
Console.WriteLine("StreetNo: " + node.Data._streetNo);
Console.WriteLine("ZipCode: " + node.Data._zipCode);
}*/
IDBBattery dbbattery = new DBBattery();
/*List<Battery> battery = dbbattery.getAllBatteries();
battery.First()._status = Battery.Status.Booked;
dbbattery.updateBattery(battery.First());*/
Battery battery = new Battery(Battery.Status.Charged,new Station(1,"TRAFIKCENTER SÆBY SYD","20",9300));
/*IDBStation dbstation = new DBStation();
List<Station> stations = dbstation.getAllStations();
foreach (Station station in stations)
{
for (int i = 0; i < 10; i++)
{
dbbattery.createBattery(new Battery(Battery.Status.Charged, station));
}
}*/
/*if (dbbattery.createBattery(battery))
{
Console.WriteLine("Battery created in database");
List<Battery> batteries = dbbattery.getAllBatteries();
Console.WriteLine("-------------The new battery------------");
Console.WriteLine("ID: "+batteries.Last()._id.ToString());
Console.WriteLine("StationID: "+batteries.Last()._station._id.ToString());
Console.WriteLine("Status: "+batteries.Last()._status.ToString());
Console.WriteLine("----------------------------------------");
batteries.Last()._station = null;
batteries.Last()._status = Battery.Status.Booked;
if(dbbattery.updateBattery(batteries.Last()))
{
Console.WriteLine("Battery updated in database");
List<Battery> batteries2 = dbbattery.getAllBatteries();
Console.WriteLine("----------The updated battery------------");
Console.WriteLine("ID: " + batteries2.Last()._id.ToString());
//Console.WriteLine("StationID: " + batteries2.Last()._station.ToString());
Console.WriteLine("Status: " + batteries2.Last()._status.ToString());
Console.WriteLine("----------------------------------------");
if(dbbattery.deleteBattery(batteries2.Last()))
{
Console.WriteLine("Battery deleted in database");
List<Battery> batteries3 = dbbattery.getAllBatteries();
Console.WriteLine("----------The remaining batteries------------");
foreach (Battery battery1 in batteries3)
{
Console.WriteLine("ID: " + battery1._id.ToString());
//Console.WriteLine("StationID: " + batteries3.Last()._station.ToString());
Console.WriteLine("Status: " + battery1._status.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}*/
IDBCar dbcar = new DBCar();
Car car = new Car("dd12319",150,new Customer(1,"Jesper Vandborg","*****@*****.**"));
if (dbcar.createCar(car))
{
Console.WriteLine("Car created in database");
List<Car> Cars = dbcar.getAllCars();
Console.WriteLine("-------------The new car------------");
Console.WriteLine("ID: " + Cars.Last()._id.ToString());
Console.WriteLine("LicensPlate: " + Cars.Last()._licensPlate);
Console.WriteLine("Range: " + Cars.Last()._range);
Console.WriteLine("CustomerID : " + Cars.Last()._customer._id.ToString());
Console.WriteLine("----------------------------------------");
Cars.Last()._range = 100;
if (dbcar.updateCar(Cars.Last()))
{
Console.WriteLine("Car updated in database");
List<Car> Cars2 = dbcar.getAllCars();
Console.WriteLine("----------The updated car------------");
Console.WriteLine("ID: " + Cars2.Last()._id.ToString());
Console.WriteLine("LicensPlate: " + Cars2.Last()._licensPlate);
Console.WriteLine("Range: " + Cars2.Last()._range);
Console.WriteLine("CustomerID : " + Cars2.Last()._customer._id.ToString());
Console.WriteLine("----------------------------------------");
if (dbcar.deleteCar(Cars2.Last()))
{
Console.WriteLine("Car deleted in database");
List<Car> Cars3 = dbcar.getAllCars();
Console.WriteLine("----------The remaining cars------------");
foreach (Car car1 in Cars3)
{
Console.WriteLine("ID: " + car1._id.ToString());
Console.WriteLine("LicensPlate: " + car1._licensPlate);
Console.WriteLine("Range: " + car1._range);
Console.WriteLine("CustomerID : " + car1._customer._id.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}
/*IDBCustomer dbCustomer = new DBCustomer();
Customer Customer = new Customer("Charlotte Bust Sigvardt", "*****@*****.**");
if (dbCustomer.createCustomer(Customer))
{
Console.WriteLine("Customer created in database");
List<Customer> Customers = dbCustomer.getAllCustomers();
Console.WriteLine("-------------The new Customer------------");
Console.WriteLine("ID: " + Customers.Last()._id.ToString());
Console.WriteLine("Name: " + Customers.Last()._name);
Console.WriteLine("Email: " + Customers.Last()._email);
Console.WriteLine("----------------------------------------");
Customers.Last()._name = "Niels Hansen";
Customers.Last()._email = "*****@*****.**";
if (dbCustomer.updateCustomer(Customers.Last()))
{
Console.WriteLine("Customer updated in database");
List<Customer> Customers2 = dbCustomer.getAllCustomers();
Console.WriteLine("----------The updated Customer------------");
Console.WriteLine("ID: " + Customers2.Last()._id.ToString());
Console.WriteLine("Name: " + Customers2.Last()._name);
Console.WriteLine("Email: " + Customers2.Last()._email);
Console.WriteLine("----------------------------------------");
if (dbCustomer.deleteCustomer(Customers2.Last()))
{
Console.WriteLine("Customer deleted in database");
List<Customer> Customers3 = dbCustomer.getAllCustomers();
Console.WriteLine("----------The remaining Customers------------");
foreach (Customer Customer1 in Customers3)
{
Console.WriteLine("ID: " + Customer1._id.ToString());
Console.WriteLine("Name: " + Customer1._name);
Console.WriteLine("Email: " + Customer1._email);
}
Console.WriteLine("----------------------------------------");
}
}
}*/
/*IDBLocation dbLocation = new DBLocation();
Location Location = new Location("Løkkegade","21 3. th.",9000);
if (dbLocation.createLocation(Location))
{
Console.WriteLine("Location created in database");
List<Location> Locations = dbLocation.getAllLocations();
Console.WriteLine("-------------The new Location------------");
Console.WriteLine("ID: " + Locations.Last()._id.ToString());
Console.WriteLine("Street: " + Locations.Last()._street);
Console.WriteLine("StreetNo: " + Locations.Last()._streetNo);
Console.WriteLine("ZipCode: " + Locations.Last()._zipCode.ToString());
Console.WriteLine("----------------------------------------");
Locations.Last()._street = "Danmarksgade";
Locations.Last()._streetNo = "61, 1.";
if (dbLocation.updateLocation(Locations.Last()))
{
Console.WriteLine("Location updated in database");
List<Location> Locations2 = dbLocation.getAllLocations();
Console.WriteLine("----------The updated Location------------");
Console.WriteLine("ID: " + Locations2.Last()._id.ToString());
Console.WriteLine("Street: " + Locations2.Last()._street);
Console.WriteLine("StreetNo: " + Locations2.Last()._streetNo);
Console.WriteLine("ZipCode: " + Locations2.Last()._zipCode.ToString());
Console.WriteLine("----------------------------------------");
if (dbLocation.deleteLocation(Locations2.Last()))
{
Console.WriteLine("Location deleted in database");
List<Location> Locations3 = dbLocation.getAllLocations();
Console.WriteLine("----------The remaining Locations------------");
foreach (Location Location1 in Locations3)
{
Console.WriteLine("ID: " + Location1._id.ToString());
Console.WriteLine("Street: " + Location1._street);
Console.WriteLine("StreetNo: " + Location1._streetNo);
Console.WriteLine("ZipCode: " + Location1._zipCode.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}*/
/*IDBStation dbStation = new DBStation();
Station Station = new Station("Løkkegade", "21 3. th.", 9000);
if (dbStation.createStation(Station))
{
Console.WriteLine("Station created in database");
List<Station> Stations = dbStation.getAllStations();
Console.WriteLine("-------------The new Station------------");
Console.WriteLine("ID: " + Stations.Last()._id.ToString());
Console.WriteLine("Street: " + Stations.Last()._street);
Console.WriteLine("StreetNo: " + Stations.Last()._streetNo);
Console.WriteLine("ZipCode: " + Stations.Last()._zipCode.ToString());
Console.WriteLine("----------------------------------------");
Stations.Last()._street = "Danmarksgade";
Stations.Last()._streetNo = "61, 1.";
if (dbStation.updateStation(Stations.Last()))
{
Console.WriteLine("Station updated in database");
List<Station> Stations2 = dbStation.getAllStations();
Console.WriteLine("----------The updated Station------------");
Console.WriteLine("ID: " + Stations2.Last()._id.ToString());
Console.WriteLine("Street: " + Stations2.Last()._street);
Console.WriteLine("StreetNo: " + Stations2.Last()._streetNo);
Console.WriteLine("ZipCode: " + Stations2.Last()._zipCode.ToString());
Console.WriteLine("----------------------------------------");
if (dbStation.deleteStation(Stations2.Last()))
{
Console.WriteLine("Station deleted in database");
List<Station> Stations3 = dbStation.getAllStations();
Console.WriteLine("----------The remaining Stations------------");
foreach (Station Station1 in Stations3)
{
Console.WriteLine("ID: " + Station1._id.ToString());
Console.WriteLine("Street: " + Station1._street);
Console.WriteLine("StreetNo: " + Station1._streetNo);
Console.WriteLine("ZipCode: " + Station1._zipCode.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}*/
/*IDBRoute dbRoute = new DBRoute();
Route Route = new Route(DateTime.Now,DateTime.Now,new Location(1,"Løkkegade","21",9000),new Location(2,"Danmarksgade","69",9000),new Customer(1,"Jesper Vandborg","*****@*****.**"));
if (dbRoute.createRoute(Route))
{
Console.WriteLine("Route created in database");
List<Route> Routes = dbRoute.getAllRoutes();
Console.WriteLine("-------------The new Route------------");
Console.WriteLine("ID: " + Routes.Last()._id.ToString());
Console.WriteLine("StartDate: " + Routes.Last()._startDate.ToString());
Console.WriteLine("EndDate: " + Routes.Last()._endDate.ToString());
Console.WriteLine("StartAddressID: " + Routes.Last()._startAddress._id.ToString());
Console.WriteLine("EndAddressID: " + Routes.Last()._endAddress._id.ToString());
Console.WriteLine("----------------------------------------");
Routes.Last()._startDate = Convert.ToDateTime("2012-12-12 12:12:12");
Routes.Last()._endDate = Convert.ToDateTime("2012-12-12 12:12:12");
if (dbRoute.updateRoute(Routes.Last()))
{
Console.WriteLine("Route updated in database");
List<Route> Routes2 = dbRoute.getAllRoutes();
Console.WriteLine("----------The updated Route------------");
Console.WriteLine("ID: " + Routes2.Last()._id.ToString());
Console.WriteLine("StartDate: " + Routes2.Last()._startDate.ToString());
Console.WriteLine("EndDate: " + Routes2.Last()._endDate.ToString());
Console.WriteLine("StartAddressID: " + Routes2.Last()._startAddress._id.ToString());
Console.WriteLine("EndAddressID: " + Routes2.Last()._endAddress._id.ToString());
Console.WriteLine("----------------------------------------");
if (dbRoute.deleteRoute(Routes2.Last()))
{
Console.WriteLine("Route deleted in database");
List<Route> Routes3 = dbRoute.getAllRoutes();
Console.WriteLine("----------The remaining Routes------------");
foreach (Route Route1 in Routes3)
{
Console.WriteLine("ID: " + Route1._id.ToString());
Console.WriteLine("StartDate: " + Route1._startDate.ToString());
Console.WriteLine("EndDate: " + Route1._endDate.ToString());
Console.WriteLine("StartAddressID: " + Route1._startAddress._id.ToString());
Console.WriteLine("EndAddressID: " + Route1._endAddress._id.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}*/
/*IDBPartRoute dbPartRoute = new DBPartRoute();
PartRoute PartRoute = new PartRoute(DateTime.Now, new Battery(5, Battery.Status.Charged, new Station(1,"TRAFIKCENTER SÆBY SYD", "20", 9300)), new Route(2, Convert.ToDateTime("2012-12-12 12:12:13.000"), Convert.ToDateTime("2012-12-13 12:12:12.000"),new Location(1,"Løkkegade","21",9000),new Location(2,"Danmarksgade","69",9000),new Customer(1,"Jesper Vandborg","*****@*****.**")));
if (dbPartRoute.createPartRoute(PartRoute))
{
Console.WriteLine("PartRoute created in database");
List<PartRoute> PartRoutes = dbPartRoute.getAllPartRoutes();
Console.WriteLine("-------------The new PartRoute------------");
Console.WriteLine("ID: " + PartRoutes.Last()._id.ToString());
Console.WriteLine("PickUpTime: " + PartRoutes.Last()._pickUpTime.ToString());
Console.WriteLine("BatteryID: " + PartRoutes.Last()._battery._id.ToString());
Console.WriteLine("StationID: " + PartRoutes.Last()._battery._station._id.ToString());
Console.WriteLine("RouteID: " + PartRoutes.Last()._route._id.ToString());
Console.WriteLine("CustomerID: " + PartRoutes.Last()._route._customer._id.ToString());
Console.WriteLine("StartAddressID: " + PartRoutes.Last()._route._startAddress._id.ToString());
Console.WriteLine("endAddressID: " + PartRoutes.Last()._route._endAddress._id.ToString());
Console.WriteLine("----------------------------------------");
PartRoutes.Last()._pickUpTime = Convert.ToDateTime("2012-12-19 12:12:12");
if (dbPartRoute.updatePartRoute(PartRoutes.Last()))
{
Console.WriteLine("PartRoute updated in database");
List<PartRoute> PartRoutes2 = dbPartRoute.getAllPartRoutes();
Console.WriteLine("----------The updated PartRoute------------");
Console.WriteLine("ID: " + PartRoutes2.Last()._id.ToString());
Console.WriteLine("PickUpTime: " + PartRoutes2.Last()._pickUpTime.ToString());
Console.WriteLine("BatteryID: " + PartRoutes2.Last()._battery._id.ToString());
Console.WriteLine("StationID: " + PartRoutes2.Last()._battery._station._id.ToString());
Console.WriteLine("RouteID: " + PartRoutes2.Last()._route._id.ToString());
Console.WriteLine("CustomerID: " + PartRoutes2.Last()._route._customer._id.ToString());
Console.WriteLine("StartAddressID: " + PartRoutes2.Last()._route._startAddress._id.ToString());
Console.WriteLine("endAddressID: " + PartRoutes2.Last()._route._endAddress._id.ToString());
Console.WriteLine("----------------------------------------");
if (dbPartRoute.deletePartRoute(PartRoutes2.Last()))
{
Console.WriteLine("PartRoute deleted in database");
List<PartRoute> PartRoutes3 = dbPartRoute.getAllPartRoutes();
Console.WriteLine("----------The remaining PartRoutes------------");
foreach (PartRoute PartRoute1 in PartRoutes3)
{
Console.WriteLine("ID: " + PartRoute1._id.ToString());
Console.WriteLine("PickUpTime: " + PartRoute1._pickUpTime.ToString());
Console.WriteLine("BatteryID: " + PartRoute1._battery._id.ToString());
Console.WriteLine("StationID: " + PartRoute1._battery._station._id.ToString());
Console.WriteLine("RouteID: " + PartRoute1._route._id.ToString());
Console.WriteLine("CustomerID: " + PartRoute1._route._customer._id.ToString());
Console.WriteLine("StartAddressID: " + PartRoute1._route._startAddress._id.ToString());
Console.WriteLine("endAddressID: " + PartRoute1._route._endAddress._id.ToString());
}
Console.WriteLine("----------------------------------------");
}
}
}*/
/*IDBNode dbNode = new DBNode();
IDBNeighbors dbNeighbors = new DBNeighbors();
List<Node> testNodes = dbNode.getAllNodes();
Node testNode = dbNode.searchNodeID(6);
List<List<int>> Neighbors = dbNeighbors.getAllNeighbors(testNode);
foreach(List<int> list1 in Neighbors)
{
Console.WriteLine("--------------------");
foreach(int i in list1)
{
Console.WriteLine("Value: "+i.ToString());
}
Console.WriteLine("--------------------");
}*/
/*IDBNode dbnode = new DBNode();
List<Node> nodes = dbnode.getAllNodes();
string destination = "";
foreach (Node node in nodes)
{
destination += node.Data._street + "+" + node.Data._streetNo + "+" + node.Data._zipCode + "+danmark|";
}
destination = destination.Substring(0,destination.Length-1);
destination = "løkkegade+21+9000+danmark|danmarksgade+69+9000+danmark";
Debug.WriteLine(destination);
string origins = "Boulevarde+39+9000+danmark|langdyssen+2+7600+danmark";
string DownloadString = "E:/Windows/Documents/DM76-gruppe7/testjson.json";
WebClient webclient = new WebClient();
//dynamic result = JsonValue.Parse(webclient.DownloadString("https://maps.googleapis.com/maps/api/distancematrix/json?origins="+origins+"&destinations="+destination+"&mode=driving&language=da&sensor=false"));
dynamic result = JsonValue.Parse(webclient.DownloadString(DownloadString));
if (result.status=="OK")
{
for (int i = 0; i < result.rows.Count; i++)
{
for (int j = 0; j < result.rows[i].elements.Count; j++)
{
if (result.rows[i].elements[j].status=="OK")
{
if (result.rows[i].elements[j].distance.value > 100000 && result.rows[i].elements[j].distance.value<145000)
{
Console.WriteLine(j.ToString() + ": " + result.rows[i].elements[j].distance.value);
}
}
}
}
}*/
Console.ReadLine();
}
public void AddBattery(Battery battery)
{
_batteries.Add(battery);
}
public void RemoveBattery(Battery battery)
{
_batteries.Remove(battery);
}