public TestConfig()
{
Prop1 = "Initial";
Prop2 = 1.0;
Prop3 = 2;
Prop4 = new List<String>() { "A", "B", "C" };
TestOrder = Order.THIRD;
}
public void TestCreateOrder()
{
var order = new Order();
order.TotalPrice = (decimal)98.5;
order.Lines = new[] {
new OrderDetail{Product = "P1", Amount = 2},
new OrderDetail{Product = "P2", Amount = 3}
};
var orderService = new OrderService();
orderService.CreateOrder(order);
}
public void CreateOrder(Order order)
{
if (order == null)
throw new ArgumentNullException("order");
if (!order.Lines.Any())
throw new ArgumentException("order.Lines");
order.OrderId = NewOrderId();
order.Status = "newcreated";
order.CreatedTime = DateTime.Now;
DatabaseFactory.CreateDatabase("mall").ExecuteTransaction(db => {
var orderRepo = new OrderRepo(db);
orderRepo.Save(order);
var orderLineRepo = new OrderLineRepo(db);
foreach (var orderLine in order.Lines)
orderLineRepo.Save(order.OrderId, orderLine);
});
}
public void Save(Order order)
{
var sql = @"insert into [Order](OrderId, Status, CreatedTime, TotalPrice) values(@OrderId, @Status, @CreatedTime, @TotalPrice)";
_Database.ExecuteNonQuery(sql, new {order.OrderId, order.Status, order.CreatedTime, order.TotalPrice});
}
public void TestInsertOrderWithNoResult()
{
this.TestInsertCustomerNoResult(); // create customer "XX1"
var order = new Order
{
CustomerID = "XX1",
OrderDate = DateTime.Today,
};
var result = db.Orders.Insert(order);
Assert.Equal(1, result);
}
public void TestCompareTwoConstantEntityNestedRelationshipNegation()
{
Order exclude = new Order() { OrderID = 10702 };
Customer alfki = new Customer() { CustomerID = "ALFKI" };
var testQuery = from o in db.Orders
where o.Customer == alfki &&
o != exclude
select o;
var test = testQuery.ToList();
AssertValue(5, test.Count);
AssertValue("ALFKI", test[0].CustomerID);
}
public void TestCompareConstantEntityNestedRelationshipNegation()
{
var exclude = new Order() { OrderID = 10702 };
var testQuery = from c in db.Customers
from o in c.Orders
from d in o.Details
where o != exclude
select d;
var test = testQuery.ToList();
AssertValue(2153, test.Count);
}
public void TestInsertOrderWithGeneratedIDResult()
{
this.TestInsertCustomerNoResult(); // create customer "XX1"
var order = new Order
{
CustomerID = "XX1",
OrderDate = DateTime.Today,
};
var result = db.Orders.Insert(order, o => o.OrderID);
this.AssertNotValue(1, result);
}