private void AddShopIdForEmpLevel3()
        {
            string sql = "SELECT * FROM employee WHERE work_place = 'shop'";

            try
            {
                myDataHelper.OpenConnection();
                MySqlDataReader reader = MyDataHelper.DataReader(sql);
                while (reader.Read())
                {
                    ((Employee)myEvent.GetPersonById(Convert.ToInt32(reader["empNr"]))).ChangeShop(myEvent.GetShopById(Convert.ToInt32(reader["SERVICE_POINT_id"])));
                }
            }
            catch
            {
                return;
            }
            finally
            {
                myDataHelper.CloseConnection();
            }
        }