Changeset c73269d for FarmatikoServices

Timestamp:

07/31/20 20:30:41 (4 years ago)

Author:

Mile Jankuloski <mile.jankuloski@…>

Branches:

master

Children:

a6bbad1, ee137aa

Parents:

d8fafb8

Message:

JSON processing added

File:

• FarmatikoServices/Services/ProcessJSONService.cs (modified) (3 diffs)

FarmatikoServices/Services/ProcessJSONService.cs

@@ -15 +15 @@
     public class ProcessJSONService : IProcessJSONService
     {
-        private IHealthFacilityRepository _healthFacilityRepository;
+        //private IHealthFacilityRepository _healthFacilityRepository;
+        private IPandemicRepository _pandemicRepository;
+        //private IHealthcareWorkerRepository _healthcareWorkerRepository;
+        //private IMedicineRepository _medicineRepository;
         //private readonly ILogger _logger;
-        public ProcessJSONService(IHealthFacilityRepository healthFacilityRepository)
+        public ProcessJSONService(/*IHealthFacilityRepository healthFacilityRepository, */IPandemicRepository pandemicRepository/*,
+            IHealthcareWorkerRepository healthcareWorkerRepository, IMedicineRepository medicineRepository*/)
         {
             //_logger = logger;
-            _healthFacilityRepository = healthFacilityRepository;
+            //_healthFacilityRepository = healthFacilityRepository;
+            _pandemicRepository = pandemicRepository;
+            //_healthcareWorkerRepository = healthcareWorkerRepository;
+            //_medicineRepository = medicineRepository;
         }
         
@@ -27 +34 @@
             try
             {
-                var client = new WebClient();
-                var json = client.DownloadString(@"C:\Users\dslez\Desktop\ustanovi.json");
+                /*var client = new WebClient();
+                var json = client.DownloadString(@"C:\Users\Miki\Desktop\ustanovi.json");
 
                 var jsonResponse = JObject.Parse(json);
                 var records = JArray.Parse(jsonResponse.GetValue("records").ToString());
-
 
                 foreach(var rec in records)
@@ -50 +56 @@
                     healthFacility.Phone = Phone;
                     healthFacility.Type = Type;
-                    var obje = healthFacility;
                     _healthFacilityRepository.Add(healthFacility);
                     
+                }*/
+
+
+
+                var client1 = new RestClient("https://api.covid19api.com/summary");
+                var response = client1.Execute(new RestRequest());
+                string original = response.Content;
+                var jsonResponsePandemic = JObject.Parse(original);
+                var global = JObject.Parse(jsonResponsePandemic.GetValue("Global").ToString());
+                var TotalConfirmed = long.Parse(global.GetValue("TotalConfirmed").ToString());
+                var TotalDeaths = long.Parse(global.GetValue("TotalDeaths").ToString());
+                var TotalRecovered = long.Parse(global.GetValue("TotalRecovered").ToString());
+
+                var mk = JArray.Parse(jsonResponsePandemic.GetValue("Countries").ToString());
+                dynamic objP = mk[100];
+                var TotalMk = Int32.Parse(objP.GetValue("TotalConfirmed").ToString());
+                var TotalDeathsMK = Int32.Parse(objP.GetValue("TotalDeaths").ToString());
+                var TotalRecoveredMK = Int32.Parse(objP.GetValue("TotalRecovered").ToString());
+                var NewMK = Int32.Parse(objP.GetValue("NewConfirmed").ToString());
+
+                Pandemic pandemic = new Pandemic();
+                pandemic.TotalGlobal = TotalConfirmed;
+                pandemic.ActiveGlobal = TotalConfirmed - (TotalRecovered + TotalDeaths);
+                pandemic.DeathsGlobal = TotalDeaths;
+                pandemic.TotalMK = TotalMk;
+                pandemic.ActiveMK = TotalMk - (TotalRecoveredMK + TotalDeathsMK);
+                pandemic.DeathsMK = TotalDeathsMK;
+                pandemic.NewMK = NewMK;
+                pandemic.Name = "Coronavirus";
+                _pandemicRepository.Add(pandemic);
+
+
+
+                /*var jsonW = client.DownloadString(@"C:\Users\Miki\Desktop\rabotnici.json");
+
+                var jsonResponseW = JObject.Parse(jsonW);
+                var recordsW = JArray.Parse(jsonResponseW.GetValue("records").ToString());
+
+                foreach (var rec in recordsW)
+                {
+                    dynamic obj = JsonConvert.DeserializeObject(rec.ToString());
+                    var Name = obj[4];
+                    var Branch = obj[2];
+                    HealthFacilities facility = new HealthFacilities();
+                    facility.Name = obj[1];
+                    facility.Municipality = "WorkerFacilityMunicipality";
+                    facility.Address = "WorkerFacilityAddress";
+                    var Title = obj[3];
+                    HealthcareWorkers healthcareWorker = new HealthcareWorkers();
+                    healthcareWorker.Name = Name;
+                    healthcareWorker.Branch = Branch;
+                    healthcareWorker.Facility = facility;
+                    healthcareWorker.Title = Title;
+                    _healthcareWorkerRepository.Add(healthcareWorker);
                 }
 
 
 
-                /*var client1 = new RestClient("https://api.covid19api.com/summary");
-                var response = client1.Execute(new RestRequest());
-                string original = response.Content;
-                var jsonResponse = JObject.Parse(original);
-                var global = JObject.Parse(jsonResponse.GetValue("Global").ToString());
-                var total = Int32.Parse(global.GetValue("TotalConfirmed").ToString());
-                Pandemic pandemic = new Pandemic();
-                pandemic.TotalGlobal = total;*/
+                var jsonM = client.DownloadString(@"C:\Users\Miki\Desktop\lekovi.json");
+
+                var jsonResponseM = JObject.Parse(jsonM);
+                var recordsM = JArray.Parse(jsonResponseM.GetValue("records").ToString());
+
+                foreach (var rec in recordsM)
+                {
+                    dynamic obj = JsonConvert.DeserializeObject(rec.ToString());
+                    var Name = obj[1];
+                    var Strength = obj[7];
+                    var Form = obj[6];
+                    var WayOfIssuing = obj[9];
+                    var Manufacturer = obj[11];
+                    var Price = float.Parse(obj[17]);
+                    var Packaging = obj[8];
+                    Medicine medicine = new Medicine();
+                    medicine.Name = Name;
+                    medicine.Strength = Strength;
+                    medicine.Form = Form;
+                    medicine.WayOfIssuing = WayOfIssuing;
+                    medicine.Manufacturer = Manufacturer;
+                    medicine.Price = Price;
+                    medicine.Packaging = Packaging;
+                    _medicineRepository.Add(medicine);
+                }*/
+
 
             }