public static List <TableOrder> GetAll()
{
List <TableOrder> allOrders = new List <TableOrder> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM table_orders ORDER BY order_date", conn);
MySqlDataReader rdr = cmd.ExecuteReader();
int id = 0;
string tableNumber = "";
DateTime orderDate = DateTime.Now;
while (rdr.Read())
{
id = rdr.GetInt32(0);
tableNumber = rdr.GetString(1);
orderDate = rdr.GetDateTime(2);
TableOrder newOrder = new TableOrder(tableNumber, orderDate, id);
allOrders.Add(newOrder);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allOrders);
}
public static TableOrder Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM table_orders WHERE id=@id", conn);
MySqlParameter prmId = new MySqlParameter("@id", id);
cmd.Parameters.Add(prmId);
MySqlDataReader rdr = cmd.ExecuteReader();
string tableNumber = "";
DateTime orderDate = DateTime.Now;
while (rdr.Read())
{
tableNumber = rdr.GetString(1);
orderDate = rdr.GetDateTime(2);
}
TableOrder foundOrder = new TableOrder(tableNumber, orderDate, id);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundOrder);
}
public override bool Equals(System.Object otherOrder)
{
if (!(otherOrder is TableOrder))
{
return(false);
}
else
{
TableOrder newOrder = (TableOrder)otherOrder;
bool idEquality = this.GetId().Equals(newOrder.GetId());
bool dateEquality = this.GetOrderDate().Equals(newOrder.GetOrderDate());
bool tableNumberEquality = this.GetTableNumber().Equals(newOrder.GetTableNumber());
return(idEquality && dateEquality && tableNumberEquality);
}
}