Convert PowerBuilder to C#

Conversion Samples of PowerBuilder to React and C# WPF

Ispirer Toolkit analyzes all object dependencies during the conversion process and provides not only line-by-line conversion, but resolves type conversions as well. The software understands and transforms the necessary inheritance dependencies. It parses the entire source code, builds an internal tree with all the information about the objects, and uses it in the migration process.

The code samples below provide you with more details.

• Variables declarations conversion:

  PowerBuilder

   
  	long		var1
  	long		var2[]
  	string		var3
  	datetime	var4
  	boolean		var5
  	decimal		var6
  	integer		var7
  	any		var8              
   

  → C# WPF

   
              int?        var1 = 0;
              UnboundedArray < int? >        var2 = new UnboundedArray < int? >();
              string        var3 = string.Empty;
              DateTime?    var4 = new DateTime(1900, 1, 1);
              bool?    var5 = false;
              decimal?        var6 = null;
              int?        var7 = 0;
              object        var8 = new object();
   

• Function conversion:

  PowerBuilder

   
  public function string sample_function();
  return "end" 
  //do logic
  end function              
   

  → C# WPF

   
          public  string sample_function()
          {
              return "end";
              //do logic
          }
   

• Subroutine conversion:

  PowerBuilder

   
  protected subroutine sample_sub (string v_app);
  	v_app = ""
  //do logic
  end subroutine
   

  → C# WPF

   
          public  void sample_sub(string v_app)
          {
              v_app = "";
              //do logic
          }
   

• If statement conversion:

  PowerBuilder

   
  integer i
   
  if true then i = 1 else i = 2
   
  if true then 
      i = 3
  end if
   

  → C# WPF

   
              int? i = 0;
   
              if (true)
              {
                  i = 1;
              }
              else
              {
                  i = 2;
              }
   
              if (true)
              {
                  i = 3;
              }       
   

• For statement conversion:

  PowerBuilder

   
  For lv_count = 1 to 10 
  	lb_units[lv_count].Visible = TRUE
  Next           
   

  → C# WPF

   
              for (lv_count = 1; lv_count <= 10; lv_count ++)
              {
                  lb_units[lv_count - 1].Visibility = Visibility.Visible;
              }
   

• While statement conversion:

  PowerBuilder

   
  IDX = 0
  do while true
  	if IDX = 10 then exit
  	IDX = IDX + 1
  loop              
   

  → C# WPF

   
              idx = 0;
   
              while (true)
              {
                  if (idx == 10)
                  {
                      break;
                  }
   
                  idx = idx + 1;
              }
   

• Try catch statement conversion:

  PowerBuilder

   
  try
  	IDX = 1 / 0
  catch (Exception ex )
  	IDX = 100
  FINALLY
  	IDX = IDX * 2
  end try              
   

  → C# WPF

   
              try
              {
                  idx = 1 / 0;
              }
              catch (Exception ex)
              {
                  idx = 100;
              }
              finally
              {
                  idx = idx * 2;
              }
   

• Try choose statement conversion:

  PowerBuilder

   
  integer		some_id
  boolean cond
   
  CHOOSE CASE some_id
  	Case IS < 0
  		cond = False
  	CASE 0 TO 2
  		cond = True
  		some_id = 200
  	Case IS > 0
  		cond = True
  	CASE ELSE
  		cond = False
  		some_id = 0
  END CHOOSE              
   

  → C# WPF

   
              int?        some_id = 0;
              bool? cond = false;
   
              if (some_id < 0)
              {
                  cond = false;
              }
              else if (some_id >= 0 && some_id <= 2)
              {
                  cond = true;
                  some_id = 200;
              }
              else if (some_id > 0)
              {
                  cond = true;
              }
              else
              {
                  cond = false;
                  some_id = 0;
              }
   

• Inline query conversion:

  PowerBuilder

   
  global type s_2 from structure
      long        field_1
  end type
  s_2 param1[]
   
  	INSERT INTO TAB1
  	  (             
  		COL1 , COL2           
  	  )
  	VALUES
  	  (
  		:param1[1].field_1,
  		:param1[2].field_1
  	);              
   

  → C# WPF

   
      public class s_2
      {
          public  int? field_1 = 0;
      }
   
              UnboundedArray< s_2 > param1 = new UnboundedArray< s_2 >();
              var dbCmd_ = new SACommand();
              dbCmd_.CommandText = "INSERT INTO TAB1 " +
                                   " (              " +
                                   " COL1 , COL2            " +
                                   " ) " +
                                   " VALUES " +
                                   " ( " +
                                   " :field_1, " +
                                   " :field_1 " +
                                   " )";
              dbCmd_.Parameters.AddWithValue("field_1", param1[0].field_1 ?? (object) DBNull.Value);
              dbCmd_.Parameters.AddWithValue("field_1", param1[1].field_1 ?? (object) DBNull.Value);
              dbCmd_.CommandType = CommandType.Text;
              AppGlobalVariables.sqlca.ExecuteNonQuery(dbCmd_);
   

• CURSOR conversion:

  PowerBuilder

   
  String v_uname[]
  Long v_unum[]
  Int  v_count = 1
   
  DECLARE c_unit CURSOR FOR
  SELECT U_NAME, U_NUM
  FROM UNT 
  WHERE A_NUM = 10;
   
  OPEN c_unit;
  FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
  v_count ++
  Do While SQLCA.SQLCode = 0
  	FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
  	v_count ++
  Loop
  CLOSE c_unit;              
   

  → C# WPF

   
              UnboundedArray< string > v_uname = new UnboundedArray< string >();
              UnboundedArray < int? > v_unum = new UnboundedArray < int? >();
              int?  v_count = 1;
              var dbCmd_c_unit = new SACommand();
              dbCmd_c_unit.CommandText = "SELECT U_NAME, U_NUM " +
                                         " FROM UNT " +
                                         " WHERE A_NUM = 10";
              dbCmd_c_unit.CommandType = CommandType.Text;
              var c_unit = sqlca.ExecuteReader(dbCmd_c_unit);
   
              if (c_unit.Read())
              {
                  v_uname[v_count] = c_unit?.GetString(0);
                  v_unum[v_count] = c_unit?.GetInt32(1);
              }
              else
              {
                  sqlca.SqlCode = 100;
              }
   
              v_count ++;
   
              while (sqlca.SqlCode == 0)
              {
                  if (c_unit.Read())
                  {
                      v_uname[v_count] = c_unit?.GetString(0);
                      v_unum[v_count] = c_unit?.GetInt32(1);
                  }
                  else
                  {
                      sqlca.SqlCode = 100;
                  }
   
                  v_count ++;
              }
   
              c_unit.Close();
              c_unit.Dispose();