Changeset 1db5673 for FarmatikoData/FarmatikoRepo/PHRepo.cs

Timestamp:

11/14/20 12:27:30 (3 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

68454c6

Parents:

ad60966

Message:

Fix bugs, add some more

File:

• FarmatikoData/FarmatikoRepo/PHRepo.cs (modified) (3 diffs)

FarmatikoData/FarmatikoRepo/PHRepo.cs

@@ -31 +31 @@
                     Email = x.Email,
                     Password = x.Password,
-                    MedicineLists = x.MedicineLists,
+                    MedicineList = x.MedicineList,
                     PharmaciesList = x.PharmaciesList
                 }).ToListAsync();
@@ -39 +39 @@
         public async Task UpdatePharmacyHead(PharmacyHead pharmacyHead)
         {
-            var EditedPHead = await _context.PharmacyHeads.Where(x => x.Id == pharmacyHead.Id).FirstOrDefaultAsync();
+            var Phead = await _context.PharmacyHeads.Where(x => x.Email == pharmacyHead.Email).FirstOrDefaultAsync();
+            var EditedPHead = await _context.PharmacyHeads.AsNoTracking<PharmacyHead>().Where(x => x.Email == pharmacyHead.Email).FirstOrDefaultAsync();
             EditedPHead.Email = pharmacyHead.Email;
             EditedPHead.Name = pharmacyHead.Name;
             EditedPHead.Password = pharmacyHead.Password;
-            EditedPHead.MedicineLists = pharmacyHead.MedicineLists;
+            /*if (pharmacyHead.MedicineList.Count() == 0)
+                pharmacyHead.MedicineList = null;*/
+            EditedPHead.MedicineList = pharmacyHead.MedicineList;
             EditedPHead.PharmaciesList = pharmacyHead.PharmaciesList;
+            EditedPHead.PHMedicineList = pharmacyHead.PHMedicineList;
+            //_context.Entry<PharmacyHead>(Phead).State = EntityState.Detached;
+            Phead = EditedPHead;
             await _context.SaveChangesAsync();
         }
@@ -72 +78 @@
         }
 
+
         public PharmacyHead GetPharmacyHeadByUserName(string userName)
         {
-            return _context.PharmacyHeads
+            var PHead = _context.PharmacyHeads
                 .Where(x => x.Email.Equals(userName))
                 .FirstOrDefault();
+
+            return PHead;
+        }
+
+        public List<PharmacyHeadMedicine> GetPharmacyHeadMedicines(string email)
+        {
+            /*var meds = _context.Medicines.ToList();
+            var medicines = Medicines;*/
+            var Phead = _context.PharmacyHeads.Where(x => x.Email.Equals(email)).FirstOrDefault();
+            var Medicines = _context.PharmacyHeadMedicines.Where(x => x.PheadId == Phead.Id).ToList();
+                /*.Select(x => x.Head.MedicineList)
+                .SelectMany(mList => mList)
+                .ToList();*/
+
+
+            return Medicines;
+        }
+
+        public IEnumerable<PharmacyHead> GetPharmacyHeads()
+        {
+            var heads = _context.PharmacyHeads.ToList();
+            return heads;
+        }
+
+        public PharmacyHead GetPharmacyHead(string head)
+        {
+            var phead = _context.PharmacyHeads.Where(x => x.Email.Equals(head)).FirstOrDefault();
+            return phead;
+        }
+
+        public List<Pharmacy> GetPharmacies()
+        {
+            var pharms = _context.Pharmacies.ToList();
+            return pharms;
         }
     }