public bool ApproveOrder(int orderid)
{
EntityLayer.Order query = (from order in mycontext.Orders
where order.OrderID == orderid
select order).SingleOrDefault();
query.Status = "inactive";
mycontext.Entry(query).State = System.Data.Entity.EntityState.Modified;
int result = mycontext.SaveChanges();
return(result > 0);
}
public void AddOrder(List <EntityLayer.OrderItem> oi, int docid)
{
EntityLayer.Order ord = new EntityLayer.Order();
ord.OrderDate = DateTime.Now;
ord.Status = "active";
ord.UserID = docid;
foreach (var item in oi)
{
ord.OrderItems.Add(item);
}
mycontext.Orders.Add(ord);
int ret = mycontext.SaveChanges();
}