public void Update_CreatedUpdateAndRead1Record_UpdatedValues() { //Assemble WaitingListModel waitingListModel = new WaitingListModel(); waitingListModel.clientId = clientId; waitingListModel.dogId = dogId; waitingListModel.programTypeId = programTypeId; waitingListModel.joinDate = new DateTime(2003, 01, 06); waitingListModel.inviteIssued = false; WaitingListTable waitingListTable = new WaitingListTable(); int waitingListID = waitingListTable.create(waitingListModel); waitingListModel.id = waitingListID; waitingListModel.clientId = clientId; waitingListModel.dogId = dogId; waitingListModel.programTypeId = programTypeId; waitingListModel.joinDate = new DateTime(2003, 01, 06); waitingListModel.inviteIssued = false; //Act waitingListTable.update(waitingListModel); WaitingListModel actual = waitingListTable.read(waitingListID); //Assert Assert.AreEqual(waitingListModel.clientId, actual.clientId); Assert.AreEqual(waitingListModel.dogId, actual.dogId); Assert.AreEqual(waitingListModel.programTypeId, actual.programTypeId); Assert.AreEqual(waitingListModel.joinDate, actual.joinDate); Assert.AreEqual(waitingListModel.inviteIssued, actual.inviteIssued); }
public void ReadAll_Create3Records_3DifferentRecords() { //Assemble WaitingListModel waitingListModel1 = new WaitingListModel(); waitingListModel1.clientId = clientId; waitingListModel1.dogId = dogId; waitingListModel1.programTypeId = programTypeId; waitingListModel1.joinDate = new DateTime(2003, 01, 06); waitingListModel1.inviteIssued = false; WaitingListModel waitingListModel2 = new WaitingListModel(); waitingListModel2.clientId = clientId; waitingListModel2.dogId = dogId; waitingListModel2.programTypeId = programTypeId; waitingListModel2.joinDate = new DateTime(2003, 01, 06); waitingListModel2.inviteIssued = false; WaitingListModel waitingListModel3 = new WaitingListModel(); waitingListModel3.clientId = clientId; waitingListModel3.dogId = dogId; waitingListModel3.programTypeId = programTypeId; waitingListModel3.joinDate = new DateTime(2003, 01, 06); waitingListModel3.inviteIssued = false; WaitingListTable waitingListTable = new WaitingListTable(); //Act int waitingListID1 = waitingListTable.create(waitingListModel1); int waitingListID2 = waitingListTable.create(waitingListModel2); int waitingListID3 = waitingListTable.create(waitingListModel3); List <WaitingListModel> actual = waitingListTable.readAll(); //Assert Assert.AreEqual(waitingListID1, waitingListID1); Assert.AreEqual(waitingListModel1.dogId, actual[0].dogId); Assert.AreEqual(waitingListModel1.programTypeId, actual[0].programTypeId); Assert.AreEqual(waitingListModel1.joinDate, actual[0].joinDate); Assert.AreEqual(waitingListModel1.inviteIssued, actual[0].inviteIssued); Assert.AreEqual(waitingListID2, waitingListID2); Assert.AreEqual(waitingListModel2.dogId, actual[1].dogId); Assert.AreEqual(waitingListModel2.programTypeId, actual[1].programTypeId); Assert.AreEqual(waitingListModel2.joinDate, actual[1].joinDate); Assert.AreEqual(waitingListModel2.inviteIssued, actual[1].inviteIssued); Assert.AreEqual(waitingListID3, waitingListID3); Assert.AreEqual(waitingListModel3.dogId, actual[2].dogId); Assert.AreEqual(waitingListModel3.programTypeId, actual[2].programTypeId); Assert.AreEqual(waitingListModel3.joinDate, actual[2].joinDate); Assert.AreEqual(waitingListModel3.inviteIssued, actual[2].inviteIssued); }
public void Count_AllRecordsDeleted_0() { //Assemble int expected = 0; WaitingListTable waitingListTable = new WaitingListTable(); //Act int actual = waitingListTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void Delete_NonExistantId_0() { //Assemble WaitingListTable waitingListTable = new WaitingListTable(); int expected = 0; //Act waitingListTable.delete(0); int actual = waitingListTable.count(); //Assert Assert.AreEqual(expected, actual); }
private void AddRecord() { msSQLTransport = new MSSQLTransport(); var regex = new Regex(@"[\d*]{1,}"); string req = "", loc = ""; var cBIN = JournalC01CompanyInfo.bin.Replace(" ", ""); long bankId; cBIN = regex.Match(cBIN).ToString(); if (!string.IsNullOrEmpty(cBIN)) { dataSet = msSQLTransport.Execute("select top 1 a.* from altair.dbo.companiesView a where a.bin like '%" + cBIN + "%'"); } if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { loc = dataSet.Tables[0].Rows[0].Field <string>("addrJur"); bankId = dataSet.Tables[0].Rows[0].Field <long>("bankId"); req = "БИН " + cBIN + "\n"; req += "БИК " + dataSet.Tables[0].Rows[0].Field <string>("bik") + "\n"; req += "Кбе " + dataSet.Tables[0].Rows[0].Field <string>("kbe") + "\n"; req += "ИИК " + dataSet.Tables[0].Rows[0].Field <string>("iik") + "\n"; dataSet = msSQLTransport.Execute("select a.* from altair.dbo.banksView a where a.id='" + bankId + "'"); if (dataSet != null && dataSet.Tables.Count > 0) { req += "Банк " + dataSet.Tables[0].Rows[0].Field <string>("bankName") + "\n"; } } else { req = "Данных в базе не обнаружено"; } WaitingListTable.Add(new WaitingListTable { company = "Код клиента: " + SupplierCode + "\n" + SupplierName + "\n Код брокера: " + BrokerCode + "\n" + BrokerName, bankReq = req, location = loc }); }
public void Count_Created1Record_1() { //Assemble WaitingListModel waitingListModel = new WaitingListModel(); waitingListModel.clientId = clientId; waitingListModel.dogId = dogId; waitingListModel.programTypeId = programTypeId; waitingListModel.joinDate = new DateTime(2003, 01, 06); waitingListModel.inviteIssued = false; int expected = 1; WaitingListTable waitingListTable = new WaitingListTable(); //Act int waitingListID = waitingListTable.create(waitingListModel); int actual = waitingListTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void Create_ValidData_WaitingListIDReturned() { //Assemble WaitingListModel waitingListModel = new WaitingListModel(); waitingListModel.clientId = clientId; waitingListModel.dogId = dogId; waitingListModel.programTypeId = programTypeId; waitingListModel.joinDate = new DateTime(2003, 01, 06); waitingListModel.inviteIssued = 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; WaitingListTable waitingListTable = new WaitingListTable(); //Act int actual = waitingListTable.create(waitingListModel); //Assert Assert.AreNotEqual(notCreated, actual); }
public void ReadAll_Create3Records_CountIs3() { //Assemble WaitingListModel waitingListModel1 = new WaitingListModel(); waitingListModel1.clientId = clientId; waitingListModel1.dogId = dogId; waitingListModel1.programTypeId = programTypeId; waitingListModel1.joinDate = new DateTime(2003, 01, 06); waitingListModel1.inviteIssued = false; WaitingListModel waitingListModel2 = new WaitingListModel(); waitingListModel2.clientId = clientId; waitingListModel2.dogId = dogId; waitingListModel2.programTypeId = programTypeId; waitingListModel2.joinDate = new DateTime(2003, 01, 06); waitingListModel2.inviteIssued = false; WaitingListModel waitingListModel3 = new WaitingListModel(); waitingListModel3.clientId = clientId; waitingListModel3.dogId = dogId; waitingListModel3.programTypeId = programTypeId; waitingListModel3.joinDate = new DateTime(2003, 01, 06); waitingListModel3.inviteIssued = false; WaitingListTable waitingListTable = new WaitingListTable(); int expected = 3; //Act int waitingListID1 = waitingListTable.create(waitingListModel1); int waitingListID2 = waitingListTable.create(waitingListModel2); int waitingListID3 = waitingListTable.create(waitingListModel3); List <WaitingListModel> actual = waitingListTable.readAll(); //Assert Assert.AreEqual(expected, actual.Count); }
private void DeleteRecord() { WaitingListTable.Remove(SelWaitingListTable); }