public void IdToSqlCommandBuilder_IdIsNegative_ThrowArgumentNullException()
{
//Arrange
var id = RandomizerHelper.GetRandomNegativeInt();
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
//Act + Assert
Assert.Throws <ArgumentNullException>(() => SqlHelper.IdToSqlCommandBuilder(id, query, sqlConnection));
}
public void ModelToSqlCommandBuilder_SqlConnectionIsNull_ThrowArgumentIsNullException()
{
//Arrange
var model = RandomizerHelper.GetNewRandomEvent();
var query = RandomizerHelper.GetRandomString();
SqlConnection sqlConnection = null;
//Act + Assert
Assert.Throws <ArgumentNullException>(() => SqlHelper.ModelToSqlCommandBuilder <Event>(model, query, sqlConnection));
}
public void ModelToSqlCommandBuilder_TicketModelIsNull_ThrowArgumentIsNullException()
{
//Arrange
var model = default(Ticket);
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
//Act + Assert
Assert.Throws <ArgumentNullException>(() => SqlHelper.ModelToSqlCommandBuilder <Ticket>(model, query, sqlConnection));
}
public void IdToSqlCommandBuilder_ValidArguments_ReturnValidSqlCommand()
{
//Arrange
var id = RandomizerHelper.GetRandomInt();
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
var expected = new SqlCommand(query);
expected.Parameters.Add("@Id", SqlDbType.Int).Value = id;
//Act
var actual = SqlHelper.IdToSqlCommandBuilder(id, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}
public void ModelToSqlCommandBuilder_StudentPropertiesDefaultValues_ReturnSqlCommandWithDefaultValues()
{
//Arrange
var model = new Student();
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
var expected = new SqlCommand(query, sqlConnection);
expected.Parameters.Add("@Id", SqlDbType.Int).Value = default(int);
expected.Parameters.Add("@Email", SqlDbType.NVarChar).Value = default(string);
//Act
var actual = SqlHelper.ModelToSqlCommandBuilder <Student>(model, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}
public void ModelToSqlCommandBuilder_ValidArguments_ReturnVaidSqlCommandForStudent()
{
//Arrange
var model = RandomizerHelper.GetNewRandomStudent();
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("@Email", SqlDbType.NVarChar).Value = model.Email;
//Act
var actual = SqlHelper.ModelToSqlCommandBuilder <Student>(model, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}
public void ModelToSqlCommandBuilder_EventPropertiesAreDefaultValues_ReturnSqlCommandWithDefaultValues()
{
//Arrange
var model = new Event();
var query = RandomizerHelper.GetRandomString();
var sqlConnection = new SqlConnection();
var expected = new SqlCommand(query, sqlConnection);
expected.Parameters.Add("@Id", SqlDbType.Int).Value = default(int);
expected.Parameters.Add("@Name", SqlDbType.NVarChar).Value = default(string);
expected.Parameters.Add("@Description", SqlDbType.NVarChar).Value = default(string);
expected.Parameters.Add("@Price", SqlDbType.Decimal).Value = default(decimal);
expected.Parameters.Add("@StudentPrice", SqlDbType.Decimal).Value = default(decimal);
expected.Parameters.Add("@Date", SqlDbType.DateTime).Value = default(DateTime);
expected.Parameters.Add("@Place", SqlDbType.NVarChar).Value = default(string);
//Act
var actual = SqlHelper.ModelToSqlCommandBuilder <Event>(model, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}
public void ModelToSqlCommandBuilder_ValidArguments_ReturnVaidSqlCommandForEvent()
{
//Arrange
var model = RandomizerHelper.GetNewRandomEvent();
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("@Name", SqlDbType.NVarChar).Value = model.Name;
expected.Parameters.Add("@Description", SqlDbType.NVarChar).Value = model.Description;
expected.Parameters.Add("@Price", SqlDbType.Decimal).Value = model.Price;
expected.Parameters.Add("@StudentPrice", SqlDbType.Decimal).Value = model.StudentPrice;
expected.Parameters.Add("@Date", SqlDbType.DateTime).Value = model.Date;
expected.Parameters.Add("@Place", SqlDbType.NVarChar).Value = model.Place;
//Act
var actual = SqlHelper.ModelToSqlCommandBuilder <Event>(model, query, sqlConnection);
//Assert
AssertSqlCommandAreEqual(expected, actual);
}