C# (CSharp) DataLayer OrderStatus Examples

Example #1

File: OrdersBUS.cs Project: phamxuanlu/MVC4-MobileStoreWeb

 public void Mark(int id,OrderStatus os)
 {
     _dataAccess.NonQuery("Update Orders SET [Status]="+((int)os).ToString()+" WHERE OrdersID="+id);
 }

Example #2

File: OrdersBUS.cs Project: phamxuanlu/MVC4-MobileStoreWeb

 public List<Orders> GetAllOrders(OrderStatus ods)
 {
     return EntityHelper<Orders>.ConvertToList(_dataAccess.Query("SELECT * FROM Orders WHERE [Status]="+(int)ods +" ORDER BY [OrderDate] DESC"));
 }