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