public List <OwnersDogsClassesHandlers> GetOwnersDogsClassesHandlers(Guid owner_ID)
{
List <OwnersDogsClassesHandlers> retVal = new List <OwnersDogsClassesHandlers>();
try
{
OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL(_connString);
tblOwnersDogsClassesHandlers = ownersDogsClassesHandlers.GetOwnersDogsClassesHandlers(owner_ID);
if (tblOwnersDogsClassesHandlers != null && tblOwnersDogsClassesHandlers.Rows.Count > 0)
{
foreach (DataRow row in tblOwnersDogsClassesHandlers.Rows)
{
OwnersDogsClassesHandlers oDCH = new OwnersDogsClassesHandlers(_connString);
oDCH.Dog_Class_ID = Utils.DBNullToGuid(row["Dog_Class_ID"]);
oDCH.Owner_ID = Utils.DBNullToGuid(row["Owner_ID"]);
oDCH.Handler_ID = Utils.DBNullToGuid(row["Handler_ID"]);
oDCH.Owner = Utils.DBNullToString(row["Owner"]);
oDCH.Dog_KC_Name = Utils.DBNullToString(row["Dog_KC_Name"]);
oDCH.Class = Utils.DBNullToString(row["Class"]);
oDCH.Handler = Utils.DBNullToString(row["Handler"]);
retVal.Add(oDCH);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<OwnersDogsClassesHandlers> GetOwnersDogsClassesHandlers(Guid owner_ID)
{
List<OwnersDogsClassesHandlers> ownersDogsClassesHandlersList = new List<OwnersDogsClassesHandlers>();
OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL();
tblOwnersDogsClassesHandlers = ownersDogsClassesHandlers.GetOwnersDogsClassesHandlers(owner_ID);
if (tblOwnersDogsClassesHandlers != null && tblOwnersDogsClassesHandlers.Count > 0)
{
foreach (sss.tblOwnersDogsClassesHandlersRow row in tblOwnersDogsClassesHandlers)
{
OwnersDogsClassesHandlers oDCH = new OwnersDogsClassesHandlers();
oDCH.Dog_Class_ID = row.Dog_Class_ID;
oDCH.Owner_ID = row.Owner_ID;
oDCH.Handler_ID = row.Handler_ID;
oDCH.Owner = row.Owner;
oDCH.Dog_KC_Name = row.Dog_KC_Name;
oDCH.Class = row.Class;
oDCH.Handler = row.Handler;
ownersDogsClassesHandlersList.Add(oDCH);
}
}
return ownersDogsClassesHandlersList;
}
private void PopulateOwnersDogsClassesGridView()
{
Guid owner_ID = new Guid(lstOwners.SelectedValue);
OwnersDogsClassesHandlers oDCH = new OwnersDogsClassesHandlers();
List<OwnersDogsClassesHandlers> oDCHList = oDCH.GetOwnersDogsClassesHandlers(owner_ID);
OwnersDogsClassesGridView.DataSource = oDCHList;
OwnersDogsClassesGridView.DataBind();
}
private void PopulateOwnerList(DropDownList listToPopulate)
{
Guid show_ID = new Guid(Show_ID);
DogOwnerList dogOwnerList = new DogOwnerList();
List<DogOwners> lnkDog_Owners;
DogOwners dogOwner = new DogOwners();
lnkDog_Owners = dogOwner.GetDogOwnersByShow_ID(show_ID);
if (lnkDog_Owners != null && lnkDog_Owners.Count > 0)
{
foreach (DogOwners dogOwnerRow in lnkDog_Owners)
{
People person = new People(dogOwnerRow.Owner_ID);
dogOwnerList.AddOwner(person);
}
dogOwnerList.Sort();
}
List<OwnersDogsClassesHandlers> ownerList = new List<OwnersDogsClassesHandlers>();
if (dogOwnerList != null)
{
foreach (People ownerRow in dogOwnerList.MyDogOwnerList)
{
OwnersDogsClassesHandlers owner = new OwnersDogsClassesHandlers();
owner.Owner = string.Format("{0} {1} {2}", ownerRow.Person_Title, ownerRow.Person_Forename, ownerRow.Person_Surname).TrimStart();
owner.Owner_ID = ownerRow.Person_ID;
ownerList.Add(owner);
}
}
if (ownerList != null && ownerList.Count > 0)
{
listToPopulate.DataSource = ownerList;
listToPopulate.DataBind();
}
}
