private async void Create_Update_Click(object sender, RoutedEventArgs e)
{
string alert = "";
ITextRange range = detail.Document.GetRange(0, TextConstants.MaxUnitCount);
if (title.Text.Trim() == "")
{
alert += "Title can't be empty!\n";
}
if (range.Text.Trim() == "")
{
alert += "Detail can't be empty!\n";
}
if (ddl.Date.Date.CompareTo(DateTime.Today) < 0)
{
alert += "The due date has passed!";
}
if (alert != "")
{
await new MessageDialog(alert).ShowAsync();
}
else if (create_update.Content.ToString() == "Create")
{
ViewModel.AddItem(ddl.Date.DateTime, Common.selectName, title.Text, range.Text);
Common.selectName = "";
await new MessageDialog("Create successfully!").ShowAsync();
ViewModel.SelectedItem = null;
Frame.Navigate(typeof(MainPage));
}
else
{
ViewModel.UpdateItem(ddl.Date.DateTime, Common.selectName, title.Text, range.Text);
Common.selectName = "";
ViewModel.SelectedItem = null;
await new MessageDialog("Update successfully!").ShowAsync();
Frame.Navigate(typeof(MainPage));
}
}
private async void Create_Update_Click(object sender, RoutedEventArgs e)
{
string alert = "";
ITextRange range = detail.Document.GetRange(0, TextConstants.MaxUnitCount);
if (title.Text.Trim() == "")
{
alert += "Title can't be empty!\n";
}
if (range.Text.Trim() == "")
{
alert += "Detail can't be empty!\n";
}
if (ddl.Date.Date.CompareTo(DateTime.Today) < 0)
{
alert += "The due date has passed!";
}
if (alert != "")
{
await new MessageDialog(alert).ShowAsync();
}
else if (create_update.Content.ToString() == "Create")
{
try {
string sql = @"INSERT INTO Todo (date, imgname, title, detail, finish) VALUES (?,?,?,?,?)";
using (var res = conn.Prepare(sql)) {
res.Bind(1, ddl.Date.Date.ToString());
res.Bind(2, Common.selectName);
res.Bind(3, title.Text.Trim());
res.Bind(4, range.Text.Trim());
res.Bind(5, "false");
res.Step();
ViewModel.AddItem(conn.LastInsertRowId(), ddl.Date.DateTime, Common.selectName, title.Text.Trim(), range.Text.Trim(), false);
Common.selectName = "";
Cancle_Click(null, null);
ViewModel.SelectedItem = null;
await new MessageDialog("Create successfully!").ShowAsync();
Frame.Navigate(typeof(MainPage));
}
} catch (Exception ex) {
Debug.WriteLine(ex.Message);
throw;
}
}
else
{
try {
string sql = @"UPDATE Todo SET date = ?, imgname = ?, title = ?, detail = ? WHERE ID = ?";
using (var res = conn.Prepare(sql)) {
res.Bind(1, ddl.Date.Date.ToString());
res.Bind(2, Common.selectName);
res.Bind(3, title.Text.Trim());
res.Bind(4, range.Text.Trim());
res.Bind(5, ViewModel.SelectedItem.ID);
res.Step();
ViewModel.UpdateItem(ddl.Date.DateTime, Common.selectName, title.Text.Trim(), range.Text.Trim());
await new MessageDialog("Update successfully!").ShowAsync();
Frame.Navigate(typeof(MainPage));
}
} catch (Exception ex) {
Debug.WriteLine(ex.Message);
throw;
}
}
}