Mobile

_adapter.Filter.InvokeFilter(_inputSearch.Text);

_adapter = new ArrayAdapter<string>(this, Resource.Layout.list_item, Resource.Id.product_name, products);

protected override void OnCreate(Bundle bundle)
        {
            base.OnCreate(bundle);

            // Create your application here
            SetContentView(Resource.Layout.HesabList);

            progress = ProgressDialog.Show(this, "", "Loading ...");
            progress.SetProgressStyle(ProgressDialogStyle.Spinner);
            progress.Indeterminate = true;
            new Thread(new ThreadStart(delegate
            {
                _btnUpdate = FindViewById<Button>(Resource.Id.UpdateHesabList);
                _btnUpdate.Click += new EventHandler(_btnUpdate_Click);
                gvHesab = FindViewById<ListView>(Resource.Id.gvHesabList);
                gvHesab.ItemClick += new EventHandler<AdapterView.ItemClickEventArgs>(gvHesab_ItemClick);
                isTarafHesab = Intent.GetBooleanExtra("IsTarafHesab", false);
                txtSearchHesabList = (EditText)FindViewById(Resource.Id.txtSearchHesabList);
                txtSearchHesabList.TextChanged += new EventHandler<Android.Text.TextChangedEventArgs>(txtSearchHesabList_TextChanged);
                txtSearchHesabList.Gravity = GravityFlags.Right;

                Looper.Prepare();
                File dbtest = new File(clsBase.SqliteDBPath);
                
                if (!dbtest.Exists() )
                {

                    if (clsBase.HasInternetConnection(this))
                        createDbSqlite();
                    else
                    {
                        MessageBoxAndroid.Show(this, "Connect to Internet First !");
                        Finish();
                    }
                }
                else
                {
                     fillListView();
                 }

                RunOnUiThread(() => progress.Dismiss()); 
           })).Start();
            
        }

private void fillGridView()
        {
            try
            {  
                SQLiteDatabase db = OpenOrCreateDatabase("test.db", FileCreationMode.WorldReadable, null);

                ICursor cursors = db.RawQuery("select Moen, Hesab, opab, Coab,(select count(*) from tbl_Hest b  where a._id >= b._id) as _id,Id  from tbl_Hest a", null);
                
                String[] from = Resources.GetStringArray(Resource.Array.gvHesabHeader);

                int[] to = { Resource.Id.txt_HesabListGrid_Heen,
                             Resource.Id.txt_HesabListGrid_Heol ,Resource.Id.txt_HesabListGrid_Heb,
                             Resource.Id.txt_HesabListGrid_Coab,Resource.Id.txt_HesabListGrid_Row,Resource.Id.txt_HesabListGrid_Id};
                RunOnUiThread(() =>
               {
                   SimpleCursorAdapter _HesabGridAdapter = new HesabListGridview(this, Resource.Layout.HesabListGrid, cursors, from, to);
                    
                       gvHesab.Adapter = _HesabGridAdapter;
               });
                
                setListViewHeightBasedOnChildren(gvHesab);//بخورد Scroll برای حالتی که کل صفحه 
                gvHesab.TextFilterEnabled = true;
                
                EditText txtSearchHesabList = (EditText)FindViewById(Resource.Id.txtSearchHesabList);
                txtSearchHesabList.TextChanged += new EventHandler<Android.Text.TextChangedEventArgs>     
                (txtSearchHesabList_TextChanged);
                 
              
            }
            catch (Exception ex)
            {
                
            }
        }

    class HesabListGridview : SimpleCursorAdapter
    {
        ICursor c;
        //MatrixCursor cur;
        Context context;
        Activity activity;
        int idS;
        public HesabListGridview(Context context, int layout, ICursor c, string[] from, int[] to)
            : base(context, layout, c, from, to)
        {
            this.c = c; 
            this.context = context;
            this.activity = (Activity)context;

        }
        bool isFirst = true;
        public static int dtRowCount = 0;
        int CountRepeated = 0;
        public override Filter Filter
        {
            get
            {
                return base.Filter;
            }
        }
        public override IFilterQueryProvider FilterQueryProvider
        {
            get
            {
                return base.FilterQueryProvider;
            }
            set
            {
                base.FilterQueryProvider = value;
            }
        }
        public override View GetView(int position, View convertView, ViewGroup parent)
        {

            if (convertView == null)
                convertView = View.Inflate(context, Resource.Layout.HesabListGrid, null);
            View row = convertView;
            try
            {

                c.MoveToPosition(position);
                TextView txtHesabGrid_Coni = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Hesoen);
                TextView txtHesabGrid_Bde = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Hesol);
                TextView txtHesabGrid_Nab = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Heab);
                TextView txtHesabGrid_Cosab = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Coab);
                TextView txtHesabGrid_Row = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Row);
                TextView txtHesabGrid_Id = (TextView)convertView.FindViewById(Resource.Id.txt_HesabListGrid_Id);



                txtHesabGrid_Coni.SetText(c.GetString(c.GetColumnIndex("Hen")), TextView.BufferType.Normal);



                txtHesabGrid_Bde.SetText(c.GetString(c.GetColumnIndex("Hl")), TextView.BufferType.Normal);


                txtHesabGrid_Nab.SetText(c.GetString(c.GetColumnIndex("Heb")), TextView.BufferType.Normal);

                txtHesabGrid_Cosab.SetText(c.GetString(c.GetColumnIndex("Coab")), TextView.BufferType.Normal);

                txtHesabGrid_Row.SetText(c.GetInt(c.GetColumnIndex("_id")).ToString(), TextView.BufferType.Normal);

                txtHesabGrid_Id.SetText(c.GetString(c.GetColumnIndex("Id")), TextView.BufferType.Normal);
                txtHesabGrid_Id.Visibility = ViewStates.Gone;
                //txtHesabGrid_Id.Visibility = ViewStates.Invisible;
                if (position % 2 == 0)
                {

                    convertView.SetBackgroundColor(Android.Graphics.Color.ParseColor("#6bcdfb"));
                }
                else
                {
                    convertView.SetBackgroundColor(Android.Graphics.Color.ParseColor("#2cb8de"));
                }
                CountRepeated++;
               // MessageBoxAndroid.Show(context, CountRepeated.ToString()  + "\n" + dtRowCount.ToString());
                if (17 == CountRepeated)
                {
                    isFirst = false;
                }
                if (isFirst)
                {
                    
                    HorizontalScrollView hv = (HorizontalScrollView)activity.FindViewById(Resource.Id.scrollHesabListGrid);
                    hv.FullScroll(FocusSearchDirection.Left);

                }
            }
            catch (Exception ex)
            {
                    }

            //hv.ScrollTo(hv.Right + 80, hv.Top);
            return (row);
        }




    }
}

Public Function XAES_Encrypt(input As String, pass As String) As String
       Dim AES As New System.Security.Cryptography.AesManaged
       Dim Hash_AES As New System.Security.Cryptography.SHA256Managed
       Dim encrypted As String = ""
       Try
           Dim hash As Byte() = New Byte(31) {}
           Dim temp As Byte() = Hash_AES.ComputeHash(System.Text.UnicodeEncoding.Unicode.GetBytes(pass))
           Array.Copy(temp, 0, hash, 0, 16)
           Array.Copy(temp, 0, hash, 15, 16)
           AES.Key = hash
           ''''''''''''''''''AES.Mode = System.Security.Cryptography.CipherMode.ECB
           Dim DESEncrypter As System.Security.Cryptography.ICryptoTransform = AES.CreateEncryptor()
           Dim Buffer As Byte() = System.Text.UnicodeEncoding.Unicode.GetBytes(input)
           encrypted = Convert.ToBase64String(DESEncrypter.TransformFinalBlock(Buffer, 0, Buffer.Length))
           Return encrypted
       Catch ex As Exception
           Return ex.Message & "error"
       End Try
   End Function

   Public Function XAES_Decrypt(input As String, pass As String) As String

       Dim AES As New System.Security.Cryptography.AesManaged
       Dim Hash_AES As New System.Security.Cryptography.SHA256Managed
       Dim decrypted As String = ""
       Try
           Dim hash As Byte() = New Byte(31) {}
           Dim temp As Byte() = Hash_AES.ComputeHash(System.Text.UnicodeEncoding.Unicode.GetBytes(pass))
           Array.Copy(temp, 0, hash, 0, 16)
           Array.Copy(temp, 0, hash, 15, 16)
           AES.Key = hash
           '''''''''''''AES.Mode = System.Security.Cryptography.CipherMode.ECB
           Dim DESDecrypter As System.Security.Cryptography.ICryptoTransform = AES.CreateDecryptor()
           Dim Buffer As Byte() = Convert.FromBase64String(input)
           Dim TFB() As Byte = DESDecrypter.TransformFinalBlock(Buffer, 0, Buffer.Length)
           '''''''''''ERROR:Padding is invalid and cannot be removed.
           decrypted = System.Text.UnicodeEncoding.Unicode.GetString(TFB, 0, TFB.Length)

           Return decrypted
       Catch ex As Exception
           Return ex.Message & "Error"
       End Try
   End Function

public static void  CopyToIsolatedStorage(string _fileName)
        {
            List<string> MyList = new List<string>();
            MyList.Add(_fileName);

            foreach (var item in MyList)
            {
                using (IsolatedStorageFile localFile = IsolatedStorageFile.GetUserStoreForApplication())
                {

                    Uri uri = new Uri(_fileName, UriKind.Absolute);
                    HttpWebRequest request = HttpWebRequest.Create(uri) as HttpWebRequest;
                    request.BeginGetResponse((ar) =>
                    {
                        var response = request.EndGetResponse(ar);
                        Deployment.Current.Dispatcher.BeginInvoke(() =>
                        {
                            using (var stream = response.GetResponseStream())
                            {
                                var name = GetFileNameinURL(item);
                                if (localFile.FileExists(name))
                                {
                                    localFile.DeleteFile(name);
                                }
                                using (IsolatedStorageFileStream fs = localFile.CreateFile(name))
                                {
                                    stream.CopyTo(fs);

                                }
                            }
                        });
                    }, null);
                }
            }

        }

private void btnPlay_Click(object sender, RoutedEventArgs e)
{       Button button = sender as Button;

        //Copy file to Temp isolated Storate as Files can only play if they are in the Isolated Storage
GenericFunctions.CopyToIsolatedStorage(button.Tag.ToString());  //eg. url http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3
        //<MediaElement Name="media"   />
        media.Source = new Uri(GenericFunctions.GetFileNameinURL(button.Tag.ToString()));
        media.Play();
        media.Volume = 1;
}

string m_Url = "http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3";//string.Empty;

      private void btnDownload_Click(object sender, RoutedEventArgs e)
      {
          Button button = sender as Button;
          if (button.Tag.ToString() != string.Empty)
          {

            //  m_Url = button.Tag.ToString();

              //Obtain a virtual store for application
              IsolatedStorageFile fileStorage = IsolatedStorageFile.GetUserStoreForApplication();

              if (!fileStorage.DirectoryExists("BOOKS"))
              {
                  //Create new subdirectory
                  fileStorage.CreateDirectory("BOOKS");
              }

              //Create a new StreamWriter, to write the file to the specified location.
              StreamWriter fileWriter = new StreamWriter(new IsolatedStorageFileStream("BOOKS\\" + GenericFunctions.GetFileNameinURL(m_Url), FileMode.OpenOrCreate, fileStorage));

              fileWriter.Close();

              if (fileStorage.FileExists("BOOKS\\" + GenericFunctions.GetFileNameinURL(m_Url)))
              {
                  MessageBox.Show("Download Complete");

                  GenericFunctions.PlaySound("BOOKS\\" + GenericFunctions.GetFileNameinURL(m_Url));
              }
          }

      }

<SONGS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SONG>
    <SONG_ID>1</SONG_ID>
    <TITLE>SONG1</TITLE>
    <PRICE>3.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
  <SONG>
    <SONG_ID>2</SONG_ID>
    <TITLE>SONG2</TITLE>
    <PRICE>3.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
  <SONG>
    <SONG_ID>3</SONG_ID>
    <TITLE>SONG3</TITLE>
    <PRICE>R4.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
  <SONG>
    <SONG_ID>4</SONG_ID>
    <TITLE>SONG4</TITLE>
    <PRICE>3.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
  <SONG>
    <SONG_ID>1</SONG_ID>
    <TITLE>SONG5</TITLE>
    <PRICE>6.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
  <SONG>
    <SONG_ID>5</SONG_ID>
    <TITLE>SONG6</TITLE>
    <PRICE>10.95</PRICE>
    <URI>http://media.lakewood.org.edgesuite.net/JOM/podcast/mp3_audio/596_Podcast.mp3</URI>
  </SONG>
</SONGS>

public class SongsModel
  {
      public int SONG_ID { get; set; }
      public string TITLE { get; set; }
      public string URI { get; set; }
      public string PRICE { get; set; }
  }

<pre lang="c#">