public static async Task EventAsync(HttpClient client, Event ev)
{
//
try
{
string uuri = $"https://kudago.com/public-api/v1.4/events/{ev.id}/?lang=&fields=&expand=";
var stringTask = client.GetStringAsync(uuri);
var msg = await stringTask;
if (msg != null)
{
Event_desc evdesc = JsonConvert.DeserializeObject <Event_desc>(msg);
if (evdesc.place != null)
{
PlaceAsync(client, evdesc).Wait();
}
}
else
{
//
}
}
catch (Exception ex)
{
//
}
}
public static async Task PlaceAsync(HttpClient client, Event_desc evdesc)
{
int pid = evdesc.place["id"];
string uuri = $"https://kudago.com/public-api/v1.4/places/{pid}/?lang=&fields=&expand=";
var stringTask = client.GetStringAsync(uuri);
var msg = await stringTask;
Place plc = JsonConvert.DeserializeObject <Place>(msg);
File.AppendAllText("res.txt", SQLWriteEvent(evdesc, plc.coords));
}
public static string SQLWriteEvent(Event_desc evdesc, GPoint p)
{
try
{
Dictionary <string, long> dd = evdesc.dates[0];
return($"INSERT INTO events(out_id, title, descr, categories, coords, url, start_date, end_date) " +
$"VALUES ({evdesc.id}, \'{Regex.Escape(evdesc.title)}\', \'{Regex.Escape(evdesc.description)}\', \'{String.Join(", ", evdesc.categories)}\', {p.ToString()}, \'{Regex.Escape(evdesc.site_url)}\', FROM_UNIXTIME({dd["start"]}), FROM_UNIXTIME({dd["end"]}));");
}
catch (Exception ex)
{
return("");
}
}