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; }