- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
FarmatikoData/FarmatikoRepo/PharmacyRepository.cs
ra55ef91 rc406ae5 1 1 using FarmatikoData.FarmatikoRepoInterfaces; 2 2 using FarmatikoData.Models; 3 using System; 3 4 using System.Collections.Generic; 4 5 using System.Linq; … … 18 19 { 19 20 _context.Pharmacies.Add(pharmacy); 20 _context.SaveChanges Async();21 _context.SaveChanges(); 21 22 } 22 23 //Just for users 23 24 public IQueryable<Pharmacy> GetAll() 24 25 { 25 return _context.Pharmacies.OrderBy(x => x.Name); 26 return _context.Pharmacies.Take(50) 27 .Select(x => new Pharmacy 28 { 29 Name = x.Name, 30 Location = x.Location, 31 Address = x.Address, 32 WorkAllTime = x.WorkAllTime 33 }).OrderBy(x => x.Name); 26 34 } 27 35 28 36 public ICollection<Pharmacy> GetPharmacies() 29 37 { 30 return (ICollection<Pharmacy>)_context.Pharmacies.Select(pharmacy => new 31 { 32 pharmacy.Name, 33 pharmacy.Address, 34 pharmacy.Location, 35 pharmacy.WorkAllTime 36 }).OrderBy(x => x.Name); 38 return (ICollection<Pharmacy>)_context.Pharmacies.Take(50) 39 .Select(pharmacy => new 40 { 41 pharmacy.Name, 42 pharmacy.Address, 43 pharmacy.Location, 44 pharmacy.WorkAllTime 45 }).OrderBy(x => x.Name); 37 46 } 38 47 39 48 public void Remove(Pharmacy pharmacy) 40 49 { 41 var pharma = _context.Pharmacies.Where(pharm => pharm.Name.Equals(pharmacy.Name)).Cast<Pharmacy>(); 42 _context.Pharmacies.Remove((Pharmacy)pharma); 43 _context.SaveChangesAsync(); 50 var pharma = _context.Pharmacies.Where(pharm => pharm.Name.Equals(pharmacy.Name)).FirstOrDefault(); 51 if (pharma != null) 52 { 53 _context.Pharmacies.Remove(pharmacy); 54 _context.SaveChangesAsync(); 55 } 44 56 } 45 57 46 public void UpdatePharmacy(Pharmacy pharmacy , string Name)58 public void UpdatePharmacy(Pharmacy pharmacy) 47 59 { 48 var oldPharmacy = _context.Pharmacies.Where(pharma => pharma.Name.Equals(Name)).Cast<Pharmacy>(); 49 _context.Pharmacies.Remove((Pharmacy)oldPharmacy); 50 _context.Pharmacies.Add(pharmacy); 51 _context.SaveChangesAsync(); 60 var oldPharmacy = _context.Pharmacies.Where(pharma => pharma.Name.Equals(pharmacy.Name)).FirstOrDefault(); 61 if (oldPharmacy != null) 62 { 63 _context.Pharmacies.Remove(oldPharmacy); 64 _context.Pharmacies.Add(pharmacy); 65 _context.SaveChangesAsync(); 66 } 67 throw new Exception("Pharmacy not found"); 52 68 } 53 69 }
Note:
See TracChangeset
for help on using the changeset viewer.