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(); }