public void SaveStatus()
{
var currentData = GetCurrentData();
using (var db = new DataModel.DataContext()) {
var tempItem = db.State.FirstOrDefault();
if (tempItem != null)
{
tempItem.Title = currentData.Title;
tempItem.Des = currentData.Des;
tempItem.DueDate = currentData.DueDate;
tempItem.Icon = currentData.ImageByte;
tempItem.ListIndex = editIndex;
}
else
{
db.State.Add(new DataModel.TempState()
{
Title = currentData.Title,
Des = currentData.Des,
DueDate = currentData.DueDate,
Icon = currentData.ImageByte,
ListIndex = editIndex
});
}
db.SaveChanges();
}
}
public void Add(Item newItem)
{
Source.Add(newItem);
Tile.TileManger.AddTile(newItem.Title, newItem.Des, newItem.DueDate, newItem.ImageByte);
using (var db = new DataModel.DataContext()) {
db.Add(newItem.ToModel());
db.SaveChanges();
}
}
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
using (var db = new DataModel.DataContext()) {
db.Database.Migrate();
}
Model.ItemsDataSource.GetData().InitFromDB();
Tile.TileManger.InitTile();
}
public async void InitFromDB()
{
using (var db = new DataModel.DataContext()) {
var items = db.Items.ToList();
foreach (var item in items)
{
Item newItem = await new Item().FromModel(item);
Source.Add(newItem);
Tile.TileManger.AddTile(newItem.Title, newItem.Des, newItem.DueDate, item.Icon);
}
}
}
// 状态的保存与恢复
protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
if (e.NavigationMode == NavigationMode.Back)
{
using (var db = new DataModel.DataContext()) {
var tempItem = db.State.FirstOrDefault();
if (tempItem != null)
{
NewPage.Current.Restore(tempItem);
}
}
}
}
public bool Remove(int index)
{
if (index < 0 || index >= Source.Count)
{
return(false);
}
using (var db = new DataModel.DataContext()) {
var item = db.Items.Single(b => b.ListId == Source[index].GetId());
db.Items.Remove(item);
db.SaveChanges();
}
Source.RemoveAt(index);
Tile.TileManger.Update(Source);
return(true);
}
public bool Update(Item newItem, int index)
{
if (index < 0 || index >= Source.Count)
{
return(false);
}
bool state = Source[index].IsCheck;
Source[index] = Source[index].GetNewItem(newItem);
Source[index].IsCheck = state;
var newDate = Source[index].ToModel();
using (var db = new DataModel.DataContext()) {
var item = db.Items.Single(b => b.ListId == newDate.ListId);
item.Update(newDate);
db.SaveChanges();
}
Tile.TileManger.Update(Source);
return(true);
}
// 搜索模块
private void QueryItem(AutoSuggestBox sender, AutoSuggestBoxQuerySubmittedEventArgs args)
{
var text = args.QueryText;
searchBox.Text = "";
using (var db = new DataModel.DataContext()) {
var items = db.Items.Where(b => b.Title.Contains(text) ||
b.Des.Contains(text) ||
b.DueDate.ToString("D").Contains(text))
.ToList();
string content = "";
foreach (var item in items)
{
content += $"{item.Title} {item.Des} {item.DueDate.ToString("D")}\n";
}
if (content.Equals(""))
{
content = "No Result";
}
UtilTool.SendADialog("Search Result", content);
}
}