private void AddFoodOrderToBill(object sender, ExternalDataEventArgs e)
{
CRySTAL.FoodOrder order = (e as WorkflowLocalService.FoodOrderEventArgs).Order;
CRySTALDataConnections.CRySTALDataSetTableAdapters.BillItemsTableAdapter bia = new CRySTALDataConnections.CRySTALDataSetTableAdapters.BillItemsTableAdapter();
CRySTAL.CrystalMenuDataContext db = new CRySTAL.CrystalMenuDataContext();
foreach (CRySTAL.ItemOrder item in order.FoodOrders)
{
var product = from p in db.MenuItems
where p.ID == item.productID
select p;
if (product.Count() > 0)
{
bia.InsertBillItem(e.InstanceId, product.First().Name, (decimal)product.First().Price, item.DeleverToPerson);
}
}
}
