private void btn1_Click(object sender, RoutedEventArgs e)
{
WebClient client = new WebClient();
client.Encoding = Encoding.UTF8;
string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/841/rows?$top=1000&api_key=c941a998bbb9e1e374fc2d7a33f61ed0");
List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result);
var optionsBuilder = new DbContextOptionsBuilder <TrafficRestrictionContext>();
string newPath = System.IO.Path.GetFullPath(System.IO.Path.Combine(Directory.GetCurrentDirectory(), @"..\..\..\..\"));
string newnewpath = System.IO.Path.Combine(newPath, "MoscowTrafficRestriction.WebService", "MoscowTrafficRestriction.db");
optionsBuilder.UseSqlite($"Data Source={newnewpath}");
var context = new TrafficRestrictionContext(options: optionsBuilder.Options);
context.Database.ExecuteSqlRaw("DELETE FROM TrafficRestrictions");
using (context)
{
foreach (var item in resultServer)
{
DomainObjects.TrafficRestriction trafficRestriction = new DomainObjects.TrafficRestriction();
trafficRestriction.Name = item.Cells.Name;
trafficRestriction.DescriptionLocation = item.Cells.DescriptionLocation;
trafficRestriction.PayWay = item.Cells.PayWay;
trafficRestriction.IntercityConnectionPayment = item.Cells.IntercityConnectionPayment;
trafficRestriction.ValidUniversalServicesCard = item.Cells.ValidUniversalServicesCard;
context.Entry(trafficRestriction).State = EntityState.Added;
context.SaveChanges();
}
}
}
public override Task ProcessInScope(IServiceProvider serviceProvider)
{
WebClient client = new WebClient();
client.Encoding = Encoding.UTF8;
string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/1983/rows?$top=1000&api_key=c941a998bbb9e1e374fc2d7a33f61ed0");
List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result);
var optionsBuilder = new DbContextOptionsBuilder <TrafficRestrictionContext>();
string newPath = System.IO.Path.GetFullPath(System.IO.Path.Combine(Directory.GetCurrentDirectory(), @"..\"));
string newnewpath = System.IO.Path.Combine(newPath, "MoscowInstitute.WebService", "MoscowTrafficRestriction.db");
optionsBuilder.UseSqlite($"Data Source={newnewpath}");
var context = new TrafficRestrictionContext(options: optionsBuilder.Options);
context.Database.ExecuteSqlRaw("DELETE FROM TrafficRestrictions");
using (context)
{
foreach (var item in resultServer)
{
DomainObjects.TrafficRestriction trafficRestriction = new DomainObjects.TrafficRestriction();
trafficRestriction.NameOfManagingOrg = item.Cells.NameOfManagingOrg;
trafficRestriction.Year = item.Cells.Year;
trafficRestriction.INN = item.Cells.INN;
trafficRestriction.IssuedPrescriptions = item.Cells.IssuedPrescriptions;
trafficRestriction.ViolationsAmount = item.Cells.ViolationsAmount;
trafficRestriction.ProtocolsComposed = item.Cells.ProtocolsComposed;
trafficRestriction.EventsExecuted = item.Cells.EventsExecuted;
trafficRestriction.EventsNotExecutedInTime = item.Cells.EventsNotExecutedInTime;
trafficRestriction.ProtocolsComposedForFailure = item.Cells.ProtocolsComposedForFailure;
trafficRestriction.SumOfFine = item.Cells.SumOfFine;
trafficRestriction.global_id = item.Cells.global_id;
context.Entry(trafficRestriction).State = EntityState.Added;
context.SaveChanges();
}
}
Console.WriteLine("Updated db.");
return(Task.CompletedTask);
}
