Changeset a55ef91 for FarmatikoData/FarmatikoRepo/PharmacyRepository.cs

Timestamp:

07/31/20 10:15:02 (4 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

d8fafb8

Parents:

4e72684

Message:

Update & add service

File:

• FarmatikoData/FarmatikoRepo/PharmacyRepository.cs (modified) (4 diffs)

FarmatikoData/FarmatikoRepo/PharmacyRepository.cs

@@ -1 +1 @@
 using FarmatikoData.FarmatikoRepoInterfaces;
 using FarmatikoData.Models;
-using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace FarmatikoData.FarmatikoRepo
@@ -23 +21 @@
         }
         //Just for users
-        public IEnumerable<Pharmacy> GetAll()
+        public IQueryable<Pharmacy> GetAll()
         {
             return _context.Pharmacies.OrderBy(x => x.Name);
@@ -36 +34 @@
                 pharmacy.Location,
                 pharmacy.WorkAllTime
-            });
+            }).OrderBy(x => x.Name);
         }
 
         public void Remove(Pharmacy pharmacy)
         {
-            var pharma = _context.Pharmacies.Where(pharm => pharm.Equals(pharmacy));
+            var pharma = _context.Pharmacies.Where(pharm => pharm.Name.Equals(pharmacy.Name)).Cast<Pharmacy>();
             _context.Pharmacies.Remove((Pharmacy)pharma);
             _context.SaveChangesAsync();
@@ -48 +46 @@
         public void UpdatePharmacy(Pharmacy pharmacy, string Name)
         {
-            var oldPharmacy = _context.Pharmacies.Where(pharma => pharma.Name.Equals(Name));
+            var oldPharmacy = _context.Pharmacies.Where(pharma => pharma.Name.Equals(Name)).Cast<Pharmacy>();
             _context.Pharmacies.Remove((Pharmacy)oldPharmacy);
             _context.Pharmacies.Add(pharmacy);