private void CreateButton_Clicked(object sender, RoutedEventArgs e)
{
if (createButton.Content.ToString() != "Update")
{
Models.TodoItem TodoToCreate = new Models.TodoItem(title.Text, details.Text, dueDate.Date, image.Source, ImageFile);
if (TodoToCreate.TodoInfoValidator())
{
ViewModel.AddTodoItem(TodoToCreate);
Frame.Navigate(typeof(MainPage), ViewModel);
}
}
else
{
UpdateButton_Clicked(sender, e);
}
var db = App.conn;
try
{
using (var TodoItem = db.Prepare("INSERT INTO TodoItems(Title, Description, DueDate) VALUES(?, ?, ?)"))
{
TodoItem.Bind(1, title.Text);
TodoItem.Bind(2, details.Text);
TodoItem.Bind(3, dueDate.Date.ToString("yyyy-MM-dd HH:mm:ss"));
TodoItem.Step();
}
}
catch (Exception ex)
{
}
}
private void UpdateButton_Clicked(object sender, RoutedEventArgs e)
{
var db = App.conn;
using (var statement = db.Prepare("UPDATE TodoItems SET Title = ?, Description = ?, DueDate = ? WHERE Title = ? AND Description = ? AND DueDate = ?"))
{
statement.Bind(1, title.Text);
statement.Bind(2, details.Text);
statement.Bind(3, dueDate.Date.ToString("yyyy-MM-dd HH:mm:ss"));
statement.Bind(4, ViewModel.SelectedItem.title);
statement.Bind(5, ViewModel.SelectedItem.description);
statement.Bind(6, ViewModel.SelectedItem.DueDate.ToString("yyyy-MM-dd HH:mm:ss"));
statement.Step();
}
using (var statement = db.Prepare("DELETE FROM TodoItems WHERE Title = ? AND Description = ? AND DueDate = ?"))
{
statement.Bind(1, title.Text);
statement.Bind(2, details.Text);
statement.Bind(3, dueDate.Date.ToString("yyyy-MM-dd HH:mm:ss"));
statement.Step();
}
if (ViewModel.SelectedItem != null)
{
StorageFile strFile = ViewModel.SelectedItem.shareFile;
Models.TodoItem TodoToUpdate = new Models.TodoItem(title.Text, details.Text, dueDate.Date, image.Source, strFile);
TodoToUpdate.id = ViewModel.SelectedItem.id;
if (TodoToUpdate.TodoInfoValidator())
{
ViewModel.UpdateTodoItem(ViewModel.SelectedItem, TodoToUpdate);
Frame.Navigate(typeof(MainPage), ViewModel);
}
}
}
private void CreateButton_Clicked(object sender, RoutedEventArgs e)
{
Models.TodoItem TodoToCreate = new Models.TodoItem(title2.Text,
details2.Text, dueDate2.Date, image2.Source, file);
if (TodoToCreate.TodoInfoValidator())
{
ViewModel.AddTodoItem(TodoToCreate);
}
var db = App.conn;
try
{
using (var TodoItem = db.Prepare("INSERT INTO TodoItems(Title, Description, DueDate) VALUES(?, ?, ?)"))
{
TodoItem.Bind(1, title2.Text);
TodoItem.Bind(2, details2.Text);
TodoItem.Bind(3, dueDate2.Date.ToString("yyyy-MM-dd HH:mm:ss"));
TodoItem.Step();
}
}
catch (Exception ex)
{
}
}
private void CreateButton_Clicked(object sender, RoutedEventArgs e)
{
Models.TodoItem TodoToCreate = new Models.TodoItem(title2.Text,
details2.Text, dueDate2.Date, image2.Source);
if (TodoToCreate.TodoInfoValidator())
{
ViewModel.AddTodoItem(TodoToCreate);
}
}
private void UpdateButton_Clicked(object sender, RoutedEventArgs e)
{
if (ViewModel.SelectedItem != null)
{
Models.TodoItem TodoToUpdate = new Models.TodoItem(title.Text, details.Text, dueDate.Date, image.Source);
TodoToUpdate.id = ViewModel.SelectedItem.id;
if (TodoToUpdate.TodoInfoValidator())
{
ViewModel.UpdateTodoItem(ViewModel.SelectedItem, TodoToUpdate);
Frame.Navigate(typeof(MainPage), ViewModel);
}
}
}
private void CreateButton_Clicked(object sender, RoutedEventArgs e)
{
if (createButton.Content.ToString() != "Update")
{
Models.TodoItem TodoToCreate = new Models.TodoItem(title.Text, details.Text, dueDate.Date, image.Source, ImageFile);
if (TodoToCreate.TodoInfoValidator())
{
ViewModel.AddTodoItem(TodoToCreate);
Frame.Navigate(typeof(MainPage), ViewModel);
}
}
else
{
UpdateButton_Clicked(sender, e);
}
}
