Changeset 6f203af for FarmatikoServices/Services/ProcessJSONService.cs

Timestamp:

10/28/20 22:06:48 (3 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

993189e

Parents:

1454207

Message:

Change methods & add error controller

File:

• FarmatikoServices/Services/ProcessJSONService.cs (modified) (1 diff)

FarmatikoServices/Services/ProcessJSONService.cs

@@ -29 +29 @@
         public async Task<Medicine> ReadPharmaciesFromExcel()
         {
-            var client = new WebClient();
-            string Path = client.DownloadString(@"C:\Users\dslez\Desktop\apteki-fzo.xlsx");
-            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()
+            try
+            {
+                var client = new WebClient();
+                string Path = client.DownloadString(@"C:\Users\dslez\Desktop\apteki-fzo.xlsx");
+                using (var package = new ExcelPackage(new FileInfo(Path)))
+                {
+                    var Sheet = package.Workbook.Worksheets[1];
+                    for (int i = 2; i < Sheet.Dimension.End.Row; ++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);
-                }
+                        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
+                        };
+                        await _service.AddPharmacy(pharmacy);
+                    }
+                }
+
+            }
+            catch(Exception e)
+            {
+                _logger.LogInformation(e.Message);
+                throw new Exception("Cannot process Medicines from Excel.");
             }
             return null;