public static void InsertMysqlAfiliationType()
        {
            ConectarSiteds();
            string          query         = "select * from TipoAfiliacion where flag = '0' order by cAfilType";
            OleDbCommand    commandselect = new OleDbCommand(query, Conex);
            OleDbDataReader reader        = commandselect.ExecuteReader();

            ConnectionMySQL.Connect();
            while (reader.Read())
            {
                ConnectionMySQL.InsertAfiliationType(reader.GetString(0).ToString(), reader.GetString(1).ToString());
                UpdateAfterInsert("TipoAfiliacion", "cAfilType", 0, reader);
            }
            ConnectionMySQL.Disconnect();
            FinalMessage();
        }