private void LoadDataInBoxes( SportTypes aSportType) { txtSportTypeID.Text = aSportType.SportTypeID.ToString(); txtSportTypeName.Text = aSportType.SportTypeName; txtParentSportTypeID.Text = aSportType.ParentSportTypeID.ToString(); txtMemo.Text = aSportType.Memo; txtDistForPace.Text = aSportType.DistForPace.ToString(); if (txtParentSportTypeID.Text == "0") chBxNoFamily.Checked = true; else { chBxNoFamily.Checked = false; } //Find the name of the parent sport type SportTypes parent = new SportTypes(); parent = aSportType.FindParentSportType(connString); cbxSportTypeName.Text = parent.SportTypeName; }
public void SportType_FindParent() { //Create a SportType object to be the parent string sportTypeNameUsed = "Deporte Padre"; Int64 parentSportTypeIDUsed = 0; string memoUsed = "Deporte padre"; Int64 userIDUsed = 85; SportTypes aSportTypeParent = new SportTypes(); aSportTypeParent.LoadData(-1, sportTypeNameUsed, parentSportTypeIDUsed, memoUsed, userIDUsed,1); //Save into BD obtaining the sportTypeID aSportTypeParent = aSportTypeParent.SaveData(connString); Assert.AreNotEqual(0, aSportTypeParent.SportTypeID); //saving correct data //Create a SportType object to be the child sportTypeNameUsed = "Deporte Hijo"; parentSportTypeIDUsed = aSportTypeParent.SportTypeID; memoUsed = "Deporte Hijo"; userIDUsed = 85; SportTypes aSportTypeChild = new SportTypes(); aSportTypeChild.LoadData(-1, sportTypeNameUsed, parentSportTypeIDUsed, memoUsed, userIDUsed,1); //Save into BD obtaining the sportTypeID aSportTypeChild = aSportTypeChild.SaveData(connString); Assert.AreNotEqual(0, aSportTypeChild.SportTypeID); //saving correct data //Try to find the parent sport type. SportTypes parentSportTypeToFind = new SportTypes(); parentSportTypeToFind = aSportTypeChild.FindParentSportType(connString); Assert.AreNotEqual(-1, parentSportTypeToFind.SportTypeID); //Found it!! Assert.AreEqual(aSportTypeParent.SportTypeID, parentSportTypeToFind.SportTypeID); Assert.AreEqual(aSportTypeParent.SportTypeName, parentSportTypeToFind.SportTypeName); Assert.AreEqual(aSportTypeParent.ParentSportTypeID, parentSportTypeToFind.ParentSportTypeID,1); Assert.AreEqual(aSportTypeParent.Memo, parentSportTypeToFind.Memo); //Deleting object previously saved int res = aSportTypeParent.Delete(connString); Assert.AreEqual(1, res); //Deleting object previously saved res = aSportTypeChild.Delete(connString); Assert.AreEqual(1, res); }