public bool updateItem(listItem item)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "ListItem.db")))
{
connection.Query <listItem>("update listItem set Title=?, subtitle=?,Distance=? where Id=?", item.Title, item.Subtitle, item.Distance, item.Id);
return(true);
}
}
catch (SQLiteException e)
{
Log.Info("Error", e.Message);
return(false);
}
}
/*public override bool OnOptionsItemSelected(IMenuItem item)
* {
* switch(item.ItemId)
* {
* case Android.Resource.Id.Home:
* var intent = new Intent();
* intent.PutExtra("title", title.Text);
* intent.PutExtra("subtitle", subtitle.Text);
* intent.PutExtra("distance", distance.Text);
* SetResult(Result.Ok, intent);
* Finish();
*
* return true;
*
* default:
* return base.OnOptionsItemSelected(item);
*
* }
* }*/
public override bool OnOptionsItemSelected(IMenuItem item)
{
switch (item.ItemId)
{
case Android.Resource.Id.Home:
listItem obj = new listItem();
obj.Title = title.Text;
obj.Subtitle = subtitle.Text;
obj.Distance = distance.Text;
db.Insert(obj);
return(true);
default:
return(base.OnOptionsItemSelected(item));
}
}
private List <listItem> GenerateListData()
{
List <listItem> data = new List <listItem>();
for (int i = 0; i < 30; i++)
{
listItem obj = new listItem();
obj.Id = i;
obj.Title = "Title" + i;
obj.Subtitle = "Address" + i;
obj.Distance = i + " km";
obj.Image = "https://picsum.photos/200/200/?" + i;
data.Add(obj);
}
return(data);
}
public List <listItem> getAllItems(listItem item)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "ListItem.db")))
{
return(connection.Table <listItem>().ToList());
}
}
catch (SQLiteException e)
{
Log.Info("Error", e.Message);
return(null);
}
}
public bool insert(listItem item)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "ListItem.db")))
{
connection.Insert(item);
return(true);
}
}
catch (SQLiteException e)
{
return(false);
}
}
public bool removeItem(listItem item)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "ListItem.db")))
{
connection.Delete(item);
return(true);
}
}
catch (SQLiteException e)
{
Log.Info("Error", e.Message);
return(false);
}
}
internal void Insert(listItem obj)
{
throw new NotImplementedException();
}