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 void SetArticle(Article art)
{
if (art != null)
{
//_isArticleSet = true;
_articleId = art.Id;
_articleName = art.Name;
_articlePrice = art.Price;
}
else
{
//_isArticleSet = false;
_articleId = -1;
_articleName = string.Empty;
_articlePrice = 0.0M;
}
}