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