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));
}
}
