public void GetTByExpression()
{
Expression<Func<Customer, bool>> expression = e => e.ID == 1;
var customer = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(true);
var provider = new IProvider();
var command = new ICommand();
var schema = new TypeTable(typeof(Customer));
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandBuilder.Setup(c => c.CreateGetTCommand<Customer>(expression)).Returns(command.Object);
provider.CommandExecutor.Setup(c => c.ExecuteReader(command.Object)).Returns(reader.Object);
provider.Mapper.Setup(m => m.GetTMappingMethod<Customer>()).Returns(d => customer);
var target = new DataSession(provider.Object);
var actual = target.GetT(expression);
Assert.AreEqual(actual, customer);
}
private static void GetPagedListByPageEnumExpression(int pageSize, Data.Page page, Expression<Func<Customer, bool>> expression)
{
var customer1 = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var customer2 = new Customer
{
ID = 2,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 2,
Name = "Customer2",
ProfileID = 2
};
var customer3 = new Customer
{
ID = 3,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 3,
Name = "Customer3",
ProfileID = 3
};
var customerQueue = new Queue<Customer>(new[] { customer1, customer2, customer3 });
var readerResults = new Queue<bool>(new[] { true, true, true, false });
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(readerResults.Dequeue);
var provider = new IProvider();
var command = new ICommand();
var schema = new TypeTable(typeof(Customer));
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandBuilder.Setup(c => c.CreateGetListByPageCommand<Customer>(expression)).Returns(command.Object);
provider.CommandBuilder.Setup(c => c.CreateCountCommand<Customer>(expression)).Returns(command.Object);
provider.CommandExecutor.Setup(c => c.ExecuteCount(command.Object)).Returns(3);
provider.CommandExecutor.Setup(c => c.ExecuteReader(command.Object)).Returns(reader.Object);
provider.Mapper.Setup(m => m.GetTMappingMethod<Customer>()).Returns(d => customerQueue.Dequeue());
var target = new DataSession(provider.Object);
try
{
var actual = target.GetPagedList<List<Customer>, Customer>(pageSize, page, expression);
Assert.IsTrue(actual[0].ID == 1 &&
actual[1].ID == 2 && actual[2].ID == 3);
}
catch (Exception ex)
{
Assert.IsTrue(ex is ArgumentNullException);
}
}
public void GetPagedListByExpression()
{
Expression<Func<Customer, bool>> expression = e => e.ID < 4;
var customer1 = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var customer2 = new Customer
{
ID = 2,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 2,
Name = "Customer2",
ProfileID = 2
};
var customer3 = new Customer
{
ID = 3,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 3,
Name = "Customer3",
ProfileID = 3
};
var customerQueue = new Queue<Customer>(new[] { customer1, customer2, customer3 });
var readerResults = new Queue<bool>(new[] { true, true, true, false });
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(readerResults.Dequeue);
var provider = new IProvider();
var command = new ICommand();
var schema = new TypeTable(typeof(Customer));
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandBuilder.Setup(c => c.CreateGetListByPageCommand<Customer>(expression)).Returns(command.Object);
provider.CommandExecutor.Setup(c => c.ExecuteReader(command.Object)).Returns(reader.Object);
provider.Mapper.Setup(m => m.GetTMappingMethod<Customer>()).Returns(d => customerQueue.Dequeue());
var target = new DataSession(provider.Object);
var actual = target.GetPagedList<List<Customer>, Customer>(10, 1, expression);
Assert.IsTrue(actual[0].ID == 1 &&
actual[1].ID == 2 && actual[2].ID == 3);
}
public void GetTByProcedure()
{
var procedure = new Mock<Procedure>("TestProcedure");
var customer = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(true);
var provider = new IProvider();
var command = new ICommand();
var schema = new TypeTable(typeof(Customer));
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandBuilder.Setup(c => c.CreateCommandFromProcedure(procedure.Object)).Returns(command.Object);
provider.CommandExecutor.Setup(c => c.ExecuteReader(command.Object)).Returns(reader.Object);
provider.Mapper.Setup(m => m.GetTMappingMethod<Customer>()).Returns(d => customer);
var target = new DataSession(provider.Object);
var actual = target.GetT<Customer>(procedure.Object);
Assert.AreEqual(actual, customer);
}
public void SaveUpdateThrowsUnableToCreateCommandException()
{
var customer = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var provider = new IProvider();
var transaction = new Mock<ITransaction>();
var schema = new TypeTable(typeof(Customer));
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(true);
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandExecutor.Setup(c => c.InitiateTransaction()).Returns(transaction.Object);
provider.Setup(p => p.GetEntityStatus(customer)).Returns(EntityStatus.Update);
provider.CommandBuilder.Setup(c => c.CreateUpdateCommand(customer)).Returns(default(Data.ICommand));
try
{
var target = new DataSession(provider.Object);
target.Save(customer);
}
catch (Exception ex)
{
Assert.IsTrue(ex is UnableToCreateCommandException);
}
}
public void SaveUpdate()
{
var customer = new Customer
{
ID = 1,
Balance = 0,
BalanceRate = 0,
DefaultContactID = 1,
Name = "Customer1",
ProfileID = 1
};
var provider = new IProvider();
var transaction = new Mock<ITransaction>();
var command = new ICommand();
var schema = new TypeTable(typeof(Customer));
var reader = new DbDataReader();
reader.Setup(r => r.Read()).Returns(true);
provider.Setup(p => p.GetSchema(typeof(Customer))).Returns(schema);
provider.CommandExecutor.Setup(c => c.InitiateTransaction()).Returns(transaction.Object);
provider.Setup(p => p.GetEntityStatus(customer)).Returns(EntityStatus.Update);
provider.CommandBuilder.Setup(c => c.CreateUpdateCommand(customer)).Returns(command.Object);
provider.CommandExecutor.Setup(c => c.ExecuteReader(command.Object, transaction.Object)).Returns(
reader.Object);
provider.Mapper.Setup(m => m.GetObjectMappingMethod(typeof(Customer))).Returns(d => customer);
var target = new DataSession(provider.Object);
target.Save(customer);
provider.CommandExecutor.Verify(c => c.InitiateTransaction());
provider.CommandExecutor.Verify(c => c.CommitTransaction(transaction.Object));
Assert.IsTrue(customer.ID == 1);
}