private void RefreshList() { //clear all the items from the ListView lsvDog.Items.Clear(); // make sure it is not just lvXXX.Clear() //read all the records from the table List <DogModel> dogList = new DogTable().readAll(); //loop through all the records foreach (var dog in dogList) { var clientIndex = new ForeignKeyHelper().findIndexOfClientID(clientList, dog.clientID); var clientName = clientList[clientIndex].displayName; //create an array that will hold all the fields in a row var row = new string[] { dog.id.ToString(), dog.clientID.ToString(), clientName, dog.name, dog.age.ToString(), dog.breed, dog.experienceOrQualification.ToString() }; var lvi = new ListViewItem(row); //Save the model in the tag property so we can use it if row is selected lvi.Tag = dog; //add new row to the ListView lsvDog.Items.Add(lvi); } lsvDog.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); }
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 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 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; DogTable dogTable = new DogTable(); //Act int actual = dogTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void OnStage() { SqlClient.Main.CreateCommand("update DOG set KDGD = @kdgd where undog = @undog", new SqlParam("kdgd", "C"), new SqlParam("undog", Cursor.GetFieldValue <int>("UNDOG"))).ExecNonQuery(); var dogRec = DogTable.GetRecord(Cursor.GetFieldValue <int>("UNDOG")); if (!DogStagin.CheckDocument(dogRec)) { DogStagin.CreateDocument(dogRec); } }
public void Delete_NonExistantId_0() { //Assemble DogTable dogTable = new DogTable(); int expected = 0; //Act dogTable.delete(0); int actual = dogTable.count(); //Assert Assert.AreEqual(expected, actual); }
public static int CreateDocument(DogTable.Record dogRecord) { var undog = dogRecord.Undog; //var dgt = Cursor.GetFieldValue<string>("KDGT"); var dgt = (dogRecord.Undog_pr == 0) ? dogRecord.Kdgt : DogTable.GetRecord(dogRecord.Undog_pr, new String[] { "KDGT" }).Kdgt; //var dogstatus = Cursor.GetFieldValue<string>("KDGD"); //var docType = SqlClient.Main.CreateCommand("select KDMT from DOGC_ where KDGT = @KDGT and KDGD = @KDGD", // new SqlParam("KDGT", dgt), // new SqlParam("KDGD", dogstatus)).ExecScalar<string>(); //var docType = SqlClient.Main.CreateCommand(@"select PROTTYPE_ from dgt wher"); var docType = DgtTable.GetRecord(dgt, new[] { "PROTTYPE_" }).GetFieldValue <string>("PROTTYPE_").Split(',').FirstOrDefault(); //Формирование документа var document = new Document(); document.FillDocConfig(docType); document.ContractorCode = dogRecord.Org; document.ContractCode = undog; document.Status = DocStatus.Project; //Добавление документа в SQL var docRepo = new HeadersRepository(); docRepo.Add(document); //Установка документа на 1ю стадию var dmz = new DataEditor.StartInfo("DMZ10") { TemplateId = "DMZ", StartMode = new DataEditor.StartInfo.DataEditorStartMode( new DataEditor.StartInfo.WorkflowStartMode(WorkflowProcessMode.SetRoute) { ExitAfterCall = true }), PrimaryKeyFilter = new Dictionary <string, object>() { { "UNDOC", document.Undoc } }, Editable = true }; var dc = new DocumentCondition(ConditionDbType.Dmz); dmz.Cursors["DMZ"].CustomProperties.Add(DocumentCaller.DocumentConditionPropertyName, dc); DataEditor.Call(dmz); return(document.Undoc); }
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); }
private static void consoleTableCounts() { Console.WriteLine("How many records in the tables"); Console.WriteLine("=============================="); Int32 classCount = new ClassTable().count(); Console.WriteLine("classCount = " + classCount); Int32 clientCount = new ClientTable().count(); Console.WriteLine("clientCount = " + clientCount); Int32 dogCount = new DogTable().count(); Console.WriteLine("dogCount = " + dogCount); Int32 enrollmentCount = new EnrollmentTable().count(); Console.WriteLine("enrollmentCount = " + enrollmentCount); Int32 paymentCount = new PaymentTable().count(); Console.WriteLine("paymentCount = " + paymentCount); Int32 programCostCount = new ProgramVarietyTable().count(); Console.WriteLine("programCostCount = " + programCostCount); Int32 programCount = new ProgramTable().count(); Console.WriteLine("programCount = " + programCount); Int32 staffCount = new StaffTable().count(); Console.WriteLine("staffCount = " + staffCount); Console.WriteLine("=============================="); }
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 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); }
public bool Next() { return(DogStagin.CheckDocument(DogTable.GetRecord(Cursor.GetFieldValue <int>("UNDOG")))); }
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 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); }
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(); }