public async Task ParseAndPush()
{
WebClient client = new WebClient();
client.Encoding = Encoding.UTF8;
string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/2263/rows?$top=10&api_key=c941a998bbb9e1e374fc2d7a33f61ed0");
List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result);
var optionsBuilder = new DbContextOptionsBuilder <MInstituteContext>();
string newPath = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\"));
string newnewpath = Path.Combine(newPath, "MoscowInstitutes.WebService", "MoscowInstitutes.db");
optionsBuilder.UseSqlite($"Data Source={newnewpath}");
var context = new MInstituteContext(options: optionsBuilder.Options);
context.Database.ExecuteSqlRaw("DELETE FROM MoscowInstitutes");
using (context)
{
foreach (var item in resultServer)
{
MoscowInstitute.DomainObjects.MoscowInstitute moscowinstitute = new MoscowInstitute.DomainObjects.MoscowInstitute();
moscowinstitute.ShortName = item.Cells.ShortName;
moscowinstitute.WebSite = item.Cells.WebSite;
moscowinstitute.ChiefName = item.Cells.ChiefName;
moscowinstitute.LegalAddress = item.Cells.LegalAddress;
context.Entry(moscowinstitute).State = EntityState.Added;
context.SaveChanges();
}
}
await Task.CompletedTask;
}
void ParseAndPush()
{
WebClient client = new WebClient();
client.Encoding = Encoding.UTF8;
string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/2263/rows?$top=10&api_key=c941a998bbb9e1e374fc2d7a33f61ed0");
List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result);
using (var context = new MInstituteContext())
{
foreach (var item in resultServer)
{
MoscowInstitute.DomainObjects.MoscowInstitute moscowinstitute = new MoscowInstitute.DomainObjects.MoscowInstitute();
moscowinstitute.ShortName = item.Cells.ShortName;
moscowinstitute.WebSite = item.Cells.WebSite;
moscowinstitute.ChiefName = item.Cells.ChiefName;
moscowinstitute.LegalAddress = item.Cells.LegalAddress;
context.MoscowInstitutes.Add(moscowinstitute);
context.SaveChanges();
}
}
//Console.WriteLine(resultServer.Cells.AdmArea);
}
