private void MySearchView_QueryTextChange(object sender, SearchView.QueryTextChangeEventArgs e)
{
string searchValue = e.NewText;
System.Console.WriteLine("value is: " + searchValue);
List <user> newHouses = new List <user>();
foreach (user userObj in myUserList)
{
if (userObj.vad_titleFRomDb.Contains(searchValue))
{
newHouses.Add(userObj);
}
}
//myAdapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleListItem1, newStringArray);
var myAdapter = new CustomAdapter(Activity, newHouses);
myListView.Adapter = myAdapter;
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.layout1);
myListView = FindViewById <ListView>(Resource.Id.list_posted_ad);
nm = Intent.GetStringExtra("un");
help = new DBHelper(this);
ICursor result = help.showAll_postedAds(nm);
while (result.MoveToNext())
{
/*
*
*
* private const string Column_id = "id";
* private const string Column_ad_title = "ad_title";
* private const string Column_ad_description = "ad_description";
* private const string Column_ad_price = "price";
* private const string Column_ad_region= "region";
* private const string Column_ad_email = "ad_email";
* */
var titleFromDb = result.GetString(result.GetColumnIndexOrThrow("ad_title"));
var descFRomdb = result.GetString(result.GetColumnIndexOrThrow("ad_description"));
var priceFromDb = result.GetString(result.GetColumnIndexOrThrow("price"));
var regionFromDb = result.GetString(result.GetColumnIndexOrThrow("region"));
var idFromDb = result.GetString(result.GetColumnIndexOrThrow("id"));
my_ads_list.Add(new user(idFromDb, titleFromDb, descFRomdb, priceFromDb, regionFromDb));
}
var myAdapter = new CustomAdapter(this, my_ads_list);
myAdapter.NotifyDataSetChanged();
myListView.Adapter = myAdapter;
myListView.ItemClick += MyListView_ItemClick;
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
// Use this to return your custom view for this Fragment
// return inflater.Inflate(Resource.Layout.YourFragment, container, false);
View myView = inflater.Inflate(Resource.Layout.ads_fragment, container, false);
help = new DBHelper(Activity);
myListView = myView.FindViewById <ListView>(Resource.Id.listView1);
mySearchView = myView.FindViewById <SearchView>(Resource.Id.searchView1);
ICursor result = help.showAllAds();
myUserList.Clear();
while (result.MoveToNext())
{
/*
* private const string Column_id = "id";
* private const string Column_ad_title = "ad_title";
* private const string Column_ad_description = "ad_description";
* private const string Column_ad_price = "price";
* private const string Column_ad_region= "region";
* private const string Column_ad_email = "ad_email"; */
var idFromDb = result.GetString(result.GetColumnIndexOrThrow("id"));
var ad_titleFRomDb = result.GetString(result.GetColumnIndexOrThrow("ad_title"));
var ad_DescFRomDb = result.GetString(result.GetColumnIndexOrThrow("ad_description"));
var priceFromDb = result.GetString(result.GetColumnIndexOrThrow("price"));
var regionFromDb = result.GetString(result.GetColumnIndexOrThrow("region"));
myUserList.Add(new user(idFromDb, ad_titleFRomDb, ad_DescFRomDb, priceFromDb, regionFromDb));
}
myAdapter = new CustomAdapter(Activity, myUserList);
myAdapter.NotifyDataSetChanged();
myListView.Adapter = myAdapter;
myListView.ItemClick += MyListView_ItemClick;
mySearchView.QueryTextChange += MySearchView_QueryTextChange;
return(myView);
}
