static public long saveOrder(TOrderBiz order)
{
TOrderData ob = new TOrderData();
ob.Configure();
TOrder od = ob.CreateOrder(order.Name, order.Address, order.Phone, order.AddText, order.OrderTypeID);
od.UserName = order.UserName;
foreach (TOrderItemBiz item in order.Items)
{
TOrderItem oditem = new TOrderItem();
oditem.Order = od;
oditem.Price = item.Price;
oditem.Amount = item.Amount;
oditem.SubPrice = item.SubPrice;
oditem.Text = item.Text;
oditem.DishId = item.DishId;
oditem.DishName = item.DishName;
od.Items.Add(oditem);
}
ob.UpdateOrder(od);
return(od.Id);
}
public void saveOrder()
{
ISessionFactory _sessions;
Configuration cfg = new Configuration().Configure();
_sessions = cfg.BuildSessionFactory();
TOrderData ob = new TOrderData();
ob.Configure();
TOrder od = ob.CreateOrder("test", "order.Address", "order.Phone", "order.AddText", 1);
//od.Id = order.Id;
//od.Name = order.Name;
//od.OrderTime = order.OrderTime;
//od.Phone = order.Phone;
//od.Address = order.Address;
//od.AddText = order.AddText;
using (ISession session = _sessions.OpenSession())
using (ITransaction tx = session.BeginTransaction())
{
od = session.Load <TOrder>(od.Id);
for (int i = 0; i < 8; i++)
{
TOrderItem oditem = new TOrderItem();
oditem.Order = od;
oditem.Price = 9.99M;
oditem.Amount = 2;
oditem.SubPrice = 19.99M;
oditem.Text = "test" + od.Id;
oditem.DishId = 1;
oditem.DishName = "test" + i;
//oditem.Id = -1;
od.Items.Add(oditem);
}
session.Flush();
tx.Commit();
}
}
public long saveOrder1()
{
ISessionFactory _sessions;
Configuration cfg = new Configuration().Configure();
_sessions = cfg.BuildSessionFactory();
TOrderData ob = new TOrderData();
ob.Configure();
TOrder od = ob.CreateOrder("test", "order.Address", "order.Phone", "order.AddText", 1);
//od.Id = order.Id;
//od.Name = order.Name;
//od.OrderTime = order.OrderTime;
//od.Phone = order.Phone;
//od.Address = order.Address;
//od.AddText = order.AddText;
for (int i = 0; i < 8; i++)
{
TOrderItem oditem = new TOrderItem();
oditem.Order = od;
oditem.Price = 9.99M;
oditem.Amount = 2;
oditem.SubPrice = 19.99M;
oditem.Text = "testb" + od.Id;
oditem.DishId = 1;
oditem.DishName = "testb" + i;
od.Items.Add(oditem);
}
ob.UpdateOrder(od);
return(od.Id);
}
TOrder ModelToTransporter(ShopModel.Order order)
{
TOrder torder = new TOrder {
orderid = order.Order_Id,
date = order.Date,
price = order.Price,
userid = order.User_Id,
isDelivered = order.IsDelivered
};
foreach (ShopModel.Order_Item item in order.Order_Item)
{
TOrderItem titem = new TOrderItem
{
itemid = item.Item_Id,
productid = item.Product_Id,
quantity = item.Quantity,
price = item.Price
};
torder.items.Add(titem);
}
return(torder);
}
static public void getOrderAndItems(long orderId, DataTable dtOrder)
{
TOrderData ob = new TOrderData();
ob.Configure();
TOrder order = ob.GetOrderAndAllItems(orderId);
dtOrder.Rows.Clear();
if (order != null)
{
for (int i = 0; i < order.Items.Count; i++)
{
TOrderItem item = (TOrderItem)order.Items[i];
dtOrder.Rows.Add();
dtOrder.Rows[i][0] = item.DishId;
dtOrder.Rows[i][1] = item.DishName;
dtOrder.Rows[i][2] = Convert.ToInt32(item.Amount);
dtOrder.Rows[i][3] = item.SubPrice.ToString();
dtOrder.Rows[i][4] = item.Price.ToString();
}
}
}
