Changeset db484c9 for FarmatikoData/FarmatikoRepo/Repository.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/Repository.cs
r8e74e2f rdb484c9 86 86 var SearchQuery = await _context.HealthFacilities 87 87 .Where(x => x.Name.Contains(query)) 88 .OrderBy(x => x.Name).T ake(3).ToListAsync();88 .OrderBy(x => x.Name).ToListAsync(); 89 89 90 90 return SearchQuery; … … 95 95 var SearchQuery = await _context.Medicines 96 96 .Where(x => x.Name.Contains(query)) 97 .OrderBy(x => x.Name).T ake(5).ToListAsync();97 .OrderBy(x => x.Name).ToListAsync(); 98 98 99 99 return SearchQuery; … … 104 104 var SearchQuery = await _context.Pharmacies.Take(5) 105 105 .Where(x => x.Name.Contains(query)) 106 .OrderBy(x => x.Name).T ake(5).ToListAsync();106 .OrderBy(x => x.Name).ToListAsync(); 107 107 108 108 return SearchQuery; … … 113 113 var SearchQuery = await _context.HealthcareWorkers.Take(5) 114 114 .Where(x => x.Name.Contains(query)) 115 .OrderBy(x => x.Name).T ake(5).ToListAsync();115 .OrderBy(x => x.Name).ToListAsync(); 116 116 117 117 return SearchQuery; … … 170 170 Facility.Phone = healthFacility.Phone; 171 171 Facility.Type = healthFacility.Type; 172 _context.SaveChanges();172 await _context.SaveChangesAsync(); 173 173 } 174 174 175 175 public async Task RemoveMedicine(Medicine medicine) 176 176 { 177 await Task.Run(() => _context.Medicines.Remove(medicine));178 _context.SaveChanges();177 _context.Medicines.Remove(medicine); 178 await _context.SaveChangesAsync(); 179 179 } 180 180 … … 190 190 Pandemic.TotalGlobal = pandemic.TotalGlobal; 191 191 Pandemic.TotalMK = pandemic.TotalMK; 192 _context.SaveChanges();192 await _context.SaveChangesAsync(); 193 193 } 194 194 195 195 public async Task RemovePharmacy(Pharmacy pharmacy) 196 196 { 197 await Task.Run(() => _context.Pharmacies.Remove(pharmacy));198 _context.SaveChanges();197 _context.Pharmacies.Remove(pharmacy); 198 await _context.SaveChangesAsync(); 199 199 } 200 200 //not impl … … 211 211 Pharmacy.WorkAllTime = pharmacy.WorkAllTime; 212 212 Pharmacy.Address = pharmacy.Address; 213 _context.SaveChanges();214 } 215 // ke vidime213 await _context.SaveChangesAsync(); 214 } 215 //not implemented, not needed 216 216 public Task UpdateMedicine(Medicine medicine) 217 217 { … … 223 223 var PHead = await _context.PharmacyHeads.Where(x => x.Id == Id).FirstOrDefaultAsync(); 224 224 PHead.DeletedOn = DateTime.UtcNow; 225 _context.SaveChanges();225 await _context.SaveChangesAsync(); 226 226 } 227 227 … … 236 236 UserRole = x.UserRole 237 237 }); 238 238 239 return users; 239 240 } … … 257 258 Price = x.Price, 258 259 Packaging = x.Packaging, 259 Medicine List = x.MedicineList260 Medicines = x.Medicines 260 261 261 262 }).ToList(); … … 266 267 { 267 268 var head = _context.PharmacyHeads.Where(x => x.Email.Equals(email)).FirstOrDefault(); 268 var phmeds = _context.PharmacyHeadMedicines.Where(x => x.PheadId == head.Id). ToList();269 var phmeds = _context.PharmacyHeadMedicines.Where(x => x.PheadId == head.Id).Include(x => x.Medicine).ToList(); 269 270 return phmeds; 270 271 }
Note:
See TracChangeset
for help on using the changeset viewer.