for (var i = 0; i < bidList.Count; i++)
            {
                var position = i + 1;
                bidList[i].Position = position.ToString();
                query = "UPDATE bid SET position=@position WHERE status='queued' AND postcode=@postcode AND operator_id=@operator_id';";
                cmd = new MySqlCommand(query, _connection);
                cmd.Parameters.AddWithValue(("@position"), position);
                cmd.Parameters.AddWithValue(("@postcode"), _plot);
                cmd.Parameters.AddWithValue(("@operator_id"), bidList[i].OperatorId);
                cmd.ExecuteNonQuery();
            }

            foreach (BidList t in bidList)
            {
                query = "SELECT operator_id, plot_id, status FROM booking " +
                        "WHERE status='open' AND postcode=@postcode AND operator_id='0'" +
                        "ORDER BY datetime ASC;" +
                        "UPDATE booking SET operator_id=@operator_id, status='allocated' " +
                        "WHERE (plot_id=@plot_id AND operator_id='0' AND status='open') LIMIT 1;";
                cmd = new MySqlCommand(query, _connection);
                cmd.Parameters.AddWithValue(("@operator_id"), t.OperatorId);
                cmd.Parameters.AddWithValue(("@postcode"), _plot);
                cmd.Parameters.AddWithValue(("@plot_id"), t.PlotId);
                cmd.ExecuteNonQuery();
            }