private void Get_AppsCenter_LatestVersion()
 {
     try
     {
         _AppsCenter_LatestVersion = new List <AppsCenter_LatestVersion>();
         MyClasses.MySQL A = new MyClasses.MySQL();
         A.stored_procedure("Get_LatestVersionAppCenter");
         while (A.rdr.Read())
         {
             _AppsCenter_LatestVersion.Add(new AppsCenter_LatestVersion
             {
                 _Version         = !A.rdr.IsDBNull(0) ? A.rdr.GetString("latest_version") : null,
                 _Path_Installer  = !A.rdr.IsDBNull(1) ? A.rdr.GetString("path_latest_installer") : null,
                 _EXE             = !A.rdr.IsDBNull(2) ? A.rdr.GetString("exe") : null,
                 _MSI             = !A.rdr.IsDBNull(3) ? A.rdr.GetString("msi") : null,
                 _Path_Executable = !A.rdr.IsDBNull(4) ? A.rdr.GetString("path_executable") : null
             });
         }
         A.conn.Close(); A.conn.Dispose();
     }
     catch (Exception)
     {
         throw;
     }
 }
 private void Get_NetShare_Creds()
 {
     try
     {
         _NetShare_Cred = new List <NetShare_Cred>();
         MyClasses.MySQL A = new MyClasses.MySQL();
         A.stored_procedure("Get_NetShared_Creds");
         while (A.rdr.Read())
         {
             _NetShare_Cred.Add(new NetShare_Cred
             {
                 _Username = MyClasses.Pub.Decrypt(A.rdr.GetString("Domain"), MyClasses.Pub.passphraselesky) + "\\" + MyClasses.Pub.Decrypt(A.rdr.GetString("UN"), MyClasses.Pub.passphraselesky),
                 _Password = MyClasses.Pub.Decrypt(A.rdr.GetString("PW"), MyClasses.Pub.passphraselesky)
             });
         }
         A.conn.Close(); A.conn.Dispose();
     }
     catch (Exception)
     {
         throw;
     }
 }