public void TestSqlConnectionNumbersNullCrudAsync()
{
// Setup
var entity = new NumbersClass
{
SessionId = Guid.NewGuid(),
ColumnBigInt = null,
ColumnBit = null,
ColumnDecimal = null,
ColumnFloat = null,
ColumnInt = null,
ColumnMoney = null,
ColumnNumeric = null,
ColumnReal = null,
ColumnSmallInt = null,
ColumnSmallMoney = null
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = connection.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = connection.QueryAsync <NumbersClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnBigInt);
Assert.IsNull(data.ColumnBit);
Assert.IsNull(data.ColumnDecimal);
Assert.IsNull(data.ColumnFloat);
Assert.IsNull(data.ColumnInt);
Assert.IsNull(data.ColumnMoney);
Assert.IsNull(data.ColumnNumeric);
Assert.IsNull(data.ColumnReal);
Assert.IsNull(data.ColumnSmallInt);
Assert.IsNull(data.ColumnSmallMoney);
}
}
public void TestDbRepositoryNumbersCrudAsync()
{
// Setup
var entity = new NumbersClass
{
SessionId = Guid.NewGuid(),
ColumnBigInt = 12345,
ColumnBit = true,
ColumnDecimal = 12345,
ColumnFloat = (float)12345.12,
ColumnInt = 12345,
ColumnMoney = (decimal)12345.12,
ColumnNumeric = 12345,
ColumnReal = (float)12345.12,
ColumnSmallInt = 12345,
ColumnSmallMoney = 12345
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync <NumbersClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnBigInt, data.ColumnBigInt);
Assert.AreEqual(entity.ColumnBit, data.ColumnBit);
Assert.AreEqual(entity.ColumnDecimal, data.ColumnDecimal);
Assert.AreEqual(entity.ColumnFloat, data.ColumnFloat);
Assert.AreEqual(entity.ColumnInt, data.ColumnInt);
Assert.AreEqual(entity.ColumnMoney, data.ColumnMoney);
Assert.AreEqual(entity.ColumnNumeric, data.ColumnNumeric);
Assert.AreEqual(entity.ColumnReal, data.ColumnReal);
Assert.AreEqual(entity.ColumnSmallInt, data.ColumnSmallInt);
Assert.AreEqual(entity.ColumnSmallMoney, data.ColumnSmallMoney);
}
}
public void TestSqlConnectionNumbersCrud()
{
// Setup
var entity = new NumbersClass
{
SessionId = Guid.NewGuid(),
ColumnBigInt = 12345,
ColumnBit = true,
ColumnDecimal = 12345,
ColumnFloat = (float)12345.12,
ColumnInt = 12345,
ColumnMoney = (decimal)12345.12,
ColumnNumeric = 12345,
ColumnReal = (float)12345.12,
ColumnSmallInt = 12345,
ColumnSmallMoney = 12345
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Act Query
var data = connection.Query <NumbersClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnBigInt, data.ColumnBigInt);
Assert.AreEqual(entity.ColumnBit, data.ColumnBit);
Assert.AreEqual(entity.ColumnDecimal, data.ColumnDecimal);
Assert.AreEqual(entity.ColumnFloat, data.ColumnFloat);
Assert.AreEqual(entity.ColumnInt, data.ColumnInt);
Assert.AreEqual(entity.ColumnMoney, data.ColumnMoney);
Assert.AreEqual(entity.ColumnNumeric, data.ColumnNumeric);
Assert.AreEqual(entity.ColumnReal, data.ColumnReal);
Assert.AreEqual(entity.ColumnSmallInt, data.ColumnSmallInt);
Assert.AreEqual(entity.ColumnSmallMoney, data.ColumnSmallMoney);
}
}
public void TestDbRepositoryNumbersNullCrud()
{
// Setup
var entity = new NumbersClass
{
SessionId = Guid.NewGuid(),
ColumnBigInt = null,
ColumnBit = null,
ColumnDecimal = null,
ColumnFloat = null,
ColumnInt = null,
ColumnMoney = null,
ColumnNumeric = null,
ColumnReal = null,
ColumnSmallInt = null,
ColumnSmallMoney = null
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query <NumbersClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnBigInt);
Assert.IsNull(data.ColumnBit);
Assert.IsNull(data.ColumnDecimal);
Assert.IsNull(data.ColumnFloat);
Assert.IsNull(data.ColumnInt);
Assert.IsNull(data.ColumnMoney);
Assert.IsNull(data.ColumnNumeric);
Assert.IsNull(data.ColumnReal);
Assert.IsNull(data.ColumnSmallInt);
Assert.IsNull(data.ColumnSmallInt);
}
}
public void IsDivisible_WhenBy4or6_ReturnTrue(int num)
{
var test = NumbersClass.IsDivisibleBy4or6(num);
Assert.True(test);
}
public void IsDivisible_WhenNOTBy4or6_ReturnFalse(int num)
{
var test = NumbersClass.IsDivisibleBy4or6(num);
Assert.False(test);
}
public void PythagoreanTheorem_WhenValuesAreCorrect_ReturnCorrectValues(int a, int b, double result)
{
var test = NumbersClass.PythagoreanTheorem(a, b);
Assert.Equal(result, test);
}
public void FloorValue_WhenValueIsFloorable_ReturnCorrectValue(decimal num, int result)
{
var test = NumbersClass.FloorValue(num);
Assert.Equal(result, test);
}
public void Difference_WhenValuesAreDifferent_ReturnDifference(int num1, int num2, int expected)
{
var test = NumbersClass.Difference(num1, num2);
Assert.Equal(expected, test);
}
public void Difference_WhenValuesPresentANegative_ReturnPositive(int num1, int num2)
{
var test = NumbersClass.Difference(num1, num2);
Assert.True(test > 0);
}
public void MultiplyBy10_WhenAble_ReturnCorrectValue(int num, int expected)
{
var test = NumbersClass.MultiplyBy10(num);
Assert.Equal(expected, test);
}
