Changeset e0cdea2 for FarmatikoServices/Services/ProcessJSONService.cs

Timestamp:

02/08/21 16:39:25 (3 years ago)

Author:

Dimitar Slezenkovski <dslezenkovski@…>

Branches:

master

Children:

8eb1e21, dae4cde

Parents:

0a694bb

Message:

Fix all bugs

File:

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

FarmatikoServices/Services/ProcessJSONService.cs

@@ -1 @@
-using FarmatikoData.FarmatikoRepoInterfaces;
-using FarmatikoData.Models;
-using System.Collections.Generic;
+using FarmatikoData.Models;
 using Newtonsoft.Json;
 using Newtonsoft.Json.Linq;
@@ -13 +11 @@
 using OfficeOpenXml;
 using System.IO;
-using Microsoft.VisualBasic;
+using GemBox.Spreadsheet;
+using System.Text;
 
 namespace FarmatikoServices.Services
@@ -28 +27 @@
         }
         //Excel reader
-        private async Task<bool> ReadPharmaciesFromExcel(string Path)
-        {
-            using (var package = new ExcelPackage(new FileInfo(Path)))
-            {
-                var Sheet = package.Workbook.Worksheets[1];
-                for (int i = 2; i < Sheet.Dimension.End.Row; ++i)
-                {
-                    Pharmacy pharmacy = new Pharmacy()
+        private bool ReadPharmaciesFromExcel(string Path)
+        {
+            string path = Directory.GetCurrentDirectory() + @"\ExcellDocs\1.xlsx";
+
+            FileInfo fileInfo = new FileInfo(path);
+            if (fileInfo != null)
+            {
+                using (var package = new ExcelPackage(fileInfo))
+                {
+                    var Sheet = package.Workbook.Worksheets.First();
+                    //var table = Sheet.Tables.First();
+                    int rowCount = Sheet.Dimension.End.Row;
+                    for (int i = 2; i < rowCount; ++i)
                     {
-                        Name = Sheet.Cells[i, 2].Value.ToString(),
-                        Address = Sheet.Cells[i, 3].Value.ToString(),
-                        Location = Sheet.Cells[i, 4].Value.ToString(),
-                        WorkAllTime = false
-                    };
-                    await _service.AddPharmacy(pharmacy);
+                        //Console.WriteLine();
+                        Pharmacy pharmacy = new Pharmacy()
+                        {
+                            Name = Sheet.Cells[i, 2].Value.ToString(),
+                            Address = Sheet.Cells[i, 3].Value.ToString(),
+                            Location = Sheet.Cells[i, 4].Value.ToString(),
+                            WorkAllTime = false
+                        };
+                        _service.AddPharmacy(pharmacy);
+                    }
                     return true;
                 }
-            }
+
+            }
+            
             return false;
-        }
-        public async void DownloadPharmaciesExcel()
+
+        }
+        public void DownloadPharmaciesExcel()
         {
             try
@@ -56 +67 @@
                 string pathToSave2 = Directory.GetCurrentDirectory() + @"\ExcellDocs\2.xlsx";
                 var client = new WebClient();
-                string url1 = "http://data.gov.mk/dataset/d84c31d9-e749-4b17-9faf-a5b4db3e7a70/resource/ce446f5c-e541-46f6-9e8c-67568059cbc6/download/registar-na-apteki-vnatre-vo-mreza-na-fzo-12.08.2020.xlsx";
-                string url2 = "http://data.gov.mk/dataset/d84c31d9-e749-4b17-9faf-a5b4db3e7a70/resource/a16379b4-ec81-4de7-994d-0ee503d71b55/download/registar-na-apteki-nadvor-od-mreza-na-fzo-12.08.2020.xlsx";
+                string url1 = "http://data.gov.mk/dataset/d84c31d9-e749-4b17-9faf-a5b4db3e7a70/resource/4806b744-f6f6-42d0-b0f0-d82e66d3b177/download/-.xlsxs";
+                /*string url2 = "http://data.gov.mk/dataset/d84c31d9-e749-4b17-9faf-a5b4db3e7a70/resource/a16379b4-ec81-4de7-994d-0ee503d71b55/download/registar-na-apteki-nadvor-od-mreza-na-fzo-12.08.2020.xlsx";*/
                 Uri uri1 = new Uri(url1);
-                Uri uri2 = new Uri(url2);
-                client.DownloadFile(uri1, @pathToSave1);
-                client.DownloadFile(uri2, @pathToSave2);
-
-
-                bool Success = await ReadPharmaciesFromExcel(pathToSave1);
+                //Uri uri2 = new Uri(url2);
+                client.DownloadFileAsync(uri1, pathToSave1);
+                //client.DownloadFile(uri2, @pathToSave2);
+
+
+                bool Success = ReadPharmaciesFromExcel(pathToSave1);
                 _logger.LogInformation(Success.ToString() + "1");
-                Success = await ReadPharmaciesFromExcel(pathToSave2);
-                _logger.LogInformation(Success.ToString() + "2");
-            }
-            catch (Exception e)
-            {
-                _logger.LogInformation(e.Message);
-                throw new Exception("Cannot process Medicines from Excel.");
+               /* Success = await ReadPharmaciesFromExcel(pathToSave2);
+                _logger.LogInformation(Success.ToString() + "2");*/
+            }
+            catch (Exception e)
+            {
+                _logger.LogInformation(e.Message);
+                throw new Exception("Cannot process Pharmacies from Excel.");
             }
         }