public void RefreshPlot()
        {
            string query =
                "SELECT Count(*) AS count, plot_id FROM booking WHERE postcode='MK' AND status='open' GROUP BY plot_id";
            var cmd = new MySqlCommand(query, _connection);
            var da = new MySqlDataAdapter(cmd);
            var dtCounts = new DataTable();
            da.Fill(dtCounts);

            if (dtCounts.Rows.Count > 0)
            {
                query = "UPDATE plot SET jobs = @jobCount WHERE plot_id = @plotID AND postcode='MK'";
                cmd = new MySqlCommand(query, _connection);
                foreach (DataRow row in dtCounts.Rows)
                {
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@jobCount", int.Parse(row["count"].ToString()));
                    cmd.Parameters.AddWithValue("@plotID", int.Parse(row["plot_id"].ToString()));
                    cmd.ExecuteNonQuery();
                }
            }
            else if ((dtCounts.Rows.Count == 0))
            {
                query = "UPDATE plot SET jobs=0 WHERE postcode='MK'";
                cmd = new MySqlCommand(query, _connection);
                cmd.ExecuteNonQuery();
            }
            CloseConnection();
        }