//this method is used to load the recipe to the page by using its id private void loadRecipe(int recipeId) { dc = new yummyDatabaseDataContext(); recipe = dc.Recipes.Where(recipe => recipe.RecipeId == recipeId).Single(); if (recipe.Image != null) { bitmapImage = new BitmapImage(); bitmapImage.BeginInit(); bitmapImage.StreamSource = new MemoryStream(recipe.Image.ToArray()); bitmapImage.EndInit(); imgRecipePhoto.Source = bitmapImage; } labelRecipeName.Content = recipe.Name; txtRecipeDescription.Text = recipe.Description; txtRecipePrepTime.Text = recipe.PrepTime.ToString(); txtRecipeServings.Text = recipe.Serving.ToString(); txtRecipeDirections.Text = recipe.Directions; string recipeIngredients = string.Empty; foreach (var recipeIngredient in recipe.RecipeIngredients) { recipeIngredients += $"{recipeIngredient.Quantity} {recipeIngredient.Measurement} {recipeIngredient.Ingredient.Name}\n"; } txtRecipeIngrediensList.Text = recipeIngredients; }
/// <summary> /// method to update the recipe datagrid to reflect database changes /// </summary> private void refreshRecipies() { dc = new yummyDatabaseDataContext(); dgRecipes.ItemsSource = null; // selecting specific columns to display in the recipe datagrid dgRecipes.ItemsSource = dc.Recipes.Select(recipe => new { recipe.RecipeId, recipe.Name, recipe.PrepTime, recipe.Serving, Category = recipe.Category1.CategoryName }).OrderBy(recipe => recipe.Name); }
// method that load the data from the table and set the carousel to the retrieved data private void ShowCategories() { dc = new yummyDatabaseDataContext(); var query = (from Cat in dc.Categories orderby Cat.CategoryName ascending select Cat); catTable = query.ToList(); loadDataToDisplay(catTable); }
// method that load the data from the table and set the carousel to the retrieved data private void ShowRecipes() { dc = new yummyDatabaseDataContext(); var query = (from Rec in dc.Recipes orderby Rec.Name ascending select Rec); recTable = query.ToList(); loadDataToDisplay(recTable); }
// method that load the data from the table and set the carousel to the retrieved data private void ShowCategories() { dc = new yummyDatabaseDataContext(); // query that retrieves only the first 5 elements from the Category table ordered by the Category Name var query = (from Cat in dc.Categories orderby Cat.CategoryName ascending select Cat).Take(5); catTable = query.ToList(); loadDataToDisplay(catTable); // loading the data in a proper format to display }
// method that load the data from the table and set the carousel to the retrieved data private void ShowRecipes() { dc = new yummyDatabaseDataContext(); // query that retrieves only the first 4 elements from the Recipe table ordered by the Name var query = (from Rec in dc.Recipes orderby Rec.Name ascending select Rec).Take(4); recTable = query.ToList(); loadDataToDisplay(recTable); // loading the data in a proper format to display }
public Shopping_Cart() { InitializeComponent(); dc = new yummyDatabaseDataContext(); ShopingLIstGrid.ItemsSource = null; // selecting specific columns to display in the recipe datagrid ShopingLIstGrid.ItemsSource = dc.Recipes.Select(recipe => new { recipe.RecipeId, recipe.Name, recipe.PrepTime, recipe.Serving, Category = recipe.Category1.CategoryName }); }
// refresh the data from the database and load the displayable data private void refreshCategories() { dc = new yummyDatabaseDataContext(); CategoriesCarousel.ItemsSource = null; // selecting specific columns to display in the recipe datagrid var catTab = (from C in dc.Categories orderby C.CategoryName ascending select C); loadDataToDisplay(catTab.ToList()); }
// refresh the data from the database and load the displayable data private void refreshRecipies() { dc = new yummyDatabaseDataContext(); RecipesCarousel.ItemsSource = null; // selecting specific columns to display in the recipe datagrid var recTab = (from R in dc.Recipes orderby R.Name ascending select R); loadDataToDisplay(recTab.ToList()); }
public Catalog() { InitializeComponent(); // instatiating the database connection dc = new yummyDatabaseDataContext(); // load the data to the carousel ShowCategories(); ShowRecipes(); }
// method overloaded to load the data from the categories table, and build an object to display inside the category carousel private void loadDataToDisplay(List <Category> tab) { dc = new yummyDatabaseDataContext(); myCategories = new List <MediaData>(); foreach (var categoryObj in tab) { MediaData cnt = new MediaData(); if (categoryObj.CategoryImage != null) { cnt.ImageData = cnt.ByteArrayToImage(categoryObj.CategoryImage.ToArray()); } cnt.Id = categoryObj.CategoryId; cnt.Title = categoryObj.CategoryName; myCategories.Add(cnt); } CategoriesCarousel.ItemsSource = myCategories; // setting the carousel data }
// method overloaded to load the data from the categories table, and build an object to display inside the category carousel private void loadDataToDisplay(List <Recipe> tab) { dc = new yummyDatabaseDataContext(); myRecipes = new List <MediaData>(); foreach (var recipeObj in tab) { MediaData cnt = new MediaData(); if (recipeObj.Image != null) { cnt.ImageData = cnt.ByteArrayToImage(recipeObj.Image.ToArray()); } cnt.Id = recipeObj.RecipeId; cnt.Title = recipeObj.Name; cnt.Description = recipeObj.Description; myRecipes.Add(cnt); } RecipesCarousel.ItemsSource = myRecipes; }
// method overloaded to load the data from the categories table, and build an object to display inside the category carousel private void loadDataToDisplay(List <Category> tab) { dc = new yummyDatabaseDataContext(); myCategories = new List <MediaData>(); // for each category inside the table build a Media data instance foreach (var categoryObj in tab) { MediaData cnt = new MediaData(); if (categoryObj.CategoryImage != null) { // getting the array of bytes and converting to a displayable image cnt.ImageData = cnt.ByteArrayToImage(categoryObj.CategoryImage.ToArray()); } cnt.Id = categoryObj.CategoryId; cnt.Title = categoryObj.CategoryName; // add instance of MediaData to the list that will be used inside de carousel myCategories.Add(cnt); } CategoriesCarousel.ItemsSource = myCategories; // setting the carousel data }
// method overloaded to load the data from the recipes table, and build an object to display inside the recipe carousel private void loadDataToDisplay(List <Recipe> tab) { dc = new yummyDatabaseDataContext(); myRecipes = new List <MediaData>(); // for each recipe inside the table build a Media data instance foreach (var recipeObj in tab) { MediaData cnt = new MediaData(); if (recipeObj.Image != null) { // getting the array of bytes and converting to a displayable image cnt.ImageData = cnt.ByteArrayToImage(recipeObj.Image.ToArray()); } cnt.Id = recipeObj.RecipeId; cnt.Title = recipeObj.Name; cnt.Description = recipeObj.Description; // add instance of MediaData to the list that will be used inside de carousel myRecipes.Add(cnt); } RecipesCarousel.ItemsSource = myRecipes; // setting the carousel data }