Changeset e42f61a for FarmatikoData/FarmatikoRepo/MedicineListRepository.cs

Timestamp:

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

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

de18858

Parents:

ef1219a

Message:

Add more services

File:

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

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