// Insert the new contact in the Contacts table. public void Insert(GhiChu newcontact) { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { dbConn.RunInTransaction(() => { dbConn.Insert(newcontact); }); } }
private async void Image_Tapped(object sender, TappedRoutedEventArgs e) { if (tbxTitle.Text == "") { MessageDialog ms = new MessageDialog("Vui lòng nhập tiêu đề!"); await ms.ShowAsync(); return; } if (tbxContent.Text == "") { MessageDialog ms = new MessageDialog("Vui lòng nhập nội dung!"); await ms.ShowAsync(); return; } var t = time.Time; var d = String.Format("{0:d}", date.Date); var k = DateTime.ParseExact(d + " " + t, "M/d/yyyy HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None); if (k <= DateTime.Now && cbComplete.IsChecked == false) { MessageDialog ms = new MessageDialog("Hạn chót phải sau thời điểm hiện tại!"); await ms.ShowAsync(); return; } IReadOnlyList<ScheduledToastNotification> scheduled = ToastNotificationManager.CreateToastNotifier().GetScheduledToastNotifications(); foreach (ScheduledToastNotification notify in scheduled) { if (notify.Id == ("T.note" + ((GhiChu)this.DataContext).Id)) { ToastNotificationManager.CreateToastNotifier().RemoveFromSchedule(notify); } } GhiChu u = new GhiChu(); u.Id = ((GhiChu)this.DataContext).Id; u.Title = tbxTitle.Text; u.Content = tbxContent.Text; u.Complete = (bool)cbComplete.IsChecked; u.Remind = (bool)cbNhacNho.IsChecked; u.Time = k.ToString(); DatabaseHelper help = new DatabaseHelper(); help.UpdateContact(u); if ((bool)cbNhacNho.IsChecked) { ToastTemplateType toastTemplate = ToastTemplateType.ToastImageAndText01; XmlDocument toastXml = ToastNotificationManager.GetTemplateContent(toastTemplate); XmlNodeList toastImageAttributes = toastXml.GetElementsByTagName("image"); ((XmlElement)toastImageAttributes[0]).SetAttribute("src", "/Assets/noteicon.png"); ((XmlElement)toastImageAttributes[0]).SetAttribute("alt", "alt text"); XmlNodeList toastTextElements = toastXml.GetElementsByTagName("text"); if ((bool)cbComplete.IsChecked) toastTextElements[0].AppendChild(toastXml.CreateTextNode(u.Title + " Hoàn thành!")); else toastTextElements[0].AppendChild(toastXml.CreateTextNode(u.Title)); var dueTime = new DateTimeOffset(k); var toast = new Windows.UI.Notifications.ScheduledToastNotification(toastXml, dueTime); toast.Id = "T.note" + u.Id.ToString(); Windows.UI.Notifications.ToastNotificationManager.CreateToastNotifier().AddToSchedule(toast); } if (Frame.CanGoBack) { Frame.GoBack(); } }
//Update existing conatct public void UpdateContact(GhiChu user) { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { var existingconact = dbConn.Query<GhiChu>("select * from GhiChu where Id =" + user.Id).FirstOrDefault(); if (existingconact != null) { existingconact.Title = user.Title; existingconact.Content = user.Content; existingconact.Time = user.Time; existingconact.Complete = user.Complete; existingconact.Remind = user.Remind; dbConn.RunInTransaction(() => { dbConn.Update(existingconact); }); } } }