public IEnumerable <AnnouncementAndroid> GetAnnouncementsAndroid(String nameStatus)
{
List <AnnouncementAndroid> announcements = new List <AnnouncementAndroid>();
int id = ctx.Statut.Where(s => s.State == nameStatus).Select(s => s.Id).Single();
foreach (Announcement announc in ctx.Announcement.Where(a => a.IdStatut == id))
{
Animal animal = ctx.Animal.Where(a => a.Id == announc.IdAnimal).First();
Breed breed = ctx.Breed.Where(b => b.id == animal.IdBreed).First();
var announcement = new AnnouncementAndroid()
{
Id = announc.Id,
Name = animal.Name,
Species = breed.IdSpecies,
Breed = breed.Name,
Color = animal.IdColor,
Date = announc.Date,
Description = announc.Description,
IdStatut = announc.IdStatut,
IdAnimal = announc.IdAnimal
};
announcements.Add(announcement);
}
return(announcements);
}
public IEnumerable <AnnouncementAndroid> GetAnnouncementAndroid([FromRoute] int id)
{
List <AnnouncementAndroid> announcements = new List <AnnouncementAndroid>();
var announcement = ctx.Announcement.SingleOrDefault(m => m.Id == id);
if (announcement != null)
{
Animal animal = ctx.Animal.Where(a => a.Id == announcement.IdAnimal).First();
Breed breed = ctx.Breed.Where(b => b.id == animal.IdBreed).First();
var announcementAndroid = new AnnouncementAndroid()
{
Id = announcement.Id,
Name = animal.Name,
Species = breed.IdSpecies,
Breed = breed.Name,
Color = animal.IdColor,
Date = announcement.Date,
Description = announcement.Description,
IdStatut = announcement.IdStatut,
IdAnimal = announcement.IdAnimal
};
announcements.Add(announcementAndroid);
}
return(announcements);
}
