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 Count_AllRecordsDeleted_0() { //Assemble int expected = 0; ProgramCostTable programCostTable = new ProgramCostTable(); //Act int actual = programCostTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void Delete_NonExistantId_0() { //Assemble ProgramCostTable programCostTable = new ProgramCostTable(); int expected = 0; //Act programCostTable.delete(0); int actual = programCostTable.count(); //Assert Assert.AreEqual(expected, actual); }
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); }