private IQueryable <Animal> SearchForAnimal(int iD)
{
HumaineSocietyDataContext context = new HumaineSocietyDataContext();
var animals = (from animal in context.Animals where animal.AnimalId == iD select animal);
return(animals);
}
protected IQueryable <Animal> SearchForAnimal()
{
HumaineSocietyDataContext context = new HumaineSocietyDataContext();
var animals = from data in context.Animals select data;
var searchParameters = UserInterface.GetAnimalCriteria();
if (searchParameters.ContainsKey(1))
{
animals = (from animal in animals where animal.Species.Name == searchParameters[1] select animal);
}
if (searchParameters.ContainsKey(2))
{
animals = (from animal in animals where animal.Name == searchParameters[2] select animal);
}
if (searchParameters.ContainsKey(3))
{
animals = (from animal in animals where animal.Age == int.Parse(searchParameters[3]) select animal);
}
if (searchParameters.ContainsKey(4))
{
animals = (from animal in animals where animal.Demeanor == searchParameters[4] select animal);
}
if (searchParameters.ContainsKey(5))
{
bool parameter = GetBoolParamater(searchParameters[5]);
animals = (from animal in animals where animal.KidFriendly == parameter select animal);
}
if (searchParameters.ContainsKey(6))
{
bool parameter = GetBoolParamater(searchParameters[6]);
animals = (from animal in animals where animal.PetFriendly == parameter select animal);
}
if (searchParameters.ContainsKey(7))
{
animals = (from animal in animals where animal.Weight == int.Parse(searchParameters[7]) select animal);
}
if (searchParameters.ContainsKey(8))
{
animals = (from animal in animals where animal.AnimalId == int.Parse(searchParameters[8]) select animal);
}
return(animals);
}
static Query()
{
db = new HumaineSocietyDataContext();
}
