public static void getEcharger(dynamic step)
{
string currLat;
string currLong;
string temp;
List <string> estations = new List <String>();
string[] old_new = step.Split(';');
//nur für hinteren teil brauchen wir coords
string[] coords = old_new[old_new.Length - 1].Split(',');
currLat = coords[0];
currLong = coords[1];
temp = LatLongConverter.GeoDec2Mercator(currLat, currLong);
estations = EvsesData.dbConnection(temp, auto.plug);
counter = 0;
for (var i = 0; i < estations.Count; i++)
{
string testString = "http://127.0.0.1:7133/route/v1/driving/" + step + ";" + estations[i] + "?overview=false&alternatives=true&steps=true";
stationCount = testString.Count(c => c == ';');
GetRequest(testString);
if (counter > 0)
{
counter = 0;
GetRequest("http://127.0.0.1:7133/route/v1/driving/" + estations[i] + ";" + end + "?overview=false&alternatives=true&steps=true");
if (counter > 0)
{
start = start + ";" + estations[i];
finalRoute(start);
}
}
}
}
//TODO
public static List <String> dbConnection(String latlong, String carType)
{
List <String> evsesData = new List <String>();
string[] coords = latlong.Split(',');
double lat = Convert.ToDouble(coords[0]);
double lon = Convert.ToDouble(coords[1]);
//string queryString = "SELECT * FROM [st_data].[se].basisinfo where xkoord <> '' and ykoord <> '' and xkoord between " + (lat - 20000) + " and " + (lat + 20000) + " and ykoord between " + (lon - 20000) + " and " + (lon + 20000);
string connectionString = "Server=ymtestdb1;Database=;User Id=se;Password=se;";
Int32 count = 0;
x = 0;
while (count < 2)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
x = x + 1000;
SqlCommand cmd = new SqlCommand("SELECT COUNT (DISTINCT xkoord) FROM [st_data].[se].basisinfo JOIN [st_data].[se].PlugInfo on [st_data].[se].basisinfo.ebinr = [st_data].[se].pluginfo.EBINr JOIN [st_data].[se].PlugSearch on [st_data].[se].pluginfo.plugid = [st_data].[se].plugsearch.plugid inner join [st_data].[se].BCKlartext on [st_data].[se].PlugSearch.PlugBCCode = [st_data].[se].BCKlartext.BCCode where xkoord between " + (lat - x) + " and " + (lat + x) + " and ykoord between " + (lon - x) + " and " + (lon + x) + " and [st_data].[se].BCKlartext.Beschreibung LIKE '%Typ2%'", connection);
connection.Open();
count = Convert.ToInt32(cmd.ExecuteScalar());
}
}
string queryString = "SELECT DISTINCT TOP 20 xkoord,ykoord FROM [st_data].[se].basisinfo JOIN [st_data].[se].PlugInfo on [st_data].[se].basisinfo.ebinr = [st_data].[se].pluginfo.EBINr JOIN [st_data].[se].PlugSearch on [st_data].[se].pluginfo.plugid = [st_data].[se].plugsearch.plugid inner join [st_data].[se].BCKlartext on [st_data].[se].PlugSearch.PlugBCCode = [st_data].[se].BCKlartext.BCCode where xkoord between " + (lat - x) + " and " + (lat + x) + " and ykoord between " + (lon - x) + " and " + (lon + x) + " and [st_data].[se].BCKlartext.Beschreibung LIKE '%Typ2%'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
String xkoord = "", ykoord = "";
xkoord = Convert.ToString(reader["xkoord"]);
ykoord = Convert.ToString(reader["ykoord"]);
String temp = "";
temp = LatLongConverter.Mercator2GeoDec(xkoord, ykoord);
evsesData.Add(temp);
Console.WriteLine(temp);
//Console.WriteLine(String.Format("{0}, {1}",
//reader["xkoord"], reader["ykoord"]));
}
return(evsesData);
}
finally
{
// Always call Close when done reading.
reader.Close();
//foreach (var koord in evsesData)
//{
//Console.WriteLine(koord);
//}
}
}
}
public static void dbConnection()
{
List <String> converted = new List <String>();
string queryString = "SELECT TOP 20 xkoord,ykoord FROM [st_data].[se].basisinfo where xkoord <> '' and ykoord <> '' and (PLZ Like '7%' or PLZ like '8%') and (land = 'D' or land = 'DE')";
string connectionString = "Server=ymtestdb1;Database=;User Id=se;Password=se;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
String xkoord = "", ykoord = "";
xkoord = Convert.ToString(reader["xkoord"]);
ykoord = Convert.ToString(reader["ykoord"]);
//Console.WriteLine(xkoord);
//Console.WriteLine(ykoord);
//YM.Geo.CUtilityGeo cUtilityGeo = new YM.Geo.CUtilityGeo();
//cUtilityGeo.Transform(ref xkoord, ref ykoord, YM.Geo.CUtilityGeo.COORD_FORMAT.MERCATOR, YM.Geo.CUtilityGeo.COORD_FORMAT.GEODECIMAL, YM.Geo.CUtilityGeo.COORD_ZONE.Default, YM.Geo.CUtilityGeo.COORD_ZONE.Default);
String temp = "";
temp = LatLongConverter.Mercator2GeoDec(xkoord, ykoord);
Console.WriteLine(temp);
converted.Add(temp);
//Console.WriteLine(String.Format("{0}, {1}",
//reader["xkoord"], reader["ykoord"]));
}
}
finally
{
// Always call Close when done reading.
reader.Close();
foreach (var koord in converted)
{
//Console.WriteLine(koord);
}
}
}
}
public static List <String> dbConnection(String plz)
{
List <String> evsesData = new List <String>();
string queryString = "SELECT DISTINCT TOP 20 xkoord,ykoord FROM [st_data].[se].basisinfo where xkoord <> '' and ykoord <> '' and (PLZ Like '" + plz.Substring(0, 2) + "%') and (land = 'D' or land = 'DE')";
string connectionString = "Server=ymtestdb1;Database=;User Id=se;Password=se;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
String xkoord = "", ykoord = "";
xkoord = Convert.ToString(reader["xkoord"]);
ykoord = Convert.ToString(reader["ykoord"]);
String temp = "";
temp = LatLongConverter.Mercator2GeoDec(xkoord, ykoord);
evsesData.Add(temp);
Console.WriteLine(temp);
//Console.WriteLine(String.Format("{0}, {1}",
//reader["xkoord"], reader["ykoord"]));
}
return(evsesData);
}
finally
{
// Always call Close when done reading.
reader.Close();
//foreach (var koord in evsesData)
//{
//Console.WriteLine(koord);
//}
}
}
}