public void SqlReaderToModelBuilder_ValidSqlReader_ReturnCorrectTIcketModel()
{
//Arrange
var expected = RandomizerHelper.GetNewRandomTicket();
mockDataReader.Setup(x => x.GetInt32(0)).Returns(expected.Id);
mockDataReader.Setup(x => x.GetInt32(1)).Returns(expected.EventId);
mockDataReader.Setup(x => x.GetBoolean(2)).Returns(expected.IsUsed);
mockDataReader.Setup(x => x.GetInt32(3)).Returns(expected.StudentId);
//Act
var actual = SqlHelper.SqlReaderToModelBuilder <Ticket>(mockDataReader.Object);
//Assert
AssertTicketAreEqual(expected, actual);
}
public void ModelToSqlCommandBuilder_ValidArguments_ReturnVaidSqlCommandForTicket()
{
//Arrange
var model = RandomizerHelper.GetNewRandomTicket();
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
var expected = new SqlCommand(query, sqlConnection);
expected.Parameters.Add("@Id", SqlDbType.Int).Value = model.Id;
expected.Parameters.Add("@EventId", SqlDbType.Int).Value = model.EventId;
expected.Parameters.Add("@IsUsed", SqlDbType.Bit).Value = model.IsUsed;
expected.Parameters.Add("@StudentId", SqlDbType.Int).Value = model.StudentId;
expected.Parameters.Add("@StudentId", SqlDbType.Int).Value = model.StudentId;
//Act
var actual = SqlHelper.ModelToSqlCommandBuilder <Ticket>(model, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}