public Guid?Insert_Dog_Sires(Guid user_ID)
{
DogSiresBL dogSires = new DogSiresBL(_connString);
Guid? newID = dogSires.Insert_Dog_Sires(_dog_ID, _sire_ID, user_ID);
return(newID);
}
public DogSires(Guid dog_Sire_ID)
{
DogSiresBL dogSires = new DogSiresBL();
lnkDogSires = dogSires.GetDog_SireByDog_Sire_ID(dog_Sire_ID);
Dog_Sire_ID = dog_Sire_ID;
Dog_ID = lnkDogSires[0].Dog_ID;
Sire_ID = lnkDogSires[0].Sire_ID;
}
public bool Update_Dog_Sires(Guid original_ID, Guid user_ID)
{
bool success = false;
DogSiresBL dogSires = new DogSiresBL(_connString);
success = dogSires.Update_Dog_Sires(original_ID, _dog_ID, _sire_ID, _deleteDogSire, user_ID);
return(success);
}
public DogSires(string connString, Guid dog_Sire_ID)
{
_connString = connString;
DogSiresBL dogSires = new DogSiresBL(_connString);
lnkDogSires = dogSires.GetDog_SireByDog_Sire_ID(dog_Sire_ID);
DataRow row = lnkDogSires.Rows[0];
_dog_Sire_ID = dog_Sire_ID;
_dog_ID = Utils.DBNullToGuid(row["Dog_ID"]);
_sire_ID = Utils.DBNullToGuid(row["Sire_ID"]);
}
public List<DogSires> GetDogSiresByDog_ID(Guid dog_ID)
{
List<DogSires> dogSireList = new List<DogSires>();
DogSiresBL dogSires = new DogSiresBL();
lnkDogSires = dogSires.GetDog_SireByDog_ID(dog_ID);
if (lnkDogSires != null && lnkDogSires.Count > 0)
{
foreach (sss.lnkDog_SiresRow row in lnkDogSires)
{
DogSires dogSire = new DogSires(row.Dog_Sire_ID);
dogSireList.Add(dogSire);
}
}
return dogSireList;
}
public List <DogSires> GetDogSiresBySire_ID(Guid sire_ID)
{
List <DogSires> dogSireList = new List <DogSires>();
DogSiresBL dogSires = new DogSiresBL(_connString);
lnkDogSires = dogSires.GetDog_SiresBySire_ID(sire_ID);
if (lnkDogSires != null && lnkDogSires.Rows.Count > 0)
{
foreach (DataRow row in lnkDogSires.Rows)
{
DogSires dogSire = new DogSires(_connString, Utils.DBNullToGuid(row["Dog_Sire_ID"]));
dogSireList.Add(dogSire);
}
}
return(dogSireList);
}
public bool Update_Dog_Sire(Guid original_ID, Guid user_ID)
{
bool success = false;
DogSiresBL dogSires = new DogSiresBL();
success = dogSires.Update_Dog_Sires(original_ID, Dog_ID, Sire_ID, DeleteDogSire, user_ID);
return success;
}
public Guid? Insert_Dog_Sire(Guid user_ID)
{
DogSiresBL dogSires = new DogSiresBL();
Guid? newID = null;
if (Dog_ID != null && Sire_ID != null)
newID = dogSires.Insert_Dog_Sires(Dog_ID, Sire_ID, user_ID);
return newID;
}