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