Changeset db484c9 for FarmatikoData/FarmatikoRepo/PHRepo.cs
- Timestamp:
- 01/26/21 10:33:09 (4 years ago)
- Branches:
- master
- Children:
- 7d80751
- Parents:
- 8e74e2f
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
FarmatikoData/FarmatikoRepo/PHRepo.cs
r8e74e2f rdb484c9 24 24 public async Task<IEnumerable<PharmacyHead>> GetPharmacyHeadInfo() 25 25 { 26 var PHeadInfo = await _context.PharmacyHeads.Take(10).Where(x => x.DeletedOn == null) 26 var PHeadInfo = await _context.PharmacyHeads.Take(10) 27 .Where(x => x.DeletedOn == null) 27 28 .Select(x => new PharmacyHead 28 29 { … … 31 32 Email = x.Email, 32 33 Password = x.Password, 33 MedicineList = x.MedicineList, 34 PharmaciesList = x.PharmaciesList 34 Pharmacies = x.Pharmacies, 35 Medicines = x.Medicines 36 35 37 }).ToListAsync(); 36 38 return PHeadInfo; … … 41 43 var Phead = await _context.PharmacyHeads.Where(x => x.Email == pharmacyHead.Email).FirstOrDefaultAsync(); 42 44 var EditedPHead = await _context.PharmacyHeads.AsNoTracking<PharmacyHead>().Where(x => x.Email == pharmacyHead.Email).FirstOrDefaultAsync(); 43 EditedPHead.Email = pharmacyHead.Email; 44 EditedPHead.Name = pharmacyHead.Name; 45 EditedPHead.Password = pharmacyHead.Password; 46 /*if (pharmacyHead.MedicineList.Count() == 0) 47 pharmacyHead.MedicineList = null;*/ 48 EditedPHead.MedicineList = pharmacyHead.MedicineList; 49 EditedPHead.PharmaciesList = pharmacyHead.PharmaciesList; 50 EditedPHead.PHMedicineList = pharmacyHead.PHMedicineList; 51 //_context.Entry<PharmacyHead>(Phead).State = EntityState.Detached; 52 //Phead = EditedPHead; 45 46 if (!EditedPHead.Email.Equals(pharmacyHead.Email)) 47 EditedPHead.Email = pharmacyHead.Email; 48 49 if (!EditedPHead.Name.Equals(pharmacyHead.Name)) 50 EditedPHead.Name = pharmacyHead.Name; 51 52 if (!EditedPHead.Password.Equals(pharmacyHead.Password)) 53 EditedPHead.Password = pharmacyHead.Password; 54 55 if (!EditedPHead.Pharmacies.Equals(pharmacyHead.Pharmacies)) 56 EditedPHead.Pharmacies = pharmacyHead.Pharmacies; 57 58 if (!EditedPHead.Medicines.Equals(pharmacyHead.Medicines)) 59 EditedPHead.Medicines = pharmacyHead.Medicines; 60 53 61 await _context.SaveChangesAsync(); 54 62 } … … 81 89 public PharmacyHead GetPharmacyHeadByUserName(string userName) 82 90 { 91 92 83 93 var PHead = _context.PharmacyHeads 84 94 .Where(x => x.Email.Equals(userName)) 85 .FirstOrDefault(); 95 .Select(x => new PharmacyHead 96 { 97 Email = x.Email, 98 Name = x.Name, 99 Password = x.Password, 100 Medicines = x.Medicines, 101 Pharmacies = x.Pharmacies 102 }).FirstOrDefault(); 103 104 86 105 87 106 return PHead; … … 90 109 public List<PharmacyHeadMedicine> GetPharmacyHeadMedicines(string email) 91 110 { 92 /*var meds = _context.Medicines.ToList();93 var medicines = Medicines;*/94 111 var Phead = _context.PharmacyHeads.Where(x => x.Email.Equals(email)).FirstOrDefault(); 95 var Medicines = _context.PharmacyHeadMedicines.Where(x => x.PheadId == Phead.Id).ToList(); 96 /*.Select(x => x.Head.MedicineList) 97 .SelectMany(mList => mList) 98 .ToList();*/ 112 var Medicines = _context.PharmacyHeadMedicines.Select(x => new PharmacyHeadMedicine 113 { 114 PheadId = x.PheadId, 115 Head = x.Head, 116 MedicineId = x.MedicineId, 117 Medicine = x.Medicine 118 }).ToList(); 119 if (Medicines == null || Medicines == default) 120 Medicines = null; 121 var meds = Medicines.Where(x => x.PheadId == Phead.Id).ToList(); 99 122 100 101 return Medicines; 123 return meds; 102 124 } 103 125
Note:
See TracChangeset
for help on using the changeset viewer.