protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); int taskID = Intent.GetIntExtra("BookmarkID", 0); if (taskID > 0) { bookmark = BookmarkManager.GetBookmark(taskID); } // set our layout to be the home screen SetContentView(Resource.Layout.BookmarkDetails); nameTextEdit = FindViewById<EditText>(Resource.Id.NameText); urlsTextEdit = FindViewById<EditText>(Resource.Id.UrlsText); saveButton = FindViewById<Button>(Resource.Id.SaveButton); // find all our controls cancelDeleteButton = FindViewById<Button>(Resource.Id.CancelDeleteButton); // set the cancel delete based on whether or not it's an existing task cancelDeleteButton.Text = (bookmark.ID == 0 ? "Cancel" : "Delete"); nameTextEdit.Text = bookmark.Name; urlsTextEdit.Text = bookmark.Url; // button clicks cancelDeleteButton.Click += (sender, e) => { CancelDelete(); }; saveButton.Click += (sender, e) => { Save(); }; }
public Bookmark GetItem(int id) { var t = new Bookmark(); lock (locker) { connection = new SqliteConnection("Data Source=" + path); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "SELECT [_id], [Name], [Url], [Done] from [Items] WHERE [_id] = ?"; command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = id }); var r = command.ExecuteReader(); while (r.Read()) { t = FromReader(r); break; } } connection.Close(); } return t; }
public static int SaveBookmark(Bookmark item) { return me.db.SaveItem(item); }
/// <summary>Convert from DataReader to Bookmark object</summary> Bookmark FromReader(SqliteDataReader r) { var t = new Bookmark(); t.ID = Convert.ToInt32(r["_id"]); t.Name = r["Name"].ToString(); t.Url = r["Url"].ToString(); t.Done = Convert.ToInt32(r["Done"]) == 1 ? true : false; return t; }
public int SaveItem(Bookmark item) { int r; lock (locker) { if (item.ID != 0) { connection = new SqliteConnection("Data Source=" + path); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "UPDATE [Items] SET [Name] = ?, [Url] = ?, [Done] = ? WHERE [_id] = ?;"; command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Url }); command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.Done }); command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.ID }); r = command.ExecuteNonQuery(); } connection.Close(); return r; } else { connection = new SqliteConnection("Data Source=" + path); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "INSERT INTO [Items] ([Name], [Url], [Done]) VALUES (? ,?, ?)"; command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Url }); command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.Done }); r = command.ExecuteNonQuery(); } connection.Close(); return r; } } }
public static int SaveBookmark(Bookmark item) { return BookmarkRepositoryADO.SaveBookmark(item); }