public void ReadAll_Create3Records_3DifferentRecords() { //Assemble DogModel dogModel1 = new DogModel(); dogModel1.name = "Ted"; dogModel1.clientID = clientId; dogModel1.age = 8; dogModel1.breed = "Shi Tzu"; dogModel1.experienceOrQualification = false; DogModel dogModel2 = new DogModel(); dogModel2.name = "Ted 2"; dogModel2.clientID = clientId; dogModel2.age = 82; dogModel2.breed = "Shi Tzu 2"; dogModel2.experienceOrQualification = true; DogModel dogModel3 = new DogModel(); dogModel3.name = "Ted 3"; dogModel3.clientID = clientId; dogModel3.age = 83; dogModel3.breed = "Shi Tzu 3"; dogModel3.experienceOrQualification = false; DogTable dogTable = new DogTable(); //Act int dogID1 = dogTable.create(dogModel1); int dogID2 = dogTable.create(dogModel2); int dogID3 = dogTable.create(dogModel3); List <DogModel> actual = dogTable.readAll(); //Assert Assert.AreEqual(dogID1, dogID1); Assert.AreEqual(dogModel1.name, actual[0].name); Assert.AreEqual(dogModel1.clientID, actual[0].clientID); Assert.AreEqual(dogModel1.age, actual[0].age); Assert.AreEqual(dogModel1.breed, actual[0].breed); Assert.AreEqual(dogModel1.experienceOrQualification, actual[0].experienceOrQualification); Assert.AreEqual(dogID2, dogID2); Assert.AreEqual(dogModel2.name, actual[1].name); Assert.AreEqual(dogModel2.clientID, actual[1].clientID); Assert.AreEqual(dogModel2.age, actual[1].age); Assert.AreEqual(dogModel2.breed, actual[1].breed); Assert.AreEqual(dogModel2.experienceOrQualification, actual[1].experienceOrQualification); Assert.AreEqual(dogID3, dogID3); Assert.AreEqual(dogModel3.name, actual[2].name); Assert.AreEqual(dogModel3.clientID, actual[2].clientID); Assert.AreEqual(dogModel3.age, actual[2].age); Assert.AreEqual(dogModel3.breed, actual[2].breed); Assert.AreEqual(dogModel3.experienceOrQualification, actual[2].experienceOrQualification); }
public void Update_CreatedUpdateAndRead1Record_UpdatedValues() { //Assemble DogModel dogModel = new DogModel(); dogModel.name = "Ted"; dogModel.clientID = clientId; dogModel.age = 8; dogModel.breed = "Shi Tzu"; dogModel.experienceOrQualification = false; DogTable dogTable = new DogTable(); int dogID = dogTable.create(dogModel); dogModel.id = dogID; dogModel.clientID = clientId; dogModel.name = "Coco"; dogModel.age = 17; dogModel.breed = "Yorkshire Terrier"; dogModel.experienceOrQualification = true; //Act dogTable.update(dogModel); DogModel actual = dogTable.read(dogID); //Assert Assert.AreEqual(dogModel.name, actual.name); Assert.AreEqual(dogModel.clientID, actual.clientID); Assert.AreEqual(dogModel.age, actual.age); Assert.AreEqual(dogModel.breed, actual.breed); Assert.AreEqual(dogModel.experienceOrQualification, actual.experienceOrQualification); }
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); }
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_CountIs3() { //Assemble DogModel dogModel1 = new DogModel(); dogModel1.name = "Ted"; dogModel1.clientID = clientId; dogModel1.age = 8; dogModel1.breed = "Shi Tzu"; dogModel1.experienceOrQualification = false; DogModel dogModel2 = new DogModel(); dogModel2.name = "Ted 2"; dogModel2.clientID = clientId; dogModel2.age = 82; dogModel2.breed = "Shi Tzu 2"; dogModel2.experienceOrQualification = true; DogModel dogModel3 = new DogModel(); dogModel3.name = "Ted 3"; dogModel3.clientID = clientId; dogModel3.age = 83; dogModel3.breed = "Shi Tzu 3"; dogModel3.experienceOrQualification = false; DogTable dogTable = new DogTable(); int expected = 3; //Act int dogID1 = dogTable.create(dogModel1); int dogID2 = dogTable.create(dogModel2); int dogID3 = dogTable.create(dogModel3); List <DogModel> actual = dogTable.readAll(); //Assert Assert.AreEqual(expected, actual.Count); }
public void Count_Created1Record_1() { //Assemble DogModel dogModel = new DogModel(); dogModel.name = "Ted"; dogModel.clientID = clientId; dogModel.age = 8; dogModel.breed = "Shi Tzu"; dogModel.experienceOrQualification = false; int expected = 1; DogTable dogTable = new DogTable(); //Act int dogID = dogTable.create(dogModel); int actual = dogTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void Create_ValidData_DogIDReturned() { //Assemble DogModel dogModel = new DogModel(); dogModel.name = "Ted"; dogModel.clientID = clientId; dogModel.age = 8; dogModel.breed = "Shi Tzu"; dogModel.experienceOrQualification = false; //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; DogTable dogTable = new DogTable(); //Act int actual = dogTable.create(dogModel); //Assert Assert.AreNotEqual(notCreated, actual); }
public void Read_CreatedAndRead1Record_CorrectValues() { //Assemble DogModel dogModel = new DogModel(); dogModel.name = "Ted"; dogModel.clientID = clientId; dogModel.age = 8; dogModel.breed = "Shi Tzu"; dogModel.experienceOrQualification = false; DogTable dogTable = new DogTable(); //Act int dogID = dogTable.create(dogModel); DogModel actual = dogTable.read(dogID); //Assert Assert.AreEqual(dogModel.name, actual.name); Assert.AreEqual(dogModel.clientID, actual.clientID); Assert.AreEqual(dogModel.age, actual.age); Assert.AreEqual(dogModel.breed, actual.breed); Assert.AreEqual(dogModel.experienceOrQualification, actual.experienceOrQualification); }
private void populateDog() { DogTable dogTable = new DogTable(); dogModelThor = new DogModel(); dogModelThor.name = "Thor"; dogModelThor.clientID = clientIdJames; dogModelThor.age = 1; dogModelThor.breed = "Bulldog"; dogModelThor.experienceOrQualification = false; dogIdThor = dogTable.create(dogModelThor); dogModelOdin = new DogModel(); dogModelOdin.name = "Odin"; dogModelOdin.clientID = clientIdJames; dogModelOdin.age = 2; dogModelOdin.breed = "Shi Tzu"; dogModelOdin.experienceOrQualification = true; dogIdOdin = dogTable.create(dogModelOdin); dogModelLoki = new DogModel(); dogModelLoki.name = "Loki"; dogModelLoki.clientID = clientIdJames; dogModelLoki.age = 3; dogModelLoki.breed = "Beadle"; dogModelLoki.experienceOrQualification = true; dogIdLoki = dogTable.create(dogModelLoki); dogModelHela = new DogModel(); dogModelHela.name = "Hela"; dogModelHela.clientID = clientIdMark; dogModelHela.age = 4; dogModelHela.breed = "Poodle"; dogModelHela.experienceOrQualification = false; dogIdHela = dogTable.create(dogModelHela); dogModelHeimdall = new DogModel(); dogModelHeimdall.name = "Heimdall"; dogModelHeimdall.clientID = clientIdMark; dogModelHeimdall.age = 5; dogModelHeimdall.breed = "Bulldog"; dogModelHeimdall.experienceOrQualification = true; dogIdHeimdall = dogTable.create(dogModelHeimdall); dogModelBaldur = new DogModel(); dogModelBaldur.name = "Baldur"; dogModelBaldur.clientID = clientIdMark; dogModelBaldur.age = 6; dogModelBaldur.breed = "Shi Tzu"; dogModelBaldur.experienceOrQualification = false; dogIdBaldur = dogTable.create(dogModelBaldur); dogModelBragi = new DogModel(); dogModelBragi.name = "Bragi"; dogModelBragi.clientID = clientIdTed; dogModelBragi.age = 7; dogModelBragi.breed = "Poodle"; dogModelBragi.experienceOrQualification = true; dogIdBragi = dogTable.create(dogModelBragi); dogModelIdun = new DogModel(); dogModelIdun.name = "Idun"; dogModelIdun.clientID = clientIdTed; dogModelIdun.age = 8; dogModelIdun.breed = "Beagle"; dogModelIdun.experienceOrQualification = false; dogIdIdun = dogTable.create(dogModelIdun); dogModelNjord = new DogModel(); dogModelNjord.name = "Njord"; dogModelNjord.clientID = clientIdSam; dogModelNjord.age = 9; dogModelNjord.breed = "Shi Tzu"; dogModelNjord.experienceOrQualification = true; dogIdNjord = dogTable.create(dogModelNjord); dogModelFreya = new DogModel(); dogModelFreya.name = "Freya"; dogModelFreya.clientID = clientIdSam; dogModelFreya.age = 10; dogModelFreya.breed = "Bulldog"; dogModelFreya.experienceOrQualification = false; dogIdFreya = dogTable.create(dogModelFreya); dogModelFreyer = new DogModel(); dogModelFreyer.name = "Freyer"; dogModelFreyer.clientID = clientIdBarry; dogModelFreyer.age = 11; dogModelFreyer.breed = "Pug"; dogModelFreyer.experienceOrQualification = true; dogIdFreyer = dogTable.create(dogModelFreyer); dogModelForseti = new DogModel(); dogModelForseti.name = "Forseti"; dogModelForseti.clientID = clientIdBarry; dogModelForseti.age = 12; dogModelForseti.breed = "Beagle"; dogModelForseti.experienceOrQualification = false; dogIdForseti = dogTable.create(dogModelForseti); dogModelYmir = new DogModel(); dogModelYmir.name = "Ymir"; dogModelYmir.clientID = clientIdJim; dogModelYmir.age = 13; dogModelYmir.breed = "Shi Tzu"; dogModelYmir.experienceOrQualification = true; dogIdYmir = dogTable.create(dogModelYmir); dogModelMimir = new DogModel(); dogModelMimir.name = "Mimir"; dogModelMimir.clientID = clientIdJim; dogModelMimir.age = 14; dogModelMimir.breed = "Poodle"; dogModelMimir.experienceOrQualification = false; dogIdMimir = dogTable.create(dogModelMimir); dogModelThurd = new DogModel(); dogModelThurd.name = "Thurd"; dogModelThurd.clientID = clientIdRon; dogModelThurd.age = 15; dogModelThurd.breed = "Great Dane"; dogModelThurd.experienceOrQualification = true; dogIdThurd = dogTable.create(dogModelThurd); dogModelAngbroda = new DogModel(); dogModelAngbroda.name = "Angbroda"; dogModelAngbroda.clientID = clientIdSid; dogModelAngbroda.age = 16; dogModelAngbroda.breed = "Husky"; dogModelAngbroda.experienceOrQualification = false; dogIdAngbroda = dogTable.create(dogModelAngbroda); }
public void Setup() { new DataStoreTableHelper().clearAllTables(); ClientModel clientModel = new ClientModel(); clientModel.displayName = "Barry Bonds"; 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); ProgramVarietyModel programeVarietyModel = new ProgramVarietyModel(); programeVarietyModel.depositAmount = 20.0; programeVarietyModel.sessionCost = 20.0; programeVarietyModel.fullPaymentPercentageDiscount = 20; programeVarietyModel.name = "Regular"; programeVarietyModel.dogSpacesMaximum = 50; programeVarietyModel.noOfClasses = 50; ProgramVarietyTable programVarietyTable = new ProgramVarietyTable(); programVarietyId = programVarietyTable.create(programeVarietyModel); ProgramModel programModel = new ProgramModel(); programModel.programVarietyId = programVarietyId; ProgramTable programTable = new ProgramTable(); programId = programTable.create(programModel); EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.name = "A"; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; enrollmentModel.paymentMethod = 1; enrollmentModel.joinDate = new DateTime(2021, 01, 03); enrollmentModel.inviteIssued = true; EnrollmentTable enrollmentTable = new EnrollmentTable(); enrollmentId = enrollmentTable.create(enrollmentModel); }
private static void populateDatabase() { //clear all the records in all the tables new DataStoreTableHelper().clearAllTables(); //check the tables are empty consoleTableCounts(); //Adding some records to it will be easier to create and update the screens //add Client records ClientTable clientTable = new ClientTable(); ClientModel clientModelBob = new ClientModel(); clientModelBob.forename = "Bob"; clientModelBob.surname = "White"; clientModelBob.phone = "1234567890"; clientModelBob.email = "*****@*****.**"; clientModelBob.displayName = clientModelBob.forename + " " + clientModelBob.surname; int clientIdBob = clientTable.create(clientModelBob); ClientModel clientModelKate = new ClientModel(); clientModelKate.forename = "Kate"; clientModelKate.surname = "Black"; clientModelKate.phone = "1234567890"; clientModelKate.email = "*****@*****.**"; clientModelKate.displayName = clientModelKate.forename + " " + clientModelKate.surname; int clientIdKate = clientTable.create(clientModelKate); //add Dog records DogTable dogTable = new DogTable(); DogModel dogModelBoxer = new DogModel(); dogModelBoxer.name = "Boxer"; dogModelBoxer.clientID = clientIdBob; dogModelBoxer.age = 7; dogModelBoxer.breed = "Bulldog"; int dogIdBoxer = dogTable.create(dogModelBoxer); DogModel dogModelTed = new DogModel(); dogModelTed.name = "Ted"; dogModelTed.clientID = clientIdKate; dogModelTed.age = 7; dogModelTed.breed = "Shi Tzu"; int dogIdTed = dogTable.create(dogModelTed); //add Staff records StaffTable staffTable = new StaffTable(); StaffModel staffModelBob = new StaffModel(); staffModelBob.name = "Bob"; int staffIdBob = staffTable.create(staffModelBob); StaffModel staffModelKate = new StaffModel(); staffModelKate.name = "Kate"; int staffIdKate = staffTable.create(staffModelKate); //add ProgramVariety records ProgramVarietyTable programVarietyTable = new ProgramVarietyTable(); ProgramVarietyModel programVarietyAdvanced = new ProgramVarietyModel(); programVarietyAdvanced.name = "Advanced"; programVarietyAdvanced.depositAmount = 30.0; programVarietyAdvanced.fullPaymentPercentageDiscount = 0.0; programVarietyAdvanced.sessionCost = 30.0; programVarietyAdvanced.noOfClasses = 8; programVarietyAdvanced.dogSpacesMaximum = 8; int programCostId1 = programVarietyTable.create(programVarietyAdvanced); ProgramVarietyModel programVarietyRegular = new ProgramVarietyModel(); programVarietyRegular.name = "Regular"; programVarietyRegular.depositAmount = 20.0; programVarietyRegular.fullPaymentPercentageDiscount = 10.0; programVarietyRegular.sessionCost = 25.0; programVarietyRegular.noOfClasses = 6; programVarietyRegular.dogSpacesMaximum = 10; int programCostId2 = programVarietyTable.create(programVarietyRegular); //add Program records ProgramTable programTable = new ProgramTable(); ProgramModel programModel1 = new ProgramModel(); programModel1.name = "Regular AM"; programModel1.programVarietyId = programCostId2; int programId1 = programTable.create(programModel1); ProgramModel programModel2 = new ProgramModel(); programModel2.name = "Regular PM"; programModel2.programVarietyId = programCostId2; int programId2 = programTable.create(programModel2); ProgramModel programModel3 = new ProgramModel(); programModel3.name = "Advanced"; programModel3.programVarietyId = programCostId1; int programId3 = programTable.create(programModel3); //add Enrollment records EnrollmentTable enrollmentTable = new EnrollmentTable(); EnrollmentModel enrollmentModel1 = new EnrollmentModel(); enrollmentModel1.name = dogModelBoxer.name + " (owned by " + clientModelBob.displayName + ") in " + programModel1.name; enrollmentModel1.clientId = clientIdBob; enrollmentModel1.dogId = dogIdBoxer; enrollmentModel1.programId = programId1; enrollmentModel1.paymentMethod = PaymentConstants.PAYMENT_IN_FULL; enrollmentModel1.joinDate = DateTime.Now; enrollmentModel1.inviteIssued = false; int enrollmentId1 = enrollmentTable.create(enrollmentModel1); EnrollmentModel enrollmentModel2 = new EnrollmentModel(); enrollmentModel2.name = dogModelTed.name + " (owned by " + clientModelKate.displayName + ") in " + programModel2.name; enrollmentModel2.clientId = clientIdKate; enrollmentModel2.dogId = dogIdTed; enrollmentModel2.programId = programId2; enrollmentModel2.paymentMethod = PaymentConstants.PAYMENT_PER_CLASS; enrollmentModel2.joinDate = DateTime.Now; enrollmentModel2.inviteIssued = true; int enrollmentId2 = enrollmentTable.create(enrollmentModel2); //check the tables have records consoleTableCounts(); }