[de2baac] | 1 | using FarmatikoData.FarmatikoRepoInterfaces;
|
---|
| 2 | using FarmatikoData.Models;
|
---|
| 3 | using System.Linq;
|
---|
| 4 |
|
---|
| 5 | namespace FarmatikoData.FarmatikoRepo
|
---|
| 6 | {
|
---|
| 7 | public class PharmacyHeadRepository : IPharmacyHeadRepository
|
---|
| 8 | {
|
---|
| 9 | private FarmatikoDataContext _context;
|
---|
| 10 |
|
---|
| 11 | public PharmacyHeadRepository(FarmatikoDataContext context)
|
---|
| 12 | {
|
---|
| 13 | _context = context;
|
---|
| 14 | }
|
---|
| 15 |
|
---|
| 16 | public void Add(PharmacyHead pharmacyHead)
|
---|
| 17 | {
|
---|
| 18 | _context.PharmacyHeads.Add(pharmacyHead);
|
---|
| 19 | _context.SaveChangesAsync();
|
---|
| 20 | }
|
---|
| 21 |
|
---|
[4e72684] | 22 | public IQueryable<PharmacyHead> GetAllPharmacies(string NameOfPharmacyHeads)
|
---|
[de2baac] | 23 | {
|
---|
[c406ae5] | 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);
|
---|
[de2baac] | 32 | }
|
---|
| 33 | //Not needed
|
---|
[4e72684] | 34 | public IQueryable<PharmacyHead> GetPharmacyByName(string Name)
|
---|
[de2baac] | 35 | {
|
---|
[c406ae5] | 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);
|
---|
[de2baac] | 45 | }
|
---|
| 46 |
|
---|
[4e72684] | 47 | public IQueryable<MedicineList> GetPharmacyMedicines(string NameOfPharmacy)
|
---|
| 48 | {
|
---|
| 49 |
|
---|
[c406ae5] | 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 |
|
---|
[4e72684] | 58 | return Pharmacy;
|
---|
| 59 | }
|
---|
| 60 |
|
---|
[c406ae5] | 61 | public void Remove(PharmacyHead pharmacyHead)
|
---|
[de2baac] | 62 | {
|
---|
[c406ae5] | 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 | }
|
---|
[de2baac] | 69 | }
|
---|
| 70 | }
|
---|
| 71 | }
|
---|