public List <dynamic> addVets([FromBody] List <Vet> vets)
{
AnimalsEntities db = new AnimalsEntities();
db.Configuration.ProxyCreationEnabled = false;
db.Vets.AddRange(vets);
db.SaveChanges();
return(getVets());
}
public List <dynamic> getVets()
{
AnimalsEntities db = new AnimalsEntities();
List <dynamic> vetList = new List <dynamic>();
foreach (Vet vet in db.Vets)
{
dynamic vets = new ExpandoObject();
vets.ID = vet.VetID;
vets.Name = vet.Name;
vets.Location = vet.Location;
vetList.Add(vets);
}
return(vetList);
}
public List <dynamic> getTables()
{
AnimalsEntities db = new AnimalsEntities();
List <dynamic> tableList = new List <dynamic>();
foreach (Vet vet in db.Vets)
{
dynamic vets = new ExpandoObject();
vets.ID = vet.VetID;
vets.Name = vet.Name;
vets.Location = vet.Location;
tableList.Add(vets);
}
foreach (Owner owner in db.Owners)
{
dynamic owners = new ExpandoObject();
owners.ID = owner.OwnerID;
owners.Name = owner.Name;
owner.Email = owner.Email;
tableList.Add(owners);
}
return(tableList);
}