public List <DogBreeds> GetDog_BreedsByDog_Breed_Description(string description)
{
List <DogBreeds> retVal = new List <DogBreeds>();
try
{
DogBreedsBL dogBreeds = new DogBreedsBL(_connString);
lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_Description(description);
if (lkpDogBreeds != null && lkpDogBreeds.Rows.Count > 0)
{
foreach (DataRow row in lkpDogBreeds.Rows)
{
DogBreeds dogBreed = new DogBreeds(_connString, Utils.DBNullToInt(row["Dog_Breed_ID"]));
retVal.Add(dogBreed);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List <DogBreeds> GetDog_Breeds()
{
List <DogBreeds> retVal = new List <DogBreeds>();
try
{
DogBreedsBL dogBreeds = new DogBreedsBL(_connString);
lkpDogBreeds = dogBreeds.GetDog_Breeds();
if (lkpDogBreeds != null && lkpDogBreeds.Rows.Count > 0)
{
DogBreeds firstDogBreed = new DogBreeds(_connString);
firstDogBreed.Dog_Breed_ID = 1;
firstDogBreed.Description = "Please Select...";
retVal.Add(firstDogBreed);
foreach (DataRow row in lkpDogBreeds.Rows)
{
DogBreeds dogBreed = new DogBreeds(_connString, Utils.DBNullToInt(row["Dog_Breed_ID"]));
retVal.Add(dogBreed);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public DogBreeds(int dog_Breed_ID)
{
DogBreedsBL dogBreeds = new DogBreedsBL();
lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_ID(dog_Breed_ID);
Dog_Breed_ID = dog_Breed_ID;
Description = lkpDogBreeds[0].Dog_Breed_Description;
}
public DogBreeds(string connString)
{
_connString = connString;
try
{
DogBreedsBL dogBreeds = new DogBreedsBL(_connString);
lkpDogBreeds = dogBreeds.GetDog_Breeds();
}
catch (Exception ex)
{
throw ex;
}
}
public int?Insert_Dog_Breed(string dog_Breed_Description)
{
int?retVal = null;
try
{
DogBreedsBL dogBreeds = new DogBreedsBL(_connString);
retVal = dogBreeds.Insert_Dog_Breed(dog_Breed_Description);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<DogBreeds> GetDog_BreedsByDog_Breed_Description(string description)
{
List<DogBreeds> dogBreedList = new List<DogBreeds>();
DogBreedsBL dogBreeds = new DogBreedsBL();
lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_Description(description);
if (lkpDogBreeds != null && lkpDogBreeds.Count > 0)
{
foreach (sss.lkpDog_BreedsRow row in lkpDogBreeds)
{
DogBreeds dogBreed = new DogBreeds(row.Dog_Breed_ID);
dogBreedList.Add(dogBreed);
}
}
return dogBreedList;
}
public DogBreeds(string connString, int dog_Breed_ID)
{
_connString = connString;
try
{
DogBreedsBL dogBreeds = new DogBreedsBL(_connString);
lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_ID(dog_Breed_ID);
DataRow row = lkpDogBreeds.Rows[0];
_dog_Breed_ID = dog_Breed_ID;
_description = Utils.DBNullToString(row["Dog_Breed_Description"]);
}
catch (Exception ex)
{
throw ex;
}
}
public List<DogBreeds> GetDog_Breeds()
{
List<DogBreeds> dogBreedList = new List<DogBreeds>();
DogBreedsBL dogBreeds = new DogBreedsBL();
lkpDogBreeds = dogBreeds.GetDog_Breeds();
if (lkpDogBreeds != null && lkpDogBreeds.Count > 0)
{
DogBreeds firstDogBreed = new DogBreeds();
firstDogBreed.Dog_Breed_ID = 1;
firstDogBreed.Description = "Please Select...";
dogBreedList.Add(firstDogBreed);
foreach (sss.lkpDog_BreedsRow row in lkpDogBreeds)
{
DogBreeds dogBreed = new DogBreeds(row.Dog_Breed_ID);
dogBreedList.Add(dogBreed);
}
}
return dogBreedList;
}
public int? Insert_Dog_Breed(string dog_Breed_Description)
{
DogBreedsBL dogBreeds = new DogBreedsBL();
return dogBreeds.Insert_Dog_Breed(dog_Breed_Description);
}
public DogBreeds()
{
DogBreedsBL dogBreeds = new DogBreedsBL();
lkpDogBreeds = dogBreeds.GetDog_Breeds();
}