public List<Dogs> GetDogsByDog_Breed_ID(List<DogBreeds> lkpDogBreeds) { string dog_Breed_IDs = null; foreach (DogBreeds dog_Breed in lkpDogBreeds) { dog_Breed_IDs += dog_Breed.Dog_Breed_ID + ", "; } string Breed_IDs = dog_Breed_IDs.Substring(0, dog_Breed_IDs.Length - 2); List<Dogs> dogList = new List<Dogs>(); DogsBL dogs = new DogsBL(); tblDogs = dogs.GetDogsWhereBreed_IDInList(Breed_IDs); if (tblDogs != null && tblDogs.Count > 0) { foreach (sss.tblDogsRow row in tblDogs) { Dogs dog = new Dogs(row.Dog_ID); dogList.Add(dog); } } return dogList; }
public List<Dogs> GetDogsLikeDog_Pet_Name(string dog_Pet_Name) { List<Dogs> dogList = new List<Dogs>(); DogsBL dogs = new DogsBL(); tblDogs = dogs.GetDogsLikeDog_Pet_Name(dog_Pet_Name); if (tblDogs != null && tblDogs.Count > 0) { foreach (sss.tblDogsRow row in tblDogs) { Dogs dog = new Dogs(row.Dog_ID); dogList.Add(dog); } } return dogList; }
public Dogs(Guid dog_ID) { DogsBL dogs = new DogsBL(); tblDogs = dogs.GetDogsByDog_ID(dog_ID); Dog_ID = dog_ID; IsDog_KC_NameNull=tblDogs[0].IsDog_KC_NameNull(); if (!IsDog_KC_NameNull) Dog_KC_Name = tblDogs[0].Dog_KC_Name; IsDog_Pet_NameNull=tblDogs[0].IsDog_Pet_NameNull(); if (!IsDog_Pet_NameNull) Dog_Pet_Name = tblDogs[0].Dog_Pet_Name; IsDog_Breed_IDNull = tblDogs[0].IsDog_Breed_IDNull(); if (!IsDog_Breed_IDNull) Dog_Breed_ID = tblDogs[0].Dog_Breed_ID; IsDog_Gender_IDNull = tblDogs[0].IsDog_Gender_IDNull(); if (!IsDog_Gender_IDNull) Dog_Gender_ID = tblDogs[0].Dog_Gender_ID; IsReg_NoNull = tblDogs[0].IsReg_NoNull(); if (!IsReg_NoNull) Reg_No = tblDogs[0].Reg_No; IsDate_Of_BirthNull = tblDogs[0].IsDate_Of_BirthNull(); if (!IsDate_Of_BirthNull) Date_Of_Birth = tblDogs[0].Date_Of_Birth; IsYear_Of_BirthNull = tblDogs[0].IsYear_Of_BirthNull(); if (!IsYear_Of_BirthNull) Year_Of_Birth = tblDogs[0].Year_Of_Birth; IsMerit_PointsNull = tblDogs[0].IsMerit_PointsNull(); if (!IsMerit_PointsNull) Merit_Points = tblDogs[0].Merit_Points; IsNLWUNull = tblDogs[0].IsNLWUNull(); if (!IsNLWUNull) NLWU = tblDogs[0].NLWU; }