public void Mark(int id,OrderStatus os) { _dataAccess.NonQuery("Update Orders SET [Status]="+((int)os).ToString()+" WHERE OrdersID="+id); }
public List<Orders> GetAllOrders(OrderStatus ods) { return EntityHelper<Orders>.ConvertToList(_dataAccess.Query("SELECT * FROM Orders WHERE [Status]="+(int)ods +" ORDER BY [OrderDate] DESC")); }