public List <Pharmacy> GetAllPharmacy()
 {
     using (var finderDbContext = new FinderDbContext())
     {
         return(finderDbContext.Pharmacies.ToList());
     };
 }
 public Pharmacy GetPharmacyById(int id)
 {
     using (var finderDbContext = new FinderDbContext())
     {
         return(finderDbContext.Pharmacies.Find(id));
     }
 }
 public Pharmacy UpdatePharmacy(Pharmacy pharmacy)
 {
     using (var finderDbContext = new FinderDbContext())
     {
         finderDbContext.Pharmacies.Update(pharmacy);
         finderDbContext.SaveChanges();
         return(pharmacy);
     };
 }
 public void DeletePharmacy(int id)
 {
     using (var finderDbContext = new FinderDbContext())
     {
         var deletedPharmacy = GetPharmacyById(id);
         finderDbContext.Pharmacies.Remove(deletedPharmacy);
         finderDbContext.SaveChanges();
     };
 }