public void ReadAll_Create3Records_3DifferentRecords()
{
//Assemble
ClassModel classModel1 = new ClassModel();
classModel1.programId = programId;
classModel1.staffId = staffId;
classModel1.classDate = new DateTime(2021, 10, 01);
classModel1.startTime = new TimeSpan(2, 31, 0);
classModel1.endTime = new TimeSpan(3, 31, 0);
ClassModel classModel2 = new ClassModel();
classModel2.programId = programId;
classModel2.staffId = staffId;
classModel2.classDate = new DateTime(2021, 10, 02);
classModel2.startTime = new TimeSpan(2, 32, 0);
classModel2.endTime = new TimeSpan(3, 32, 0);
ClassModel classModel3 = new ClassModel();
classModel3.programId = programId;
classModel3.staffId = staffId;
classModel3.classDate = new DateTime(2021, 10, 03);
classModel3.startTime = new TimeSpan(2, 33, 0);
classModel3.endTime = new TimeSpan(3, 33, 0);
ClassTable classTable = new ClassTable();
//Act
int classID1 = classTable.create(classModel1);
int classID2 = classTable.create(classModel2);
int classID3 = classTable.create(classModel3);
List <ClassModel> actual = classTable.readAll();
//Assert
Assert.AreEqual(classID1, classID1);
Assert.AreEqual(classModel1.programId, actual[0].programId);
Assert.AreEqual(classModel1.staffId, actual[0].staffId);
Assert.AreEqual(classModel1.classDate, actual[0].classDate);
Assert.AreEqual(classModel1.startTime, actual[0].startTime);
Assert.AreEqual(classModel1.endTime, actual[0].endTime);
Assert.AreEqual(classID2, classID2);
Assert.AreEqual(classModel2.programId, actual[1].programId);
Assert.AreEqual(classModel2.staffId, actual[1].staffId);
Assert.AreEqual(classModel2.classDate, actual[1].classDate);
Assert.AreEqual(classModel2.startTime, actual[1].startTime);
Assert.AreEqual(classModel2.endTime, actual[1].endTime);
Assert.AreEqual(classID3, classID3);
Assert.AreEqual(classModel3.programId, actual[2].programId);
Assert.AreEqual(classModel3.staffId, actual[2].staffId);
Assert.AreEqual(classModel3.classDate, actual[2].classDate);
Assert.AreEqual(classModel3.startTime, actual[2].startTime);
Assert.AreEqual(classModel3.endTime, actual[2].endTime);
}
public void Update_CreatedUpdateAndRead1Record_UpdatedValues()
{
//Assemble
ClassModel classModel = new ClassModel();
classModel.programId = programId;
classModel.staffId = staffId;
classModel.classDate = new DateTime(2021, 10, 03);
classModel.startTime = new TimeSpan(2, 33, 0);
classModel.endTime = new TimeSpan(3, 33, 0);
ClassTable classTable = new ClassTable();
int classID = classTable.create(classModel);
classModel.id = classID;
classModel.programId = programId;
classModel.staffId = staffId;
classModel.classDate = new DateTime(2021, 10, 03);
classModel.startTime = new TimeSpan(2, 33, 0);
classModel.endTime = new TimeSpan(3, 33, 0);
//Act
classTable.update(classModel);
ClassModel actual = classTable.read(classID);
//Assert
Assert.AreEqual(classModel.programId, actual.programId);
Assert.AreEqual(classModel.staffId, actual.staffId);
Assert.AreEqual(classModel.classDate, actual.classDate);
Assert.AreEqual(classModel.startTime, actual.startTime);
Assert.AreEqual(classModel.endTime, actual.endTime);
}
private void populateClasses()
{
ClassTable classTable = new ClassTable();
//regular classes
for (var i = 0; i <= 5; i++)
{
ClassModel classModel = new ClassModel();
classModel.programId = programIdRegular1;
classModel.staffId = staffIdAllison;
classModel.classDate = DateTime.Now.AddDays((i * 7) + 1);
classModel.startTime = TimeSpan.Parse("09:30");
classModel.endTime = TimeSpan.Parse("11:30");
classTable.create(classModel);
}
//regular classes
for (var i = 0; i <= 5; i++)
{
ClassModel classModel = new ClassModel();
classModel.programId = programIdRegular2;
classModel.staffId = staffIdBeth;
classModel.classDate = DateTime.Now.AddDays((i * 7) + 1);
classModel.startTime = TimeSpan.Parse("13:00");
classModel.endTime = TimeSpan.Parse("15:00");
classTable.create(classModel);
}
//advanced classes
for (var i = 0; i <= 7; i++)
{
ClassModel classModel = new ClassModel();
classModel.programId = programIdAdvanced1;
classModel.staffId = staffIdBeth;
classModel.classDate = DateTime.Now.AddDays((i * 7) + 50);
classModel.startTime = TimeSpan.Parse("16:00");
classModel.endTime = TimeSpan.Parse("18:00");
classTable.create(classModel);
}
}
public void ReadAll_Create3Records_CountIs3()
{
//Assemble
ClassModel classModel1 = new ClassModel();
classModel1.programId = programId;
classModel1.staffId = staffId;
classModel1.classDate = new DateTime(2021, 10, 01);
classModel1.startTime = new TimeSpan(2, 31, 0);
classModel1.endTime = new TimeSpan(3, 31, 0);
ClassModel classModel2 = new ClassModel();
classModel2.programId = programId;
classModel2.staffId = staffId;
classModel2.classDate = new DateTime(2021, 10, 02);
classModel2.startTime = new TimeSpan(2, 32, 0);
classModel2.endTime = new TimeSpan(3, 32, 0);
ClassModel classModel3 = new ClassModel();
classModel3.programId = programId;
classModel3.staffId = staffId;
classModel3.classDate = new DateTime(2021, 10, 03);
classModel3.startTime = new TimeSpan(2, 33, 0);
classModel3.endTime = new TimeSpan(3, 33, 0);
ClassTable classTable = new ClassTable();
int expected = 3;
//Act
int classID1 = classTable.create(classModel1);
int classID2 = classTable.create(classModel2);
int classID3 = classTable.create(classModel3);
List <ClassModel> actual = classTable.readAll();
//Assert
Assert.AreEqual(expected, actual.Count);
}
public void Count_Created1Record_1()
{
//Assemble
ClassModel classModel = new ClassModel();
classModel.programId = programId;
classModel.staffId = staffId;
classModel.classDate = new DateTime(2021, 10, 05);
classModel.startTime = new TimeSpan(2, 32, 0);
classModel.endTime = new TimeSpan(3, 32, 0);
int expected = 1;
ClassTable classTable = new ClassTable();
//Act
int classID = classTable.create(classModel);
int actual = classTable.count();
//Assert
Assert.AreEqual(expected, actual);
}
public void Create_ValidData_ClassIDReturned()
{
//Assemble
ClassModel classModel = new ClassModel();
classModel.programId = programId;
classModel.staffId = staffId;
classModel.classDate = new DateTime(2021, 10, 01);
classModel.startTime = new TimeSpan(2, 31, 0);
classModel.endTime = new TimeSpan(2, 32, 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;
ClassTable classTable = new ClassTable();
//Act
int actual = classTable.create(classModel);
//Assert
Assert.AreNotEqual(notCreated, actual);
}
public void Delete_CreatedDeleteAndCount1Record_0()
{
//Assemble
ClassModel classModel = new ClassModel();
classModel.programId = programId;
classModel.staffId = staffId;
classModel.classDate = new DateTime(2021, 01, 03);
classModel.startTime = new TimeSpan(2, 33, 0);
classModel.endTime = new TimeSpan(3, 33, 0);
int expected = 0;
ClassTable classTable = new ClassTable();
int classID = classTable.create(classModel);
//Act
classTable.delete(classID);
int actual = classTable.count();
//Assert
Assert.AreEqual(expected, actual);
}