- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
FarmatikoData/FarmatikoRepo/PharmacyHeadRepository.cs
rc406ae5 ra55ef91 22 22 public IQueryable<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHeads) 23 23 { 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); 24 return _context.PharmacyHeads 25 .Where(pharmacyHead => pharmacyHead.Name.Contains(NameOfPharmacyHeads)) 26 .OrderBy(x => x.Name); 32 27 } 33 28 //Not needed 34 29 public IQueryable<PharmacyHead> GetPharmacyByName(string Name) 35 30 { 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); 31 return _context.PharmacyHeads.Where(pharmacyHead => pharmacyHead.Name.Equals(Name)); 45 32 } 46 33 … … 48 35 { 49 36 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 37 IQueryable<MedicineList> Pharmacy = (IQueryable<MedicineList>)_context.PharmacyHeads.Where(x => x.Name.Equals(NameOfPharmacy)); 38 58 39 return Pharmacy; 59 40 } 60 41 61 public void Remove(PharmacyHead pharmacyHead )42 public void Remove(PharmacyHead pharmacyHead, string Name) 62 43 { 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 } 44 var phead = (PharmacyHead)_context.PharmacyHeads.Where(phead => phead.Name.Equals(Name)).FirstOrDefault(); 45 _context.PharmacyHeads.Remove(phead); 46 _context.SaveChangesAsync(); 69 47 } 70 48 }
Note:
See TracChangeset
for help on using the changeset viewer.