public bool Save(Notes note)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
db.Notes.InsertOnSubmit(note);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
public bool Destroy(Notes note)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
var excluir = db.Notes.Where(t => t.id == note.id).First();
db.Notes.DeleteOnSubmit(excluir);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
//ToDo implement note detail page
protected override void OnNavigatedTo(NavigationEventArgs e)
{
note = new Notes();
base.OnNavigatedTo(e);
int id = Int32.Parse(NavigationContext.QueryString["parameter"]);
if (id > 0)
{
note = note.GetNote(id);
}
else
{
note.note = String.Empty;
note.date = DateTime.Now;
}
ContentPanel.DataContext = note;
BoxNoteDetail.Text = note.note;
BlockNoteDate.Text = note.date.ToString();
}
/// <summary>
/// We found a note command, so we save it
/// </summary>
/// <param name="note"></param>
private void HandleNoteCommands(string text)
{
noting = true;
note = new Notes();
note.date = DateTime.Now;
note.note = text;
bool verify = StorageHelper.GetSetting("VERIFY_INPUT", true);
if (verify)
{
CortanaOverlay("I heard you say:", note.note, "Should i note it?");
}
else
{
note.Save();
NotesList.ItemsSource = note.GetAllNotes();
}
}
private void HandleAskCommands(string question)
{
noting = false;
question = question.Replace("?", String.Empty);
string[] words = question.Split(' ');
List<Notes> results = new List<Notes>();
Notes note = new Notes();
for (int i = 0; i < words.Length; i++)
{
if (!phrases.Contains(words[i]))
{
results.AddRange(note.GetSimilarNotes(" " + words[i] + " "));
}
}
if (results.Count > 0)
{
//Here is where is the magic, selecting the most frequent note found using the users given keywords
Notes mostFrequent = results.GroupBy(id => id).OrderByDescending(g => g.Count()).Take(1).Select(g => g.Key).First();
mostFrequent.note = mostFrequent.note.Replace("my ", "your ");
mostFrequent.note = mostFrequent.note.Replace("i ", "You ");
mostFrequent.note = mostFrequent.note.Replace("I am ", "You are");
if (mostFrequent != null || !String.IsNullOrEmpty(mostFrequent.note))
{
if (!mostFrequent.note.StartsWith("You"))
{
mostFrequent.note = "You " + mostFrequent.note;
}
try
{
CortanaOverlay("Here is what i found:", mostFrequent.note, String.Empty);
}
catch (Exception)
{
MessageBox.Show("Error when trying to use Text to speech", "Error", MessageBoxButton.OK);
}
}
else
{
CortanaOverlay("Sorry, i couldn't find anything", String.Empty, String.Empty);
}
}
else
{
CortanaOverlay("Sorry, i couldn't find anything", String.Empty, String.Empty);
}
}
/// <summary>
/// We need to check if the app called by Cortana and then handle the voice commands, else whe install the voice commands
/// </summary>
/// <param name="e"></param>
protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
if (e.NavigationMode == NavigationMode.New)
{
string voiceCommandName;
if (NavigationContext.QueryString.TryGetValue("voiceCommandName", out voiceCommandName))
{
HandleVoiceCommand(voiceCommandName);
}
else
{
Task.Run(() => InstallVoiceCommands());
}
}
bool delete = StorageHelper.GetSetting("AUTO_DELETE", false);
int days = StorageHelper.GetSetting("MAXIMUM_DATE", 1);
Notes notes = new Notes();
notes.DestroyOldNotes(days, delete);
NotesList.ItemsSource = notes.GetAllNotes();
}
