public void OrderGetByPersonId()
{
DataBase dataBase = new DataBase();
const int personInfoId = 5;
int rowsInserted = dataBase.OrderInsert(new Order
{
ItemId = 1,
Count = 2,
ItemStatusId = 3,
LegalEntity = true,
PersonInfoId = 4,
Postage = 5M.DecimalToString(),
Price = 6.00M.DecimalToString(),
});
Assert.AreEqual(1, rowsInserted);
rowsInserted = dataBase.OrderInsert(new Order
{
ItemId = 10,
Count = 20,
ItemStatusId = 3,
LegalEntity = false,
PersonInfoId = personInfoId,
Postage = 10M.DecimalToString(),
Price = 2.99M.DecimalToString(),
});
Assert.AreEqual(1, rowsInserted);
const decimal price = 7.123M;
rowsInserted = dataBase.OrderInsert(new Order
{
ItemId = 2,
Count = 3,
ItemStatusId = 4,
LegalEntity = false,
PersonInfoId = personInfoId,
Postage = 6M.DecimalToString(),
Price = price.DecimalToString(),
});
Assert.AreEqual(1, rowsInserted);
List<Order> orders = dataBase.OrderGetByPersonInfo(personInfoId);
Assert.IsNotNull(orders);
orders = dataBase.OrderGetByItemStatus(4);
Assert.IsNotNull(orders);
Order findLast = orders.FindLast(o => o.Price == price.DecimalToString());
Assert.IsNotNull(findLast);
Assert.AreEqual(price.DecimalToString(), findLast.Price);
}
