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

File:

• FarmatikoData/FarmatikoRepo/PharmacyHeadRepository.cs (modified) (2 diffs)

FarmatikoData/FarmatikoRepo/PharmacyHeadRepository.cs

@@ -22 +22 @@
         public IQueryable<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHeads)
         {
-            return _context.PharmacyHeads
-                .Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads))
-                .OrderBy(x => x.Name);
+            return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads))
+                .Take(10).Select(x => new PharmacyHead
+                {
+                    MedicineLists = x.MedicineLists,
+                    PharmaciesList = x.PharmaciesList,
+                    Email = x.Email,
+                    Name = x.Name,
+                }).OrderBy(x => x.Name);
         }
         //Not needed
         public IQueryable<PharmacyHead> GetPharmacyByName(string Name)
         {
-            return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Equals(Name));
+            return _context.PharmacyHeads.Take(10)
+                .Where(pharmacyHead => pharmacyHead.Name.Equals(Name))
+                .Select(x => new PharmacyHead
+                {
+                    MedicineLists = x.MedicineLists,
+                    PharmaciesList = x.PharmaciesList,
+                    Email = x.Email,
+                    Name = x.Name,
+                }).OrderBy(x => x.Name);
         }
 
@@ -35 +48 @@
         {
 
-            IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads.Where(x => x.Name.Equals(NameOfPharmacy));
-            
+            IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads
+                .Take(50)
+                .Where(x => x.Name.Equals(NameOfPharmacy))
+                .Select(x => new PharmacyHead
+                {
+                    MedicineLists = x.MedicineLists
+                }).OrderBy(x => x.Name);
+
             return Pharmacy;
         }
 
-        public void Remove(PharmacyHead pharmacyHead, string Name)
+        public void Remove(PharmacyHead pharmacyHead)
         {
-            var phead = (PharmacyHead)_context.PharmacyHeads.Where(phead => phead.Name.Equals(Name)).FirstOrDefault();
-            _context.PharmacyHeads.Remove(phead);
-            _context.SaveChangesAsync();
+            var phead = _context.PharmacyHeads.Where(phead => phead.Name.Equals(pharmacyHead.Name)).FirstOrDefault();
+            if (phead != null)
+            {
+                _context.PharmacyHeads.Remove(phead);
+                _context.SaveChangesAsync();
+            }
         }
     }