Changeset e42f61a for FarmatikoData/FarmatikoRepo

Timestamp:

07/29/20 13:21:48 (4 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

de18858

Parents:

ef1219a

Message:

Add more services

Location:

FarmatikoData/FarmatikoRepo

Files:

• HealthFacilityRepository.cs (modified) (1 diff)
• HealthcareWorkerRepository.cs (added)
• HealthcareWorkersRepository.cs (deleted)
• MedicineListRepository.cs (modified) (1 diff)
• MedicineRepository.cs (modified) (2 diffs)

FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs

@@ -29 +29 @@
         }
 
-        public IEnumerable<HealthFacilities> GetAllByName(string Name)
-        {
-            Name = Name.ToLower();
-
-            return _context.HealthFacilities.Where(x => x.Name.ToLower().Contains(Name)).OrderBy(x => x.Name.ToLower().IndexOf(Name)).ToList();
-        }
-
-        IEnumerable<HealthFacilities> IHealthFacilityRepository.GetByType(string Type)
-        {
-            return (IEnumerable<HealthFacilities>)_context.HealthFacilities
-               .Where(type => type.Type.Equals(Type));
-        }
     }
 }

FarmatikoData/FarmatikoRepo/MedicineListRepository.cs

@@ -20 +20 @@
             _context.SaveChangesAsync();
         }
+        // Maybe later
+        /*public MedicineList CheckMedicine(string Name)
+        {
+            return (MedicineList)_context.MedicineLists
+                .Where(medicineList => medicineList.Medicine.Name.Contains(Name))
+                .OrderBy(x => x.Medicine.Name);
+        }*/
 
-        public MedicineList CheckMedicine(string Name)
+        public ICollection<MedicineList> GetAll()
         {
-            return (MedicineList)_context.MedicineLists.Where(medicineList => medicineList.Medicine.Name.Equals(Name));
+            return (ICollection<MedicineList>)_context.MedicineLists.OrderBy(x => x.Medicine.Name);
         }
 
-        public MedicineList GetAll()
+        public ICollection<MedicineList> GetByManufacturer(string Manufacturer)
         {
-            return (MedicineList)_context.MedicineLists.Include(list => list.Medicine).Include(list => list.HasMedicine);
+            return (ICollection<MedicineList>)_context.MedicineLists
+                .Where(x => x.Medicine.Manufacturer.Contains(Manufacturer))
+                .OrderBy(x => x.Medicine.Name);
+        }
+        public ICollection<MedicineList> GetByName(string Name)
+        {
+            return (ICollection<MedicineList>)_context.MedicineLists
+                .Where(x => x.Medicine.Name.Contains(Name))
+                .OrderBy(x => x.Medicine.Name);
         }
 
         public void Remove(MedicineList medicineList)
         {
-            //throw new NotImplementedException();
-            //Implement later
+            var list = (MedicineList)_context.MedicineLists.Where(x => x.Equals(medicineList));
+            _context.Remove(list);
+        }
+
+        public void SetHasMedicine(MedicineList medicineList, bool HasMedicine)
+        {
+            var medicine = _context.MedicineLists.Where(x => x.Medicine.Equals(medicineList.Medicine));
         }
     }

FarmatikoData/FarmatikoRepo/MedicineRepository.cs

@@ -27 +27 @@
         }
 
-        public Medicine GetByName(string Name)
+        public IEnumerable<Medicine> GetByManufacturer(string Manufacturer)
         {
-            return (Medicine)_context.Medicines.Where(medicine => medicine.Name == Name);
+            return _context.Medicines.Where(x => x.Name.Contains(Manufacturer)).OrderBy(x => x.Manufacturer);
+        }
+
+        public IEnumerable<Medicine> GetByName(string Name)
+        {
+            return (IEnumerable<Medicine>)_context.Medicines.Where(medicine => medicine.Name == Name);
         }
 
@@ -35 +40 @@
         {
             Medicine med = (Medicine)_context.Medicines.Where(medicine => medicine.Name.Equals(medicine));
-            _context.Medicines.Remove(med);
+            _context.Remove(med);
         }
     }