public String getRoutes(string weight, string type, string height, string width, string depth, string from, string to) { List <List <PricedRouteSegment> > result = new List <List <PricedRouteSegment> >(); try { DatabaseWrapper db = new DatabaseWrapper(ConfigurationManager.AppSettings["DatabaseUserName"], ConfigurationManager.AppSettings["DatabasePassword"], ConfigurationManager.AppSettings["DatabaseConnectionURL"], ConfigurationManager.AppSettings["DatabaseTrustedConnection"].ToString(), ConfigurationManager.AppSettings["DatabaseName"].ToString(), Convert.ToInt32(ConfigurationManager.AppSettings["DatabaseConnectionTimeOut"])); db.OpenConnection(); var testpricemultiplier = db.GetTypeCost("Recorded"); db.CloseConnection(); db.OpenConnection(); var telstar = db.GetOwnPricedSegments(testpricemultiplier); db.CloseConnection(); ConnectorController connector = new ConnectorController(); var oceanic = connector.GetOceanicRoutes(Convert.ToDouble(weight), type, Convert.ToDouble(height), Convert.ToDouble(width), Convert.ToDouble(depth)); var eastindia = connector.GetEastIndiaRoutes(Convert.ToDouble(weight), type, "11-16-2018"); var map = telstar.Concat(oceanic).Concat(eastindia).ToList(); ShortestPathCalculator fastPath = new ShortestPathCalculator(); fastPath.SetUpEdgesAndCosts(map, true); var fastestPath = fastPath.CalculateShortestPath(from, to); ShortestPathCalculator cheapPath = new ShortestPathCalculator(); cheapPath.SetUpEdgesAndCosts(map, false); var cheapestPath = cheapPath.CalculateShortestPath(from, to); result.Add(fastestPath); result.Add(cheapestPath); return(JsonConvert.SerializeObject(result)); } catch { return(JsonConvert.SerializeObject(result)); } }
public string getCities() { List <String> cities = new List <string>(); var eastindia = GetEastIndiaRoutes(5, "Live animals", "10-10-2010"); foreach (var path in eastindia) { cities.Add(path.FromCity); cities.Add(path.ToCity); } var oceanic = GetOceanicRoutes(5, "Live animals", 10, 10, 10); foreach (var path in oceanic) { cities.Add(path.FromCity); cities.Add(path.ToCity); } DatabaseWrapper db = new DatabaseWrapper(ConfigurationManager.AppSettings["DatabaseUserName"], ConfigurationManager.AppSettings["DatabasePassword"], ConfigurationManager.AppSettings["DatabaseConnectionURL"], ConfigurationManager.AppSettings["DatabaseTrustedConnection"].ToString(), ConfigurationManager.AppSettings["DatabaseName"].ToString(), Convert.ToInt32(ConfigurationManager.AppSettings["DatabaseConnectionTimeOut"])); db.OpenConnection(); var telstar = db.GetOwnPricedSegments(10); db.CloseConnection(); foreach (var path in telstar) { cities.Add(path.FromCity); cities.Add(path.ToCity); } var noDups = cities.Distinct().ToList(); return(JsonConvert.SerializeObject(noDups)); }
public List <PricedRouteSegment> Get(int weight, String ParcelType) { if (weight <= 40 && ParcelType != "Weapons") { DatabaseWrapper db = new DatabaseWrapper(ConfigurationManager.AppSettings["DatabaseUserName"], ConfigurationManager.AppSettings["DatabasePassword"], ConfigurationManager.AppSettings["DatabaseConnectionURL"], ConfigurationManager.AppSettings["DatabaseTrustedConnection"].ToString(), ConfigurationManager.AppSettings["DatabaseName"].ToString(), Convert.ToInt32(ConfigurationManager.AppSettings["DatabaseConnectionTimeOut"])); db.OpenConnection(); var test = db.GetTypeCost(ParcelType); db.CloseConnection(); db.OpenConnection(); var result = db.GetOwnPricedSegments(test); db.CloseConnection(); return(result); } else { return(null); } }