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(); }