Changeset 63d885e for FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs

Timestamp:

08/07/20 11:01:25 (4 years ago)

Author:

Mile Jankuloski <mile.jankuloski@…>

Branches:

master

Children:

5d02859

Parents:

ee137aa (diff), c406ae5 (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the (diff) links above to see all the changes relative to each parent.

Message:

Merge branch 'master' of ​https://develop.finki.ukim.mk/git/farmatiko

File:

• FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs (modified) (1 diff)

FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs

@@ -16 +16 @@
         public void Add(HealthFacilities healthFacility)
         {
-            _context.Add(healthFacility);
-            _context.SaveChanges();
+             _context.HealthFacilities.Add(healthFacility);
+            _context.SaveChangesAsync();
         }
 
         public IQueryable<HealthFacilities> GetAll()
         {
-            return _context.HealthFacilities.OrderBy(x => x.Name);
+            return _context.HealthFacilities.Take(50).Select(x => new HealthFacilities
+            {
+                Name = x.Name,
+                Municipality = x.Municipality,
+                Address = x.Address,
+                Type = x.Type,
+                Email = x.Email,
+                Phone = x.Phone
+            }).OrderBy(x => x.Name);
+        }
+
+        public IQueryable<HealthFacilities> GetByName(string Name)
+        {
+            return _context.HealthFacilities.Where(x => x.Name.Equals(Name));
         }
 
         public void Remove(HealthFacilities healthFacility)
         {
-            var facility = _context.HealthFacilities.Where(x => x.Name.Equals(healthFacility.Name));
-            _context.HealthFacilities.Remove((HealthFacilities)facility);
+            var facility = _context.HealthFacilities.Where(x => x.Name.Equals(healthFacility.Name)).FirstOrDefault();
+            if (facility != null)
+            {
+                _context.HealthFacilities.Remove(facility);
+                _context.SaveChangesAsync();
+            }
+            
         }
     }