public void Bug()
{
using (ISession s = OpenSession())
{
Customer c = new Customer();
c.Name = "TestCustomer";
s.Save(c);
Article art = new Article();
art.Name = "TheArticle1";
art.Price = 10.5M;
s.Save(art);
Order o = c.CreateNewOrder();
OrderLine ol = o.CreateNewOrderLine();
ol.SetArticle(art);
ol.NumberOfItems = 5;
o.AddOrderLine(ol);
s.Save(o);
s.Flush();
}
using (ISession s = OpenSession())
{
string hql = "select sum (ol.ArticlePrice * ol.NumberOfItems) " +
"from Order o, OrderLine ol, Customer c " +
"where c.Id = :custId and o.OrderDate >= :orderDate";
IQuery q = s.CreateQuery(hql);
q.SetInt32("custId", 1);
q.SetDateTime("orderDate", DateTime.Now.AddMonths(-3));
Assert.AreEqual(52.5m, (decimal) q.UniqueResult());
}
using (ISession s = OpenSession())
{
Order o = (Order) s.CreateQuery("from Order").UniqueResult();
OrderLine ol = (OrderLine) o.OrderLines[0];
s.Delete(ol);
o.OrderLines.RemoveAt(0);
s.Delete(o);
s.Delete(o.OwningCustomer);
s.Delete("from Article");
s.Flush();
}
}
public Order(int id, DateTime orderDate, Customer owningCustomer)
{
_id = id;
_orderDate = orderDate;
_owningCustomer = owningCustomer;
}
internal Order(Customer owningCustomer)
: this(-1, DateTime.Now, owningCustomer)
{
}