public bool InitializeUser(out string error) { ArchivedOrdersViewModel.InitializeUser(); ListOfOrders.Clear(); IList <Order> activeOrdersList; try { activeOrdersList = WaiterClientModel.GetActiveOrders(); } catch { error = "Failed with getting orders!"; return(false); } foreach (var o in activeOrdersList) { ListOfOrders.Add(o); } error = ""; return(true); }
private void Awake() { if (instance == null) { instance = this; } extraIngredientsToSpawn = 0; }
public List <ListOfOrders> GetOrdersByStatus(string status) { List <ListOfOrders> orders = new List <ListOfOrders>(); ListOfOrders newOrder; string sqlStatement = String.Join(" ", new string[] { "select order_id, customer_id, status, salesman_id,order_date from gerson.orders where status = :status" }); using (OracleConnection conn = new OracleConnection(Settings.ConnectionString)) { using (OracleCommand cmd = new OracleCommand()) { conn.Open(); cmd.Connection = conn; cmd.BindByName = true; cmd.CommandText = sqlStatement; cmd.Parameters.Add(new OracleParameter("status", OracleDbType.NVarchar2)); // Gotcha #3 - see how the parameter name decoration (:) has been dropped // Gotcha #4 - the table definition is NUMBER(10,0) // but there is no Number in the OracleDbType enumeration. // You have to figure out what native .Net data type will fit the data without loss cmd.Parameters[0].Value = status; using (OracleDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { newOrder = new ListOfOrders(); newOrder.Order_Id = Convert.ToInt16(reader["Order_Id"]); orders.Add(newOrder); } } conn.Close(); conn.Dispose(); } return(orders); } }
public bool RealizeOrder(out string error) { if (SelectedOrder == null) { error = "No Order Is Selected"; return(false); } if (WaiterClientModel.RealizeOrder(SelectedOrder.Id)) { SelectedOrder.State = OrderState.Realized; ArchivedOrdersViewModel.AddArchivedOrder(SelectedOrder); ListOfOrders.Remove(SelectedOrder); error = ""; return(true); } error = "Failed"; return(false); }
public ActionResult Index() { ListOfOrders resultList = new ListOfOrders(); List <Order> listOfOrders = new List <Order>(); string chosenTable = (string)TempData["ChosenTable"]; switch (chosenTable) { case "all": case "empty": if (Session["ListOfOrders"] != null) { listOfOrders = (List <Order>)Session["ListOfOrders"]; resultList.OrdersList = listOfOrders; } if (!listOfOrders.Any()) { TempData["error"] = "Brak zamówień dla tego stolika"; } TempData["ChosenTable"] = chosenTable; return(View(resultList)); case "billpaid": if (Session["ListOfOrders"] != null) { listOfOrders = ((List <Order>)Session["ListOfOrders"]).FindAll(x => x.Status.Equals(Order.OrderStatus.BillPaid)); resultList.OrdersList = listOfOrders; } if (!listOfOrders.Any()) { TempData["error"] = "Brak zamówień dla tego stolika"; } TempData["ChosenTable"] = chosenTable; return(View(resultList)); case "pendingpayment": if (Session["ListOfOrders"] != null) { listOfOrders = ((List <Order>)Session["ListOfOrders"]).FindAll(x => x.Status.Equals(Order.OrderStatus.PendingPayment)); resultList.OrdersList = listOfOrders; } if (!listOfOrders.Any()) { TempData["error"] = "Brak zamówień dla tego stolika"; } TempData["ChosenTable"] = chosenTable; return(View(resultList)); case "1": case "2": case "3": case "4": case "5": if (Session["ListOfOrders"] != null) { listOfOrders = ((List <Order>)Session["ListOfOrders"]).FindAll(x => x.TableNumber == Int32.Parse(chosenTable)); resultList.OrdersList = listOfOrders; } if (!listOfOrders.Any()) { TempData["error"] = "Brak zamówień dla tego stolika"; } TempData["ChosenTable"] = chosenTable; return(View(resultList)); default: return(View(resultList)); } }