- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
FarmatikoData/FarmatikoRepo/PharmacyHeadRepository.cs
ra55ef91 rc406ae5 22 22 public IQueryable<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHeads) 23 23 { 24 return _context.PharmacyHeads 25 .Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads)) 26 .OrderBy(x => x.Name); 24 return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads)) 25 .Take(10).Select(x => new PharmacyHead 26 { 27 MedicineLists = x.MedicineLists, 28 PharmaciesList = x.PharmaciesList, 29 Email = x.Email, 30 Name = x.Name, 31 }).OrderBy(x => x.Name); 27 32 } 28 33 //Not needed 29 34 public IQueryable<PharmacyHead> GetPharmacyByName(string Name) 30 35 { 31 return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Equals(Name)); 36 return _context.PharmacyHeads.Take(10) 37 .Where(pharmacyHead => pharmacyHead.Name.Equals(Name)) 38 .Select(x => new PharmacyHead 39 { 40 MedicineLists = x.MedicineLists, 41 PharmaciesList = x.PharmaciesList, 42 Email = x.Email, 43 Name = x.Name, 44 }).OrderBy(x => x.Name); 32 45 } 33 46 … … 35 48 { 36 49 37 IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads.Where(x => x.Name.Equals(NameOfPharmacy)); 38 50 IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads 51 .Take(50) 52 .Where(x => x.Name.Equals(NameOfPharmacy)) 53 .Select(x => new PharmacyHead 54 { 55 MedicineLists = x.MedicineLists 56 }).OrderBy(x => x.Name); 57 39 58 return Pharmacy; 40 59 } 41 60 42 public void Remove(PharmacyHead pharmacyHead , string Name)61 public void Remove(PharmacyHead pharmacyHead) 43 62 { 44 var phead = (PharmacyHead)_context.PharmacyHeads.Where(phead => phead.Name.Equals(Name)).FirstOrDefault(); 45 _context.PharmacyHeads.Remove(phead); 46 _context.SaveChangesAsync(); 63 var phead = _context.PharmacyHeads.Where(phead => phead.Name.Equals(pharmacyHead.Name)).FirstOrDefault(); 64 if (phead != null) 65 { 66 _context.PharmacyHeads.Remove(phead); 67 _context.SaveChangesAsync(); 68 } 47 69 } 48 70 }
Note:
See TracChangeset
for help on using the changeset viewer.