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);
}
