public TodoItemDialog (TodoItem item) { Name = item.Name; Notes = item.Notes; // TODO: ensure the completed property is displayed on the screen Done = item.Done; }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); int taskID = Intent.GetIntExtra("TaskID", 0); if (taskID > 0) { task = TodoItemManager.GetTask(taskID); } SetContentView(Resource.Layout.TaskDetails); nameTextEdit = FindViewById<EditText>(Resource.Id.NameText); notesTextEdit = FindViewById<EditText>(Resource.Id.NotesText); saveButton = FindViewById<Button>(Resource.Id.SaveButton); doneCheckbox = FindViewById<CheckBox>(Resource.Id.chkDone); doneCheckbox.Checked = task.Done; cancelDeleteButton = FindViewById<Button>(Resource.Id.CancelDeleteButton); cancelDeleteButton.Text = (task.ID == 0 ? "Cancel" : "Delete"); nameTextEdit.Text = task.Name; notesTextEdit.Text = task.Notes; cancelDeleteButton.Click += (sender, e) => { CancelDelete(); }; saveButton.Click += (sender, e) => { Save(); }; }
protected override void OnCreate(Bundle bundle) { base.OnCreate (bundle); int taskID = Intent.GetIntExtra("TaskID", 0); if(taskID > 0) { task = TodoItemManager.GetTask(taskID); } // set our layout to be the home screen SetContentView(Resource.Layout.TaskDetails); nameTextEdit = FindViewById<EditText>(Resource.Id.NameText); notesTextEdit = FindViewById<EditText>(Resource.Id.NotesText); saveButton = FindViewById<Button>(Resource.Id.SaveButton); doneCheckbox = FindViewById<CheckBox>(Resource.Id.chkDone); doneCheckbox.Checked = task.Done; // 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 = (task.ID == 0 ? "Cancel" : "Delete"); nameTextEdit.Text = task.Name; notesTextEdit.Text = task.Notes; // button clicks cancelDeleteButton.Click += (sender, e) => { CancelDelete(); }; saveButton.Click += (sender, e) => { Save(); }; }
protected override void OnCreate (Bundle bundle) { base.OnCreate (bundle); transaction = TodoItemManager.BeginTransaction(); var taskID = Intent.GetStringExtra("TaskID"); if (taskID == null) task = TodoItemManager.CreateTodoItem(); else task = TodoItemManager.GetTask(taskID); // set our layout to be the home screen SetContentView(Resource.Layout.TaskDetails); nameTextEdit = FindViewById<EditText>(Resource.Id.NameText); notesTextEdit = FindViewById<EditText>(Resource.Id.NotesText); saveButton = FindViewById<Button>(Resource.Id.SaveButton); // TODO: find the Checkbox control and set the value doneCheckbox = FindViewById<CheckBox>(Resource.Id.chkDone); doneCheckbox.Checked = task.Done; // 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 = "Delete"; nameTextEdit.Text = task.Name; notesTextEdit.Text = task.Notes; // button clicks cancelDeleteButton.Click += (sender, e) => { CancelDelete(); }; saveButton.Click += (sender, e) => { Save(); }; }
protected void ShowTaskDetails(TodoItem item) { currentItem = item; taskDialog = new TodoItemDialog (currentItem); context = new BindingContext (this, taskDialog, "Task Details"); detailsScreen = new DialogViewController (context.Root, true); ActivateController(detailsScreen); }
/// <summary>Convert from DataReader to Task object</summary> TodoItem FromReader (SqliteDataReader r) { var t = new TodoItem (); t.ID = Convert.ToInt32 (r ["_id"]); t.Name = r ["Name"].ToString (); t.Notes = r ["Notes"].ToString (); t.Done = Convert.ToInt32 (r ["Done"]) == 1 ? true : false; return t; }
/// <summary>Convert from DataReader to Task object</summary> private TodoItem FromReader (SqliteDataReader r) { var t = new TodoItem { ID = Convert.ToInt32 (r["_id"]), Name = r["Name"].ToString (), Notes = r["Notes"].ToString (), Done = (Convert.ToInt32 (r["Done"]) == 1) }; return t; }
protected void ShowTaskDetails(TodoItem item) { transaction = TodoItemManager.BeginTransaction(); item = item ?? TodoItemManager.CreateTodoItem(); currentItem = item; taskDialog = new TodoItemDialog (currentItem); context = new BindingContext (this, taskDialog, "Task Details"); detailsScreen = new DialogViewController (context.Root, true); ActivateController(detailsScreen); }
public TodoItem GetItem (int id) { var t = new TodoItem (); lock (locker) { connection = new SqliteConnection ("Data Source=" + path); connection.Open (); using (var command = connection.CreateCommand ()) { command.CommandText = "SELECT [_id], [Name], [Notes], [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 TodoItemDialog(TodoItem item) { Name = item.Name; Notes = item.Notes; Done = item.Done; }
public static int SaveTask(TodoItem item) { return(me.db.SaveItem(item)); }
public static string SaveTask (TodoItem item) { me.db.SaveItem(item); return item.ID; }
public static int SaveTask(TodoItem item) { return(TodoItemRepositoryADO.SaveTask(item)); }
public static int SaveTask (TodoItem item) { return TodoItemRepositoryADO.SaveTask (item); }
public void SaveItem (TodoItem item) { // Nothing to see here... }
//save item to DataBase public int SaveItem(TodoItem 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] = ?, [Notes] = ?, [Done] = ? WHERE [_id] = ?;"; command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Name }); command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Notes }); 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], [Notes], [Done]) VALUES (? ,?, ?)"; command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Name }); command.Parameters.Add (new SqliteParameter (DbType.String) { Value = item.Notes }); command.Parameters.Add (new SqliteParameter (DbType.Int32) { Value = item.Done }); r = command.ExecuteNonQuery (); } connection.Close (); return r; } } }
public static int SaveTask (TodoItem item) { return me.db.SaveItem(item); }
public int SaveItem(TodoItem 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] = ?, [Dates] = ?, [Priority] = ?, [Reminder] = ?, [Details] = ?, [Done] = ? WHERE [_id] = ?;"; command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Date }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Priority }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Reminder }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Details }); 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], [Dates], [Priority], [Reminder], [Details], [Done]) VALUES (? ,?, ?, ?, ?, ?)"; command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Date }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Priority }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Reminder }); command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Details }); command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.Done }); r = command.ExecuteNonQuery(); } connection.Close(); return(r); } } }