Changes in FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs [a55ef91:c406ae5]

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();
+            }
+            
         }
     }