//Method that is called when a table is clicked
private void Table_Click(object sender, EventArgs e)
{
Button button = (Button)sender;
DiningTable table = (DiningTable)button.Tag;
switch (table.Status)
{
case TableStatus.Free:
//Brings waiter to the table view
OrderForm orderForm = new OrderForm(LoggedInEmployee, loginForm, this, table);
orderForm.Show();
Hide();
break;
case TableStatus.Occupied:
//Will change to current order overview eventually
OrderOptionForm optionForm = new OrderOptionForm(LoggedInEmployee, loginForm, orderDB.GetCompleteActiveOrderByTable(table), this);
optionForm.Show();
Hide();
break;
case TableStatus.Reserved:
MessageBox.Show("Table is reserved has the right guest arrived?"); // Some other code
OrderForm orderForm1 = new OrderForm(LoggedInEmployee, loginForm, this, table);
orderForm1.Show();
break;
default:
throw new Exception("Incorrect table status input");
}
}
private static void DiningPhilosophers()
{
Console.WriteLine("--- Dining philosophers ---");
var table = new DiningTable();
table.Run();
}
public void SimpleSerialization()
{
var table = new DiningTable();
((dynamic)table)["@strangeVariable_NAme3"] = new TableLegFixture();
var result = Operations.Serialize(table);
var test = Operations.Deserialize(result);
Assert.AreEqual(test.GetId(), table.GetId());
var polyline = new Polyline();
for (int i = 0; i < 100; i++)
{
polyline.Points.Add(new Point()
{
X = i * 2, Y = i % 2
});
}
var strPoly = Operations.Serialize(polyline);
var dePoly = Operations.Deserialize(strPoly);
Assert.AreEqual(polyline.GetId(), dePoly.GetId());
}
public IActionResult DeleteTable(Guid id)
{
try
{
DiningTable table = LoadEntityById <DiningTable>(id);
table.Orders.ToList <FoodOrder>().ForEach(order => { order.OrderedItems.Clear(); });
table.Orders.Clear();
table.WaiterTables.Clear();
string sqlOrderedItems = $"Delete from OrderedItem where OrderId in (Select Id from FoodOrder where TableId='{id}')";
Debug.WriteLine(sqlOrderedItems);
dao.Execute(sqlOrderedItems);
string sqlOrders = $"Delete from FoodOrder where TableId='{id}'";
Debug.WriteLine(sqlOrders);
dao.Execute(sqlOrders);
string sqlWaiterTables = $"Delete from WaiterTable where TableId='{id}'";
Debug.WriteLine(sqlWaiterTables);
dao.Execute(sqlWaiterTables);
table = LoadEntityById <DiningTable>(id);
Debug.WriteLine(table.ToJson());
dao.Delete(table);
return(Ok(table));
}
catch (Exception e)
{
return(HandleDeleteException(e));
}
}
public DiningPhilosophersProblem(int nPhilosophers)
{
startCommand = new ActionCommand(StartSimulation);
table = new DiningTable(nPhilosophers);
philosophers = table.Philosophers.Select(p => new PhilospherModelView(p)).ToArray();
}
public ActionResult DeleteConfirmed(int id)
{
DiningTable diningTable = db.DiningTables.Find(id);
db.DiningTables.Remove(diningTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void Start()
{
pui = GetComponentInParent <PlayerUI>();
if (pui)
{
diningTable = pui.player.usingAsset.model.GetComponent <DiningTable>();
}
}
public void IgnoredDynamicPropertiesCheck()
{
var table = new DiningTable();
var originalHash = table.GetId();
((dynamic)table).__testProp = "wonderful";
Assert.AreEqual(originalHash, table.GetId());
}
public ActionResult Edit([Bind(Include = "TableId,Location,Size,HalfPriceDate")] DiningTable diningTable)
{
if (ModelState.IsValid)
{
db.Entry(diningTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(diningTable));
}
private FoodOrder LoadChildObjects(FoodOrder order)
{
User waiter = LoadEntityById <User>(order.Waiter.Id);
DiningTable table = LoadEntityById <DiningTable>(order.Table.Id);
order.Waiter = waiter;
order.Table = table;
return(order);
}
//NEW
//Get active Order from the database by table
public Order GetActiveOrderByTableDB(DiningTable table)
{
string query = "SELECT O.id AS OrderId, E.id AS EmpId, E.name AS EmpName, position, D.id AS TableId, status FROM [ORDER] AS O JOIN EMPLOYEE AS E ON O.handled_by = E.id JOIN DINING_TABLE AS D ON O.[table] = D.id WHERE D.id = @table AND O.id NOT IN (SELECT order_id FROM PAYMENT)";
SqlParameter[] sqlParameters = (new[]
{
new SqlParameter("@table", table.Id)
});
return(ReadTables(ExecuteSelectQuery(query, sqlParameters))[0]);
}
private void Update()
{
if (walkingToDestination) //Walking Somewhere
{
if (!agent.pathPending)
{
if (Vector3.Distance(transform.position, agent.destination) < 1f)
{
walkingToDestination = false;
if (goingHome)
{
goingHome = false;
data.isHome = true;
C.c.data.npcsOut.Remove(this);
C.c.data.npcsAtHome.Add(this);
gameObject.SetActive(false);
}
else if (dining)
{
if (diningSeat.seatTrans == null || diningSeat.npcUsing)
{
dining = false; return;
}
transform.position = diningSeat.seatTrans.position;
transform.rotation = diningSeat.seatTrans.rotation;
diningTable = diningSeat.seatTrans.GetComponentInParent <DiningTable>();
diningSeat.npcUsing = this;
anim.SetBool("Sitting", true);
}
else if (goingToShop)
{
goingToShop = false;
atShop = true;
}
}
}
}
else
{
if (dining)
{
transform.position = diningSeat.seatTrans.position;
transform.rotation = diningSeat.seatTrans.rotation;
}
if (readyToCheckout)
{
if (C.c.currentShop.npcCheckoutLine.Count > 0 && C.c.currentShop.npcCheckoutLine[0] == this)
{
OverrideLookAt(C.c.player[0].transform);
}
}
}
anim.SetFloat("Speed", agent.velocity.magnitude);
}
public void ChangeDiningTableStatus(DiningTable diningTable)
{
try
{
diningTableDB.ChangeDiningTableStatusDB(diningTable);
}
catch
{
throw new Exception("Couldn't connect to the database");
}
}
private DiningTable ReadDiningTable(DataTable dataTable)
{
DiningTable diningTable = new DiningTable();
foreach (DataRow dr in dataTable.Rows)
{
diningTable.Table_ID = (int)dr["Table_ID"];
diningTable.Table_Status = (TableStatus)((int)dr["Table_Status"]);
}
return(diningTable);
}
public ActionResult Create([Bind(Include = "TableId,Location,Size,HalfPriceDate")] DiningTable diningTable)
{
if (ModelState.IsValid)
{
db.DiningTables.Add(diningTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(diningTable));
}
public void DecompositionHashes()
{
var table = new DiningTable();
((dynamic)table)["@decomposeMePlease"] = new Point();
var hash1 = table.GetId();
var hash2 = table.GetId(true);
Assert.AreNotEqual(hash1, hash2);
}
public void HashChangeCheck()
{
var table = new DiningTable();
var secondTable = new DiningTable();
Assert.AreEqual(table.GetId(), secondTable.GetId());
((dynamic)secondTable).testProp = "wonderful";
Assert.AreNotEqual(table.GetId(), secondTable.GetId());
}
public OrderForm(Employee LoggedUser, LoginForm loginForm, TableViewForm tableView, DiningTable diningTable)
{
InitializeComponent();
//Saving the user that is logged in and passing the login form, have it's reference
LoggedInEmployee = LoggedUser;
this.loginForm = loginForm;
this.tableView = tableView;
table = diningTable;
DisplayMainCatagories();
}
public IActionResult GetTable(Guid id)
{
try
{
DiningTable table = LoadEntityById <DiningTable>(id);
return(Ok(CreateHateosLinks(table)));
}
catch (Exception e)
{
return(HandleGetException(e));
}
}
//Convert DiningTable information from the database to DiningTable objects
private List <DiningTable> ReadTables(DataTable dataTable)
{
List <DiningTable> Tables = new List <DiningTable>();
foreach (DataRow dr in dataTable.Rows)
{
DiningTable DiningTable = new DiningTable((int)dr["id"], (string)dr["status"]);
Tables.Add(DiningTable);
}
return(Tables);
}
//Change the status of a table
public void ChangeDiningTableStatusDB(DiningTable diningTable)
{
// SOME CODEE
string query = "UPDATE DINING_TABLE SET [status] = @status WHERE id = @id ";
SqlParameter[] sqlParameters = (new[]
{
new SqlParameter("@status", diningTable.Status.ToString()),//the ToString is to convert the enum to a word and store as a word not number.
new SqlParameter("@id", diningTable.Id)
});
ExecuteEditQuery(query, sqlParameters);
}
public IActionResult Post([FromBody] DiningTable table)
{
try
{
ValidateEntityNotInDatabase <DiningTable>(table);
table = dao.Save <DiningTable>(table);
return(Ok(CreateHateosLinks(table)));
}
catch (Exception e)
{
return(HandlePostException(e));
}
}
// GET: DiningTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DiningTable diningTable = db.DiningTables.Find(id);
if (diningTable == null)
{
return(HttpNotFound());
}
return(View(diningTable));
}
private void pictureTafel5_Click(object sender, EventArgs e)
{
pictureTafel1.BorderStyle = BorderStyle.None;
pictureTafel2.BorderStyle = BorderStyle.None;
pictureTafel3.BorderStyle = BorderStyle.None;
pictureTafel4.BorderStyle = BorderStyle.None;
pictureTafel5.BorderStyle = BorderStyle.Fixed3D;
pictureTafel6.BorderStyle = BorderStyle.None;
pictureTafel7.BorderStyle = BorderStyle.None;
pictureTafel8.BorderStyle = BorderStyle.None;
pictureTafel9.BorderStyle = BorderStyle.None;
pictureTafel10.BorderStyle = BorderStyle.None;
_CurrentDiningTable = _DiningTablesList[4];
EnableButtons();
}
private List <DiningTable> ReadDiningTables(DataTable dataTable)
{
List <DiningTable> diningTables = new List <DiningTable>();
foreach (DataRow dr in dataTable.Rows)
{
DiningTable diningTable = new DiningTable()
{
Table_ID = (int)dr["Table_ID"],
Table_Status = (TableStatus)((int)dr["Table_Status"])
};
diningTables.Add(diningTable);
}
return(diningTables);
}
public IActionResult ModifyTable(Guid id, [FromBody] DiningTable table)
{
try
{
ValidateIds <DiningTable>(id, table);
ValidateEntityInDatabase <DiningTable>(id);
LoadChildObjects(table);
table = dao.Merge <DiningTable>(table);
return(Ok(CreateHateosLinks(table)));
}
catch (Exception e)
{
return(HandlePutException(e));
}
}
public static void Main()
{
IDiningTableFactory victorianDiningFactory = new VictorianDiningTableFactory();
DiningTable victoriaDiningTable = new DiningTable(victorianDiningFactory);
victoriaDiningTable.AssembleTable();
Console.WriteLine(Environment.NewLine);
IDiningTableFactory modernDiningFactory = new ModernDiningTableFactory();
DiningTable modernDiningTable = new DiningTable(modernDiningFactory);
modernDiningTable.AssembleTable();
Console.ReadLine();
}
private DiningTable CreateHateosLinks(DiningTable Table)
{
var idObj = new { id = Table.Id };
Table.Links = new List <HateosLink>();
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.GetTable), idObj),
"self",
HateosLink.ACTION_GET, HateosLink.MEDIA_TYPE_APPLICATION_JSON));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.ModifyTable), idObj),
"Table",
HateosLink.ACTION_PUT, HateosLink.MEDIA_TYPE_APPLICATION_JSON));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.PartiallyModifyTable), idObj),
"Table",
HateosLink.ACTION_PATCH, HateosLink.MEDIA_TYPE_URLENCODED));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.DeleteTable), idObj),
"Table",
HateosLink.ACTION_DELETE));
Table.Links.Add(new HateosLink(this.urlHelper.Link(nameof(this.GetTable), idObj),
"self",
HateosLink.ACTION_GET, HateosLink.MEDIA_TYPE_APPLICATION_JSON));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.ModifyTable), idObj),
"self",
HateosLink.ACTION_PUT, HateosLink.MEDIA_TYPE_URLENCODED));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.PartiallyModifyTable), idObj),
"self",
HateosLink.ACTION_PATCH, HateosLink.MEDIA_TYPE_URLENCODED));
Table.Links.Add(
new HateosLink(this.urlHelper.Link(nameof(this.DeleteTable), idObj),
"self",
HateosLink.ACTION_DELETE));
return(Table);
}
// Method do determing the color of the table, fitting the table status
private Color DetermineTableColor(DiningTable table)
{
switch (table.Status)
{
case TableStatus.Free:
return(FREE_COLOR); // Green
case TableStatus.Occupied:
return(OCCUPIED_COLOR); // Blue
case TableStatus.Reserved:
return(RESERVED_COLOR); // Red
default:
throw new Exception("Incorrect table status input");
}
}
public void DB_Update_DiningTable(DiningTable diningTable)
{
string query = $"UPDATE DiningTables SET Table_Status = @status WHERE Table_ID = @table";
SqlParameter[] sqlParameters =
{
new SqlParameter("@table", SqlDbType.Int)
{
Value = diningTable.Table_ID
},
new SqlParameter("@status", SqlDbType.Int)
{
Value = (int)diningTable.Table_Status
}
};
ExecuteEditQuery(query, sqlParameters);
}
