// GET: /TheLast/Execute
public IActionResult Execute1()
{
ViewBag.def = 5;
IPinfo3 newIPinfo = new IPinfo3();
return(View(newIPinfo));
}
// POST: /TheLast/Execute
public IActionResult Execute(string inputString)
{
//IPaddr IPaddrInput = new IPaddr();
//IPaddrInput.IPaddrInput = inputString;
//if (ModelState.IsValid)
//{
IPAddress wynikowy;
IPAddress.TryParse(inputString, out wynikowy);
List <string> IPpartsList = GetIpaddressToList(inputString);
double translatedIPaddress = TranslateIPaddress(IPpartsList);
string ipToCheck = translatedIPaddress.ToString();
//Connnection
NpgsqlConnection connection = new NpgsqlConnection("Server=127.0.0.1;UserId=postgres;Password=postgres;Database=ip2location");
//connection.Open();
String query = "select * from ip2location_db11 where '" + ipToCheck + "' between ip_from and ip_to";
NpgsqlCommand cmd = new NpgsqlCommand(query, connection);
IPinfo3 IPdata = new IPinfo3();
IPdata.ipaddress = wynikowy.ToString();
//var model = new IPinfo();
using (connection)
{
connection.Open();
NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
IPdata.countryName = (String)rdr["country_name"];
IPdata.countryCode = (String)rdr["country_code"];
IPdata.regionName = (String)rdr["region_name"];
IPdata.cityName = (String)rdr["city_name"];
IPdata.zipCode = (String)rdr["zip_code"];
IPdata.longitude = (float)rdr["longitude"];
IPdata.latitude = (float)rdr["latitude"];
IPdata.timeZone = (String)rdr["time_zone"];
}
connection.Close();
//}
return(View(IPdata));
}
//return View(IPaddrInput);
}
