public List <CatalogueList> GetCatalogueListByRingNumber()
{
List <CatalogueList> retVal = new List <CatalogueList>();
try
{
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL(_connString);
tblCatalogueListByRingNumber = catalogueListByRingNumbers.GetCatalogueListOrderByRingNumber();
if (tblCatalogueListByRingNumber != null && tblCatalogueListByRingNumber.Rows.Count > 0)
{
foreach (DataRow row in tblCatalogueListByRingNumber.Rows)
{
CatalogueList catalogueListByRingNumber = new CatalogueList(_connString);
catalogueListByRingNumber.Ring_No = Utils.DBNullToShort(row["Ring_No"]);
catalogueListByRingNumber.Owner = Utils.DBNullToString(row["Owner"]);
catalogueListByRingNumber.Address = Utils.DBNullToString(row["Address"]);
catalogueListByRingNumber.Dog_KC_Name = Utils.DBNullToString(row["Dog_KC_Name"]);
catalogueListByRingNumber.Dog_Breed_Description = Utils.DBNullToString(row["Dog_Breed_Description"]);
catalogueListByRingNumber.Dog_Gender = Utils.DBNullToString(row["Dog_Gender"]);
catalogueListByRingNumber.Date_Of_Birth = Utils.DBNullToString(row["Date_Of_Birth"]);
catalogueListByRingNumber.Class_Name = Utils.DBNullToString(row["Class_Name"]);
catalogueListByRingNumber.Catalogue = Utils.DBNullToBool(row["Catalogue"]);
retVal.Add(catalogueListByRingNumber);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool PopulateCatalogueListByRingNumber(Guid show_ID)
{
bool retVal = false;
try
{
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL(_connString);
retVal = catalogueListByRingNumbers.PopulateCatalogueListByRingNumber(show_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool PopulateCatalogueListByRingNumber(Guid show_ID)
{
bool success = false;
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL();
success = catalogueListByRingNumbers.PopulateCatalogueListByRingNumber(show_ID);
return success;
}
public List<CatalogueList> GetCatalogueListByRingNumber()
{
List<CatalogueList> catalogueListByRingNumbersList = new List<CatalogueList>();
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL();
tblCatalogueListByRingNumber = catalogueListByRingNumbers.GetCatalogueListByRingNumber();
if (tblCatalogueListByRingNumber != null && tblCatalogueListByRingNumber.Count > 0)
{
foreach (sss.tblCatalogueListByRingNumberRow row in tblCatalogueListByRingNumber)
{
CatalogueList catalogueListByRingNumber = new CatalogueList();
catalogueListByRingNumber.Ring_No = row.Ring_No;
catalogueListByRingNumber.Owner = row.Owner;
catalogueListByRingNumber.Address = row.Address;
catalogueListByRingNumber.Dog_KC_Name = row.Dog_KC_Name;
catalogueListByRingNumber.Dog_Breed_Description = row.Dog_Breed_Description;
catalogueListByRingNumber.Dog_Gender = row.Dog_Gender;
catalogueListByRingNumber.Date_Of_Birth = row.Date_Of_Birth;
catalogueListByRingNumber.Breeder = row.Breeder;
catalogueListByRingNumber.Sire = row.Sire;
catalogueListByRingNumber.Dam = row.Dam;
catalogueListByRingNumber.Class_Name = row.Class_Name;
catalogueListByRingNumber.BreederIsOwner = row.BreederIsOwner;
if (!row.IsCatalogueNull())
{
catalogueListByRingNumber.Catalogue = row.Catalogue;
}
else
{
catalogueListByRingNumber.Catalogue = false;
}
catalogueListByRingNumbersList.Add(catalogueListByRingNumber);
}
}
return catalogueListByRingNumbersList;
}