protected void btnDogSearch_Click(object sender, EventArgs e)
{
//ResetPage();
//ClearEntryFields();
string searchValue = txtDogFilter.Text;
Dogs dog = new Dogs(_connString);
List <Dogs> tblDogs = null;
if (DogSearchType.SelectedValue == "c")
{
searchValue = string.Format("%{0}", searchValue);
}
switch (DogFilterBy.SelectedValue)
{
case "KC_Name":
tblDogs = dog.GetDogsLikeDog_KC_Name(searchValue);
break;
case "Pet_Name":
tblDogs = dog.GetDogsLikeDog_Pet_Name(searchValue);
break;
case "Breed_ID":
DogBreeds dogBreeds = new DogBreeds(_connString);
List <DogBreeds> lkpDogBreeds = null;
lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_Description(searchValue);
tblDogs = dog.GetDogsByDog_Breed_ID(lkpDogBreeds);
break;
default:
tblDogs = dog.GetDogs();
break;
}
Common.Dog_GridViewData = tblDogs;
PopulateDogGridView(Common.Dog_GridViewData, 1);
txtDogFilter.Text = string.Empty;
DogFilterBy.SelectedIndex = -1;
DogSearchType.SelectedIndex = -1;
}