public void CreateFullPaymentPercentageDiscountConstraint_OnUpperBoundry_NoException()
{
//Assemble
ProgramCostTable programCostTable = new ProgramCostTable();
ProgramCostModel programCostModel = new ProgramCostModel();
programCostModel.depositAmount = 50.0;
programCostModel.sessionCost = 50.0;
programCostModel.fullPaymentPercentageDiscount = 100.0;
int expected = 0;
int counter = 0;
//Act
try
{
int id = programCostTable.create(programCostModel);
}
catch (Exception ex)
{
counter++;
}
//Assert
Assert.AreEqual(expected, counter);
}
public void Update_CreatedUpdateAndRead1Record_UpdatedValues()
{
//Assemble
ProgramCostModel programCostModel = new ProgramCostModel();
programCostModel.depositAmount = 49.0;
programCostModel.sessionCost = 50.0;
programCostModel.fullPaymentPercentageDiscount = 51.0;
ProgramCostTable programCostTable = new ProgramCostTable();
int programCostID = programCostTable.create(programCostModel);
programCostModel.id = programCostID;
programCostModel.depositAmount = 49.1;
programCostModel.sessionCost = 50.1;
programCostModel.fullPaymentPercentageDiscount = 51.4;
//Act
programCostTable.update(programCostModel);
ProgramCostModel actual = programCostTable.read(programCostID);
//Assert
Assert.AreEqual(programCostModel.depositAmount, actual.depositAmount);
Assert.AreEqual(programCostModel.sessionCost, actual.sessionCost);
Assert.AreEqual(programCostModel.fullPaymentPercentageDiscount, actual.fullPaymentPercentageDiscount);
}
public void ReadAll_Create3Records_CountIs3()
{
//Assemble
ProgramCostModel programCostModel1 = new ProgramCostModel();
programCostModel1.depositAmount = 49.1;
programCostModel1.sessionCost = 50.1;
programCostModel1.fullPaymentPercentageDiscount = 51.1;
ProgramCostModel programCostModel2 = new ProgramCostModel();
programCostModel2.depositAmount = 49.2;
programCostModel2.sessionCost = 50.2;
programCostModel2.fullPaymentPercentageDiscount = 51.2;
ProgramCostModel programCostModel3 = new ProgramCostModel();
programCostModel3.depositAmount = 49.3;
programCostModel3.sessionCost = 50.3;
programCostModel3.fullPaymentPercentageDiscount = 51.3;
ProgramCostTable programCostTable = new ProgramCostTable();
int expected = 3;
//Act
int programCostID1 = programCostTable.create(programCostModel1);
int programCostID2 = programCostTable.create(programCostModel2);
int programCostID3 = programCostTable.create(programCostModel3);
List <ProgramCostModel> actual = programCostTable.readAll();
//Assert
Assert.AreEqual(expected, actual.Count);
}
public void Setup()
{
new DataStoreTableHelper().clearAllTables();
ClientModel clientModel = new ClientModel();
clientModel.name = "Bob";
clientModel.phone = "1234567890";
clientModel.email = "*****@*****.**";
ClientTable clientTable = new ClientTable();
clientId = clientTable.create(clientModel);
DogModel dogModel = new DogModel();
dogModel.clientID = clientId;
dogModel.name = "Dog";
dogModel.age = 6;
dogModel.breed = "Terrier";
dogModel.experienceOrQualification = false;
DogTable dogTable = new DogTable();
dogId = dogTable.create(dogModel);
ProgramTypeModel programTypeModel = new ProgramTypeModel();
programTypeModel.description = "Regular";
ProgramTypeTable programTypeTable = new ProgramTypeTable();
programTypeId = programTypeTable.create(programTypeModel);
ProgramCostModel programeCostModel = new ProgramCostModel();
programeCostModel.depositAmount = 20.0;
programeCostModel.sessionCost = 20.0;
programeCostModel.fullPaymentPercentageDiscount = 20;
ProgramCostTable programCostTable = new ProgramCostTable();
programeCostId = programCostTable.create(programeCostModel);
ProgramModel programModel = new ProgramModel();
programModel.programTypeId = programTypeId;
programModel.programCostId = programeCostId;
programModel.dogSpacesMaximum = 50;
programModel.noOfClasses = 50;
ProgramTable programTable = new ProgramTable();
programId = programTable.create(programModel);
}
public void ReadAll_Create3Records_3DifferentRecords()
{
//Assemble
ProgramCostModel programCostModel1 = new ProgramCostModel();
programCostModel1.depositAmount = 49.1;
programCostModel1.sessionCost = 50.1;
programCostModel1.fullPaymentPercentageDiscount = 51.1;
ProgramCostModel programCostModel2 = new ProgramCostModel();
programCostModel2.depositAmount = 49.2;
programCostModel2.sessionCost = 50.2;
programCostModel2.fullPaymentPercentageDiscount = 51.2;
ProgramCostModel programCostModel3 = new ProgramCostModel();
programCostModel3.depositAmount = 49.3;
programCostModel3.sessionCost = 50.3;
programCostModel3.fullPaymentPercentageDiscount = 51.3;
ProgramCostTable programCostTable = new ProgramCostTable();
//Act
int programCostID1 = programCostTable.create(programCostModel1);
int programCostID2 = programCostTable.create(programCostModel2);
int programCostID3 = programCostTable.create(programCostModel3);
List <ProgramCostModel> actual = programCostTable.readAll();
//Assert
Assert.AreEqual(programCostID1, programCostID1);
Assert.AreEqual(programCostModel1.depositAmount, actual[0].depositAmount);
Assert.AreEqual(programCostModel1.sessionCost, actual[0].sessionCost);
Assert.AreEqual(programCostModel1.fullPaymentPercentageDiscount, actual[0].fullPaymentPercentageDiscount);
Assert.AreEqual(programCostID2, programCostID2);
Assert.AreEqual(programCostModel2.depositAmount, actual[1].depositAmount);
Assert.AreEqual(programCostModel2.sessionCost, actual[1].sessionCost);
Assert.AreEqual(programCostModel2.fullPaymentPercentageDiscount, actual[1].fullPaymentPercentageDiscount);
Assert.AreEqual(programCostID3, programCostID3);
Assert.AreEqual(programCostModel3.depositAmount, actual[2].depositAmount);
Assert.AreEqual(programCostModel3.sessionCost, actual[2].sessionCost);
Assert.AreEqual(programCostModel3.fullPaymentPercentageDiscount, actual[2].fullPaymentPercentageDiscount);
}
public void Count_Created1Record_1()
{
//Assemble
ProgramCostModel programCostModel = new ProgramCostModel();
programCostModel.depositAmount = 49.0;
programCostModel.sessionCost = 50.0;
programCostModel.fullPaymentPercentageDiscount = 51.0;
int expected = 1;
ProgramCostTable programCostTable = new ProgramCostTable();
//Act
int programCostID = programCostTable.create(programCostModel);
int actual = programCostTable.count();
//Assert
Assert.AreEqual(expected, actual);
}
public void Create_ValidData_ProgramCostIDReturned()
{
//Assemble
ProgramCostModel programCostModel = new ProgramCostModel();
programCostModel.depositAmount = 49.0;
programCostModel.sessionCost = 50.0;
programCostModel.fullPaymentPercentageDiscount = 51.0;
//If created will be greater than 0, but we don't know exactly what it will be because deleting all records doesnt set the ID counter back to 0
int notCreated = 0;
ProgramCostTable programCostTable = new ProgramCostTable();
//Act
int actual = programCostTable.create(programCostModel);
//Assert
Assert.AreNotEqual(notCreated, actual);
}
public void Setup()
{
new DataStoreTableHelper().clearAllTables();
ProgramTypeModel programTypeModel = new ProgramTypeModel();
programTypeModel.description = "Regular";
ProgramTypeTable programTypeTable = new ProgramTypeTable();
programTypeId = programTypeTable.create(programTypeModel);
ProgramCostModel programeCostModel = new ProgramCostModel();
programeCostModel.depositAmount = 20.0;
programeCostModel.sessionCost = 20.0;
programeCostModel.fullPaymentPercentageDiscount = 20;
ProgramCostTable programCostTable = new ProgramCostTable();
programeCostId = programCostTable.create(programeCostModel);
ProgramModel programModel = new ProgramModel();
programModel.programTypeId = programTypeId;
programModel.programCostId = programeCostId;
programModel.dogSpacesMaximum = 50;
programModel.noOfClasses = 50;
ProgramTable programTable = new ProgramTable();
programId = programTable.create(programModel);
StaffModel staffModel = new StaffModel();
staffModel.name = "Bob";
StaffTable staffTable = new StaffTable();
staffId = staffTable.create(staffModel);
}
public void Setup()
{
new DataStoreTableHelper().clearAllTables();
ProgramTypeModel programTypeModel = new ProgramTypeModel();
programTypeModel.description = "Regular";
ProgramTypeTable programTypeTable = new ProgramTypeTable();
programTypeId = programTypeTable.create(programTypeModel);
ProgramCostModel programeCostModel = new ProgramCostModel();
programeCostModel.depositAmount = 20.0;
programeCostModel.sessionCost = 20.0;
programeCostModel.fullPaymentPercentageDiscount = 20;
ProgramCostTable programCostTable = new ProgramCostTable();
programCostId = programCostTable.create(programeCostModel);
}
