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