protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
recipe = (Recipe)e.Parameter;
journalEntries = recipe.JournalEntries;
}
public static RecipeJournal getJournalEntries(long recipeId)
{
RecipeJournal savedjournalEntries = new RecipeJournal();
SqliteConnection db = new SqliteConnection("Filename=RecipeBook.db");
db.Open();
SqliteCommand selectCommand = new SqliteCommand("SELECT * from JOURNAL_ENTRIES WHERE RID = @RecipeID");
selectCommand.Connection = db;
selectCommand.Parameters.AddWithValue("@RecipeID", recipeId);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
long id = query.GetInt64(0);
String entryNotes = query.GetString(2);
double rating = query.GetDouble(3);
DateTime entryDate = query.GetDateTime(4);
RecipeJournalEntry savedEntry = new RecipeJournalEntry(id);
savedEntry.RecipeID = recipeId;
savedEntry.EntryDate = entryDate;
savedEntry.EntryNotes = entryNotes;
savedEntry.Rating = rating;
savedjournalEntries.Add(savedEntry);
}
db.Close();
Debug.WriteLine("Saved Entries: " + savedjournalEntries.getSize());
return(savedjournalEntries);
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
recipes = new RecipeList();
recipes.verifyImageFolder();
RecipeBookDataAccessor.InitializeDatabase();
long recipeStartingId = RecipeBookDataAccessor.getMaxId(Recipe.TABLE_NAME) + 1;
RecipeList.recipeIdGenerator = new IdentifierGenerator(Recipe.TABLE_NAME, recipeStartingId);
long ingredientStartingId = RecipeBookDataAccessor.getMaxId(RecipeIngredient.TABLE_NAME) + 1;
RecipeList.ingredientIdGenerator = new IdentifierGenerator(RecipeIngredient.TABLE_NAME, ingredientStartingId);
long stepStartingId = RecipeBookDataAccessor.getMaxId(RecipeStep.TABLE_NAME) + 1;
RecipeList.stepIdGenerator = new IdentifierGenerator(RecipeStep.TABLE_NAME, stepStartingId);
long imageStartingId = RecipeBookDataAccessor.getMaxId(RecipeImage.TABLE_NAME) + 1;
RecipeList.imageIdGenerator = new IdentifierGenerator(RecipeImage.TABLE_NAME, imageStartingId);
long entryStartingId = RecipeBookDataAccessor.getMaxId(RecipeJournalEntry.TABLE_NAME) + 1;
RecipeList.journalEntryIdGenerator = new IdentifierGenerator(RecipeJournalEntry.TABLE_NAME, entryStartingId);
ObservableCollection <Recipe> savedRecipes = RecipeBookDataAccessor.getSavedRecipes();
for (int i = 0; i < savedRecipes.Count; i++)
{
Recipe savedRecipe = savedRecipes[i];
ObservableCollection <RecipeIngredient> savedIngredients = RecipeBookDataAccessor.getIngredients(savedRecipe.ID);
ObservableCollection <RecipeStep> savedSteps = RecipeBookDataAccessor.getSteps(savedRecipe.ID);
ObservableCollection <RecipeImage> savedImages = RecipeBookDataAccessor.getImages(savedRecipe.ID);
RecipeJournal savedEntries = RecipeBookDataAccessor.getJournalEntries(savedRecipe.ID);
savedRecipe.setIngredients(savedIngredients);
savedRecipe.setSteps(savedSteps);
savedRecipe.setImages(savedImages);
savedRecipe.setJournalEntries(savedEntries);
}
recipes.setRecipeList(savedRecipes);
}
public RecipeJournal GetRecipeJournal(string executionId)
{
var executionJournal = GetJournalFile(executionId);
var xElement = XElement.Parse(ReadJournal(executionJournal));
var journal = new RecipeJournal {
ExecutionId = executionId
};
var messages = new List <JournalMessage>();
journal.Status = ReadStatusFromJournal(xElement);
foreach (var message in xElement.Elements("Message"))
{
messages.Add(new JournalMessage {
Message = message.Value
});
}
journal.Messages = messages;
return(journal);
}