public void readOrdersFromDb(int userID, string username, EventController evc, DbController dbc) { DataTable orderTable = dbc.readOrders(userID); foreach (DataRow row in orderTable.Rows) { Event ev = evc.getEventByID(Convert.ToInt32(row.Field <Int64>("Event_ID"))); Order order = new Order(ev.PerformName, ev.Location.Name, ev.Start, username); DataTable seatTable = dbc.readSeatsForEvent(ev.Id, userID); foreach (DataRow seat in seatTable.Rows) { string status = ""; int statusNumber = Convert.ToInt32(seat.Field <Int64>("SeatStatus")); if (statusNumber == 1) { status = "foglalt"; } else if (statusNumber == 2) { status = "fizetett"; } else if (statusNumber == 3) { status = "hitelesitett"; } order.addSeat(new Seat(Convert.ToInt32(seat.Field <Int64>("RowNumber")), Convert.ToInt32(seat.Field <Int64>("ColumnNumber")), status)); } Orders.Add(order); } }