Changeset 1454207 for FarmatikoData/FarmatikoRepo/Repository.cs

Timestamp:

10/01/20 03:17:09 (4 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

6f203af

Parents:

5d02859

Message:

Change structure, Add repo, services & controllers

File:

• FarmatikoData/FarmatikoRepo/Repository.cs (modified) (9 diffs)

FarmatikoData/FarmatikoRepo/Repository.cs

@@ -14 +14 @@
         }
         //GET
-        public async Task<IQueryable<HealthcareWorkers>> GetAllWorkers()
+        public async Task<IQueryable<HealthcareWorker>> GetAllWorkers()
         {
             var Workers = await Task.Run(() => _context.HealthcareWorkers.Take(10));
@@ -20 +20 @@
         }
 
-        public async Task<IQueryable<HealthFacilities>> GetFacilities()
+        public async Task<IQueryable<HealthFacility>> GetFacilities()
         {
             var Facilities = await Task.Run(() => _context.HealthFacilities.Take(10));
@@ -26 +26 @@
         }
 
-        public async Task<HealthFacilities> GetFacility(int Id)
+        public async Task<HealthFacility> GetFacility(int Id)
         {
             var Facility = await _context.HealthFacilities.FindAsync(Id);
@@ -62 +62 @@
         }
 
-        public async Task<HealthcareWorkers> GetWorker(int id)
+        public async Task<HealthcareWorker> GetWorker(int id)
         {
             var Worker = await _context.HealthcareWorkers.FindAsync(id);
@@ -68 +68 @@
         }
 
-        public async Task<IQueryable<HealthFacilities>> SearchFacilities(string query)
+        public async Task<IQueryable<HealthFacility>> SearchFacilities(string query)
         {
             var SearchQuery = await Task.Run(() => _context.HealthFacilities
@@ -95 +95 @@
         }
 
-        public async Task<IQueryable<HealthcareWorkers>> SearchWorkers(string query)
+        public async Task<IQueryable<HealthcareWorker>> SearchWorkers(string query)
         {
             var SearchQuery = await Task.Run(() => _context.HealthcareWorkers
@@ -103 +103 @@
             return SearchQuery;
         }
+        public async Task<HealthFacility> GetFacilityJSON(string healthFacility)
+        {
+            var Facility = await Task.Run(() => _context.HealthFacilities.Where(x => x.Name.Equals(healthFacility)).FirstOrDefault());
+            return Facility;
+        }
 
         //POST
 
-        public async Task AddWorker(HealthcareWorkers Worker)
+        public async Task AddWorker(HealthcareWorker Worker)
         {
             await Task.Run(() => _context.HealthcareWorkers.Add(Worker));
@@ -112 +117 @@
         }
 
-        public async Task AddFacility(HealthFacilities healthFacility)
+        public async Task AddFacility(HealthFacility healthFacility)
         {
             await Task.Run(() => _context.HealthFacilities.Add(healthFacility));
@@ -141 +146 @@
             await _context.SaveChangesAsync();
         }
+
+        public async Task UpdateFacility(HealthFacility healthFacility)
+        {
+            var Facility = await Task.Run(() => _context.HealthFacilities.Where(x => x.Id == healthFacility.Id).FirstOrDefault());
+            Facility.Address = healthFacility.Address;
+            Facility.Email = healthFacility.Email;
+            Facility.Municipality = healthFacility.Municipality;
+            Facility.Name = healthFacility.Name;
+            Facility.Phone = healthFacility.Phone;
+            Facility.Type = healthFacility.Type;
+            await _context.SaveChangesAsync();
+        }
+
+        public async Task RemoveMedicine(Medicine medicine)
+        {
+            await Task.Run(() => _context.Medicines.Remove(medicine));
+            await _context.SaveChangesAsync();
+        }
+
+        public async Task UpdatePandemic(Pandemic pandemic)
+        {
+            var Pandemic = await Task.Run(() => _context.Pandemics.Where(x => x.Id == pandemic.Id).FirstOrDefault());
+            Pandemic.ActiveGlobal = pandemic.ActiveGlobal;
+            Pandemic.ActiveMK = pandemic.ActiveMK;
+            Pandemic.DeathsGlobal = pandemic.DeathsGlobal;
+            Pandemic.DeathsMK = pandemic.DeathsMK;
+            Pandemic.Name = pandemic.Name;
+            Pandemic.NewMK = pandemic.NewMK;
+            Pandemic.TotalGlobal = pandemic.TotalGlobal;
+            Pandemic.TotalMK = pandemic.TotalMK;
+            await _context.SaveChangesAsync();
+        }
+
+        public async Task RemovePharmacy(Pharmacy pharmacy)
+        {
+            await Task.Run(() => _context.Pharmacies.Remove(pharmacy));
+            await _context.SaveChangesAsync();
+        }
+        //ke vidime
+        public Task UpdateWorker(HealthcareWorker worker)
+        {
+            throw new System.NotImplementedException();
+        }
+
+        public async Task UpadatePharmacy(Pharmacy pharmacy)
+        {
+            var Pharmacy = await Task.Run(() => _context.Pharmacies.Where(x => x.Id == pharmacy.Id).FirstOrDefault());
+            Pharmacy.Name = pharmacy.Name;
+            Pharmacy.Location = pharmacy.Location;
+            Pharmacy.WorkAllTime = pharmacy.WorkAllTime;
+            Pharmacy.Address = pharmacy.Address;
+            await _context.SaveChangesAsync();
+        }
+        //ke vidime
+        public Task UpdateMedicine(Medicine medicine)
+        {
+            throw new System.NotImplementedException();
+        }
+
+        public async Task RemovePharmacyHead(PharmacyHead pharmacyHead)
+        {
+            var PHead = await Task.Run(() => _context.PharmacyHeads.Where(x => x.Id == pharmacyHead.Id).FirstOrDefault());
+            PHead.DeletedOn = pharmacyHead.DeletedOn;
+            await _context.SaveChangesAsync();
+        }
+
     }
 }