private void DeleteBar_Click(object sender, RoutedEventArgs e)
{
if (ViewModles.SelectItem != null)
{
string sql = @"DELETE FROM MyTodo WHERE ID = ?";
try
{
using (var res = conn.Prepare(sql))
{
res.Bind(1, ViewModles.SelectItem.id);
res.Step();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw;
}
ViewModles.DeleteItem();
ViewModles.SelectItem = null;
///Frame.Navigate(typeof(MainPage));
Frame rootFrame = Window.Current.Content as Frame;
rootFrame.GoBack();
TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
/*createButton.Content = "Create";
* CancelButton_Click(null, null);
* string sql = @"DELETE FROM MyToDo WHERE ID=?";
* try
* {
* using (var cus = conn.Prepare(sql))
* {
* cus.Bind(1, ViewModles.SelectItem.id);
* cus.Step();
* //var data = (sender as FrameworkElement).DataContext;
* //var item = MyListView.ContainerFromItem(data) as ListViewItem;
* //ViewModles.SelectItem = item.Content as MyList;
*
* }
* }
* catch (Exception ex)
* {
* Debug.WriteLine(ex.Message);
* }
* ViewModles.DeleteItem();
* ViewModles.SelectItem = null;
* TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);*/
dynamic ori = e.OriginalSource;
ViewModles.SelectItem = (Modle.MyList)ori.DataContext;
if (ViewModles.SelectItem != null)
{
string sql = @"DELETE FROM MyTodo WHERE ID = ?";
try
{
using (var res = conn.Prepare(sql))
{
res.Bind(1, ViewModles.SelectItem.id);
res.Step();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw;
}
ViewModles.DeleteItem();
ViewModles.SelectItem = null;
// Frame.Navigate(typeof(MainPage), ViewModles);
TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);
}
}
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
this.Resuming += OnResuming;
loadDatebase();
ViewModles = ViewModle.MyItem.getinstance();
TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);
TileUpdateManager.CreateTileUpdaterForApplication().Clear();
for (int i = 0; i < ViewModles.AllItems.Count; i++)
{
UpdatePrimaryTile(ViewModles.AllItems[i].title, ViewModles.AllItems[i].detail);
}
TileUpdateManager.CreateTileUpdaterForApplication().EnableNotificationQueue(true);
}
private void createButton_Click(object sender, RoutedEventArgs e)
{
ITextRange range = detials.Document.GetRange(0, TextConstants.MaxUnitCount);
if (title.Text == "")
{
var i = new MessageDialog("Title不能为空！").ShowAsync();
}
if (range.Text == "")
{
var i = new MessageDialog("Detial不能为空！").ShowAsync();
}
if (date.Date < System.DateTime.Today)
{
var i = new MessageDialog("所选日期不能为今天以前！").ShowAsync();
}
if (title.Text != "" && range.Text != "" && date.Date >= DateTime.Now.Date)
{
if (ViewModles.SelectItem != null)
{
try
{
string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?";
using (var cus = conn.Prepare(sql))
{
cus.Bind(1, date.Date.ToString());
cus.Bind(2, title.Text.Trim());
cus.Bind(3, range.Text.Trim());
cus.Bind(4, ViewModles.SelectItem.id);
cus.Step();
ViewModles.UpdateItem("", title.Text.Trim(), range.Text.Trim(), date.Date.DateTime);
}
Frame.Navigate(typeof(MainPage));
circulationUpdate();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
if (createButton.Content.ToString() == "Create" && ViewModles.SelectItem == null)
{
try
{
string sql = @"INSERT INTO MyToDo(DATA,TITLE,DETAIL,FINISH) VALUES (?,?,?,?)";
using (var cus = conn.Prepare(sql))
{
cus.Bind(1, date.Date.ToString());
cus.Bind(2, title.Text.Trim());
cus.Bind(3, range.Text.Trim());
cus.Bind(4, "false");
cus.Step();
ViewModles.AddTodoItem(conn.LastInsertRowId(), title.Text, range.Text, date.Date.DateTime, false);
}
title.Text = "";
range.Text = "";
date.Date = System.DateTime.Today;
circulationUpdate();
TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);
}catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
if (createButton.Content.ToString() == "Update" && ViewModles.SelectItem != null)
{
try
{
string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?";
using (var cus = conn.Prepare(sql))
{
cus.Bind(1, date.Date.ToString());
cus.Bind(2, title.Text.Trim());
cus.Bind(3, range.Text.Trim());
cus.Bind(4, ViewModles.SelectItem.id);
cus.Step();
ViewModles.UpdateItem("", title.Text.Trim(), range.Text.Trim(), date.Date.DateTime);
}
Frame.Navigate(typeof(MainPage));
circulationUpdate();
}catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
}
private void Creat_Click(object sender, RoutedEventArgs e)
{
ITextRange range = b.Document.GetRange(0, TextConstants.MaxUnitCount);
if (a.Text == "")
{
var i = new MessageDialog("Title不能为空！").ShowAsync();
}
if (range.Text == "")
{
var i = new MessageDialog("Detail不能为空！").ShowAsync();
}
if (date1.Date < System.DateTime.Today)
{
var i = new MessageDialog("请选择今天之后的日期！").ShowAsync();
}
if (a.Text != "" && range.Text != "" && date1.Date >= DateTime.Now.Date)
{
///Debug.Write("101");
if (ViewModles.SelectItem != null)
{
try
{
string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?";
using (var cus = conn.Prepare(sql))
{
cus.Bind(1, date1.Date.ToString());
cus.Bind(2, a.Text.Trim());
cus.Bind(3, range.Text.Trim());
cus.Bind(4, ViewModles.SelectItem.id);
cus.Step();
ViewModles.UpdateItem("", a.Text, range.Text, date1.Date.DateTime);
///Debug.Write("111");
Frame rootFrame = Window.Current.Content as Frame;
circulationUpdate();
rootFrame.GoBack();
}
}catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
else
{
///Debug.Write("110");
try
{
string sql = @"INSERT INTO MyToDo(DATA,TITLE,DETAIL,FINISH) VALUES (?,?,?,?)";
using (var cus = conn.Prepare(sql))
{
cus.Bind(1, date1.Date.ToString());
cus.Bind(2, a.Text.Trim());
cus.Bind(3, range.Text.Trim());
cus.Bind(4, "false");
cus.Step();
ViewModles.AddTodoItem(conn.LastInsertRowId(), a.Text, range.Text, date1.Date.DateTime, false);
}
Frame rootFrame = Window.Current.Content as Frame;
rootFrame.GoBack();
circulationUpdate();
TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);
}catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
}
