Changeset 4e72684 for FarmatikoData/FarmatikoRepo

Timestamp:

07/29/20 20:02:58 (4 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

a55ef91

Parents:

de18858

Message:

Add services

Location:

FarmatikoData/FarmatikoRepo

Files:

• MedicineListRepository.cs (modified) (3 diffs)
• MedicineRepository.cs (modified) (4 diffs)
• PharmacyHeadRepository.cs (modified) (1 diff)
• PharmacyRepository.cs (modified) (1 diff)

FarmatikoData/FarmatikoRepo/MedicineListRepository.cs

@@ -1 +1 @@
 using FarmatikoData.Models;
-using Microsoft.EntityFrameworkCore;
-using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace FarmatikoData.FarmatikoRepo
@@ -20 +17 @@
             _context.SaveChangesAsync();
         }
-        // Maybe later
-        /*public MedicineList CheckMedicine(string Name)
+        public MedicineList CheckMedicine(string Name)
         {
             return (MedicineList)_context.MedicineLists
                 .Where(medicineList => medicineList.Medicine.Name.Contains(Name))
                 .OrderBy(x => x.Medicine.Name);
-        }*/
+        }
 
-        public ICollection<MedicineList> GetAll()
+        public IEnumerable<MedicineList> GetAll()
         {
-            return (ICollection<MedicineList>)_context.MedicineLists.OrderBy(x => x.Medicine.Name);
+            return _context.MedicineLists.OrderBy(x => x.Medicine.Name);
         }
 
@@ -49 +45 @@
         {
             var list = (MedicineList)_context.MedicineLists.Where(x => x.Equals(medicineList));
-            _context.Remove(list);
+            _context.MedicineLists.Remove(list);
         }
 
-        public void SetHasMedicine(MedicineList medicineList, bool HasMedicine)
+        public bool SetHasMedicine(MedicineList medicineList, bool HasMedicine)
         {
-            var medicine = _context.MedicineLists.Where(x => x.Medicine.Equals(medicineList.Medicine));
+            MedicineList medicine = (MedicineList)_context.MedicineLists.Where(x => x.Medicine.Name.Equals(medicineList.Medicine.Name));
+            
+            if (medicine != null || medicineList != null)
+            {
+                if (HasMedicine == true)
+                {
+                    medicine.HasMedicine = HasMedicine;
+                    _context.MedicineLists.Add(medicine);
+                    _context.SaveChangesAsync();
+                    return true;
+                }
+                else
+                {
+                    medicine.HasMedicine = HasMedicine;
+                    _context.MedicineLists.Add(medicine);
+                    _context.SaveChangesAsync();
+                    return true;
+                }
+            }else
+            {
+                return false;
+            }
         }
     }

FarmatikoData/FarmatikoRepo/MedicineRepository.cs

@@ -1 +1 @@
 using FarmatikoData.FarmatikoRepoInterfaces;
 using FarmatikoData.Models;
-using Microsoft.EntityFrameworkCore;
-using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace FarmatikoData.FarmatikoRepo
@@ -24 +21 @@
         public IEnumerable<Medicine> GetAll()
         {
-            return _context.Medicines.Include(medicine => medicine.Name).Include(medicine => medicine.Strength).Include(medicine => medicine.Form);
+            return _context.Medicines.OrderBy(x => x.Name);
         }
 
@@ -34 +31 @@
         public IEnumerable<Medicine> GetByName(string Name)
         {
-            return (IEnumerable<Medicine>)_context.Medicines.Where(medicine => medicine.Name == Name);
+            return _context.Medicines.Where(medicine => medicine.Name == Name);
         }
 
@@ -40 +37 @@
         {
             Medicine med = (Medicine)_context.Medicines.Where(medicine => medicine.Name.Equals(medicine));
-            _context.Remove(med);
+            _context.Medicines.Remove(med);
         }
     }

FarmatikoData/FarmatikoRepo/PharmacyHeadRepository.cs

@@ -23 +23 @@
         }
 
-        public ICollection<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHead)
+        public IQueryable<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHeads)
         {
-            return (ICollection<PharmacyHead>)_context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Equals(NameOfPharmacyHead));
+            return _context.PharmacyHeads
+                .Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads))
+                .OrderBy(x => x.Name);
         }
         //Not needed
-        public IEnumerable<PharmacyHead> GetPharmacyByName(string Name)
+        public IQueryable<PharmacyHead> GetPharmacyByName(string Name)
         {
             return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Equals(Name));
+        }
+
+        public IQueryable<MedicineList> GetPharmacyMedicines(string NameOfPharmacy)
+        {
+
+            IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads.Where(x => x.Name.Equals(NameOfPharmacy));
+            
+            return Pharmacy;
         }
 

FarmatikoData/FarmatikoRepo/PharmacyRepository.cs

@@ -21 +21 @@
             _context.Pharmacies.Add(pharmacy);
             _context.SaveChangesAsync();
+        }
+        //Just for users
+        public IEnumerable<Pharmacy> GetAll()
+        {
+            return _context.Pharmacies.OrderBy(x => x.Name);
         }