public void SportType_CheckDataBeforeSave()
{
//Create a SportType object with data.
aSportType.LoadData(-1, "Weird Sport", 0, "any kind of weird sport", 85,1);
int res = aSportType.CheckData(connString);
Assert.AreEqual(1, res); //Data are ok because the type of sport isn´t in de BD.
//Save the data into BD, and check again.
aSportType = aSportType.SaveData(connString);
Int64 sportTypeIDUsed = aSportType.SportTypeID;
Int64 userIDUsed = aSportType.UserID;
res = aSportType.CheckData(connString);
Assert.AreEqual(-1, res); //Data are not ok, SportTypeName is in de BD.
//Create a SportType object with data:
aSportType.LoadData(-1, "Weird Sport2", -10, "any kind of weird sport", 85,1);
res = aSportType.CheckData(connString);
Assert.AreEqual(-2, res); //Data are not ok, parentSportID does not exist on SportTypes
//Create a SportType object with data:
aSportType.LoadData(-1, "", 0, "any kind of weird sport", 85,1);
res = aSportType.CheckData(connString);
Assert.AreEqual(0, res); //Data are not ok, SportTypeName is empty.
//Create a SportType object with data:
aSportType.LoadData(-1, "Weird Sport2", 0, "any kind of weird sport", -100,1);
res = aSportType.CheckData(connString);
Assert.AreEqual(-3, res); //Data are not ok, userID not in data base.
//Deleting object saved first.
aSportType = aSportType.FindSportTypeByID(connString);
res = aSportType.Delete(connString);
Assert.AreEqual(1, res);
}
public SportTypes FindParentSportType(string connString)
{
//Return an object containing the parent SportType.
SportTypes aSportType = new SportTypes();
aSportType.SportTypeID = parentSportTypeID;
aSportType.UserID = userID;
aSportType = aSportType.FindSportTypeByID(connString);
return aSportType;
}
//Check if data into de object is correct to save into de BD
public int CheckData(string connString)
{
// 1: Data is ok
// 0: SportType Name not given
//-1: SportTypeName exist on BD.
//-2: ParentSportID does not exist on BD and is different to 0(root)
SportTypes aST = new SportTypes();
int res = 1;
bool sigue = true;
if ((sportTypeName == "") || (sportTypeName == null))
{
sigue = false;
res = 0; //0: SportType Name not given
}
if (sigue)
{
aST.sportTypeName = sportTypeName;
aST.userID = userID;
aST = aST.FindSportTypeByName(connString);
if (aST.SportTypeID != -1)
{
sigue = false;
res = -1; //-1: SportTypeName exist on BD.
}
}
if (sigue)
{
if (parentSportTypeID != 0)
{
aST.sportTypeID = parentSportTypeID;
aST.userID = userID;
aST = aST.FindSportTypeByID(connString);
if (aST.SportTypeID == -1)
{
sigue = false;
res = -2; //-2: ParentSportID does not exist on BD and is different to 0(root)
}
}
}
return res;
}
public void SportType_Update()
{
//Create a SportType object
string sportTypeNameUsed = "Bicicleta";
Int64 parentSportTypeIDUsed = 0;
string memoUsed = "Deportes de bicicleta";
Int64 userIDUsed = 85;
SportTypes aSportType = new SportTypes();
aSportType.LoadData(-1, sportTypeNameUsed, parentSportTypeIDUsed, memoUsed, userIDUsed,1);
//Save into BD obtaining the sportTypeID
aSportType = aSportType.SaveData(connString);
Assert.AreNotEqual(0, aSportType.SportTypeID);
Assert.AreNotEqual(0, aSportType.SportTypeID); //saving correct data
Int64 sportTypeIDUsed = aSportType.SportTypeID;
//Try to find and check values
aSportType = aSportType.FindSportTypeByName(connString);
Assert.AreNotEqual(-1, aSportType.SportTypeID);
Assert.AreEqual(sportTypeNameUsed, aSportType.SportTypeName);
Assert.AreEqual(parentSportTypeIDUsed, aSportType.ParentSportTypeID);
Assert.AreEqual(memoUsed, aSportType.Memo);
Assert.AreEqual(userIDUsed, aSportType.UserID);
//Update values
sportTypeNameUsed = "Bike Updated";
parentSportTypeIDUsed = 0;
memoUsed = "Deportes de bicicleta updated";
userIDUsed = 85;
aSportType.LoadData(sportTypeIDUsed, sportTypeNameUsed, parentSportTypeIDUsed, memoUsed, userIDUsed,1);
aSportType.UpdateData(connString);
//Try to find and check values
aSportType = aSportType.FindSportTypeByName(connString);
Assert.AreNotEqual(-1, aSportType.SportTypeID);
Assert.AreEqual(sportTypeNameUsed, aSportType.SportTypeName);
Assert.AreEqual(parentSportTypeIDUsed, aSportType.ParentSportTypeID);
Assert.AreEqual(memoUsed, aSportType.Memo);
Assert.AreEqual(userIDUsed, aSportType.UserID);
//Deleting object previously saved
int res = aSportType.Delete(connString);
Assert.AreEqual(1, res);
//Try to find again after deleting
aSportType = aSportType.FindSportTypeByID(connString);
Assert.AreEqual(-1, aSportType.SportTypeID);
}
