private void btnNewIngredient_Click(object sender, RoutedEventArgs e) { NewIngritiant win = new NewIngritiant(); win.ShowDialog(); WpfApplication1.FoodProjectDataSet foodProjectDataSet = ((WpfApplication1.FoodProjectDataSet)(this.FindResource("foodProjectDataSet"))); WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter foodProjectDataSetIngredientTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter(); foodProjectDataSetIngredientTableAdapter.Fill(foodProjectDataSet.Ingredient); //async this.ShowMessageAsync("This is the title", "Some message");//Virkar ekki. }
private void Window_Loaded(object sender, RoutedEventArgs e) { int rid = (int)App.Current.Properties["rid"]; WpfApplication1.FoodProjectDataSet foodProjectDataSet = ((WpfApplication1.FoodProjectDataSet)(this.FindResource("foodProjectDataSet"))); foodProjectDataSet.EnforceConstraints = false; //Tek af constraints // Measure WpfApplication1.FoodProjectDataSetTableAdapters.MeasureTableAdapter foodProjectDataSetMeasureTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.MeasureTableAdapter(); foodProjectDataSetMeasureTableAdapter.Fill(foodProjectDataSet.Measure); //System.Windows.Data.CollectionViewSource measureViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("measureViewSource"))); //measureViewSource.View.MoveCurrentToFirst(); // Ingredient WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter foodProjectDataSetIngredientTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter(); foodProjectDataSetIngredientTableAdapter.Fill(foodProjectDataSet.Ingredient); //System.Windows.Data.CollectionViewSource ingredientViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("ingredientViewSource"))); //ingredientViewSource.View.MoveCurrentToFirst(); // Recipe WpfApplication1.FoodProjectDataSetTableAdapters.RecipeTableAdapter foodProjectDataSetRecipeTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.RecipeTableAdapter(); foodProjectDataSetRecipeTableAdapter.FillByRid(foodProjectDataSet.Recipe, rid); System.Windows.Data.CollectionViewSource recipeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("recipeViewSource"))); recipeViewSource.View.MoveCurrentToFirst(); // MainRecipeDetails WpfApplication1.FoodProjectDataSetTableAdapters.MainRecipeDetailsTableAdapter foodProjectDataSetMainRecipeDetailsTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.MainRecipeDetailsTableAdapter(); foodProjectDataSetMainRecipeDetailsTableAdapter.FillByRid(foodProjectDataSet.MainRecipeDetails, rid); System.Windows.Data.CollectionViewSource mainRecipeDetailsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("mainRecipeDetailsViewSource"))); mainRecipeDetailsViewSource.View.MoveCurrentToFirst(); // CuisineInfo WpfApplication1.FoodProjectDataSetTableAdapters.CuisineInfoTableAdapter foodProjectDataSetCuisineInfoTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.CuisineInfoTableAdapter(); foodProjectDataSetCuisineInfoTableAdapter.FillByCuisineInfo(foodProjectDataSet.CuisineInfo, rid); System.Windows.Data.CollectionViewSource cuisineInfoViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("cuisineInfoViewSource"))); cuisineInfoViewSource.View.MoveCurrentToFirst(); // Cuisine WpfApplication1.FoodProjectDataSetTableAdapters.CuisineTableAdapter foodProjectDataSetCuisineTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.CuisineTableAdapter(); foodProjectDataSetCuisineTableAdapter.Fill(foodProjectDataSet.Cuisine); //System.Windows.Data.CollectionViewSource cuisineViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("cuisineViewSource"))); //cuisineViewSource.View.MoveCurrentToFirst(); string currentImage = foodProjectDataSetRecipeTableAdapter.GetImageUrl(rid); App.Current.Properties["image_url"] = currentImage; App.Current.Properties["isDeleted"] = isDeleted; unsavedChanges = false; }
private void UpdateWindow() { try { WpfApplication1.FoodProjectDataSet foodProjectDataSet = ((WpfApplication1.FoodProjectDataSet)(this.FindResource("foodProjectDataSet"))); foodProjectDataSet.EnforceConstraints = false; // Load data into the table Recipe. You can modify this code as needed. WpfApplication1.FoodProjectDataSetTableAdapters.RecipeTableAdapter foodProjectDataSetRecipeTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.RecipeTableAdapter(); foodProjectDataSetRecipeTableAdapter.Fill(foodProjectDataSet.Recipe); System.Windows.Data.CollectionViewSource recipeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("recipeViewSource"))); recipeViewSource.View.MoveCurrentToFirst(); // Load data into the table Cuisine. You can modify this code as needed. WpfApplication1.FoodProjectDataSetTableAdapters.CuisineTableAdapter foodProjectDataSetCuisineTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.CuisineTableAdapter(); foodProjectDataSetCuisineTableAdapter.Fill(foodProjectDataSet.Cuisine); System.Windows.Data.CollectionViewSource cuisineViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("cuisineViewSource"))); cuisineViewSource.View.MoveCurrentToFirst(); // Load data into the table Category. You can modify this code as needed. WpfApplication1.FoodProjectDataSetTableAdapters.CategoryTableAdapter foodProjectDataSetCategoryTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.CategoryTableAdapter(); foodProjectDataSetCategoryTableAdapter.Fill(foodProjectDataSet.Category); System.Windows.Data.CollectionViewSource categoryViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("categoryViewSource"))); categoryViewSource.View.MoveCurrentToFirst(); // Load data into the table Ingredient. You can modify this code as needed. WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter foodProjectDataSetIngredientTableAdapter = new WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter(); foodProjectDataSetIngredientTableAdapter.Fill(foodProjectDataSet.Ingredient); System.Windows.Data.CollectionViewSource categoryIngredientViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("categoryIngredientViewSource"))); categoryIngredientViewSource.View.MoveCurrentToFirst(); } catch (Exception ex) { MessageBox.Show("Villa í Update"); } }
private void btnAddIngredient_Click(object sender, RoutedEventArgs e) { try { WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter ita = new WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter(); WpfApplication1.FoodProjectDataSetTableAdapters.Recipe_IngredientTableAdapter rita = new FoodProjectDataSetTableAdapters.Recipe_IngredientTableAdapter(); WpfApplication1.FoodProjectDataSetTableAdapters.MeasureTableAdapter mta = new FoodProjectDataSetTableAdapters.MeasureTableAdapter(); // Skilgreini DataRowView til þess að geta náð í measureID úr comboboxi DataRowView dv = (DataRowView)cbMeasure.SelectedItem; if (dv != null) { // Næ í iid, rid og mid fyrir Recipe_Ingredient Insert Query int iid = (int)ita.GetIidByName(txtIngredient.Text); int rid = (int)App.Current.Properties["rid"]; int mid = (int)dv["mid"]; rita.Insert(rid, iid, double.Parse(txtQuantity.Text), mid); UpdateDataGrid(); try { string root = AppDomain.CurrentDomain.BaseDirectory; // Bý til myndina BitmapImage imgC = new BitmapImage(); imgC.BeginInit(); imgC.UriSource = new Uri(root + @"\check20w.png"); imgC.DecodePixelWidth = 20; imgC.EndInit(); // Set myndina inn í rétt image í xamlinu og bæti texta í label imgCheck.Source = imgC; lblCheck.Content = "Hráefni hefur verið bætt við uppskrift."; // Kalla á timer sem núllstillir image og label TimerTest(); } catch (FileNotFoundException) { } } else { MessageBox.Show("Vinsamlegast veljið Mælieiningu."); } } catch (NullReferenceException) { MessageBox.Show("Vinsamlegast veljið hráefni."); } catch (InvalidOperationException) { MessageBox.Show("Vinsamlegast veljið hráefni."); } catch (FormatException) { MessageBox.Show("Vinamlegast sláið inn magn."); } catch (Exception) // Á að vera SQLException en það virkar ekki. { MessageBox.Show("Villa kom upp. Ekki tókst að skrá hráefni"); } }
private void RemoveIngredient_Click(object sender, RoutedEventArgs e) { try { WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter ita = new WpfApplication1.FoodProjectDataSetTableAdapters.IngredientTableAdapter(); WpfApplication1.FoodProjectDataSetTableAdapters.Recipe_IngredientTableAdapter rita = new FoodProjectDataSetTableAdapters.Recipe_IngredientTableAdapter(); DataRowView dv = (DataRowView)mainRecipeDetailsDataGrid.SelectedItem; if (dv != null) { int rid = (int)dv["rid"]; int iid = (int)ita.GetIidByName(dv["Ingredients"].ToString()); rita.RemoveIngredient(rid, iid); UpdateDataGrid(); MessageBox.Show("Hráefni fjarlægt úr uppskrift!"); } } catch (Exception) { } }