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