Example #1
0
 private void PopulateFruitGrid()
 {
     using (var db = new MealGeneratorContext())
     {
         gvFruit.DataSource = db.Fruits.ToList();
     }
 }
Example #2
0
        private async void btnAddMeal_ClickAsync(object sender, EventArgs e)
        {
            if (tbMealName.Text == "")
            {
                return;
            }
            List <Ingredient> ingredients = new List <Ingredient>();

            foreach (DataGridViewRow row in gvSelectIngredientsForMeal.Rows)
            {
                if (row.Cells[1].Value != null)
                {
                    ingredients.Add(row.DataBoundItem as Ingredient);
                }
            }
            //move db to presenter
            Meal meal = new Meal()
            {
                Name        = tbMealName.Text,
                IsActive    = true,
                Ingredients = ingredients,
            };

            Meals.Add(meal);

            using (var db = new MealGeneratorContext())
            {
                db.Meals.Add(meal);
                await db.SaveChangesAsync();
            }
        }
 internal async void DeleteMeal(Meal meal)
 {
     using (var db = new MealGeneratorContext())
     {
         db.Meals.Attach(meal);
         db.Meals.Remove(meal);
         await db.SaveChangesAsync();
     }
 }
Example #4
0
 private void btnOpenAddMeal_Click_1(object sender, EventArgs e)
 {
     pnAddMeal.Visible = true;
     using (var db = new MealGeneratorContext())
     {
         List <Ingredient> allIngredients = db.Ingredients.ToList();
         gvSelectIngredientsForMeal.DataSource = allIngredients;
     }
 }
        internal List <Ingredient> GetAllIngredients()
        {
            List <Ingredient> ingredients = new List <Ingredient>();

            using (var db = new MealGeneratorContext())
            {
                ingredients = db.Ingredients.ToList();
            }
            return(ingredients);
        }
        private void SetIngredientsForIngredientGrid()
        {
            List <Ingredient> ingredients = new List <Ingredient>();

            using (var db = new MealGeneratorContext())
            {
                ingredients = db.Ingredients.Include(i => i.Meals).ToList();
            }
            gvIngredients.DataSource = ingredients;
        }
Example #7
0
 public void SetShoppingLists()
 {
     using (var db = new MealGeneratorContext())
     {
         gvShoppingLists.DataSource = db.ShoppingLists
                                      .Include(s => s.Meals)
                                      .Include("Meals.Ingredients")
                                      .Include(s => s.Fruits)
                                      .Include(s => s.MiscItems)
                                      .ToList();
     }
 }
        private void btnRunGenerator_Click(object sender, EventArgs e)
        {
            //getActiveMeals;
            db = new MealGeneratorContext();
            ShoppingList shoppingList = new ShoppingList
            {
                Meals  = GetMeals(),
                Fruits = GetFruit(),
                Date   = dtDateFrom.Value
            };

            db.ShoppingLists.Add(shoppingList);
            db.SaveChanges();
        }
        private BindingList <Meal> GetAllMeals()
        {
            List <Meal> meals = new List <Meal>();

            using (var db = new MealGeneratorContext())
            {
                meals = db.
                        Meals
                        .Include(a => a.Ingredients)
                        .ToList();
            }
            BindingList <Meal> mealBinded = new BindingList <Meal>(meals);

            return(mealBinded);
        }
 public RunGeneratorPanel()
 {
     InitializeComponent();
     gvMeals.AutoGenerateColumns = false;
     gvFruit.AutoGenerateColumns = false;
     if (System.ComponentModel.LicenseManager.UsageMode != System.ComponentModel.LicenseUsageMode.Designtime)
     {
         using (var db = new MealGeneratorContext())
         {
             gvFruit.DataSource = db.Fruits.ToList();
             gvMeals.DataSource = db.Meals.ToList();
         }
         cbNumberOfDays.Items.AddRange(Enumerable.Range(1, 7).Select(i => (object)i).ToArray());
         cbNumberOfFruit.Items.AddRange(Enumerable.Range(1, 5).Select(i => (object)i).ToArray());
     }
 }
Example #11
0
        private async void btnAddFruit_Click(object sender, EventArgs e)
        {
            if (tbFruitName.Text == "")
            {
                return;
            }

            using (var db = new MealGeneratorContext())
            {
                Fruit fruit = new Fruit()
                {
                    Name = tbFruitName.Text
                };
                db.Fruits.Add(fruit);
                await db.SaveChangesAsync();
            }
            PopulateFruitGrid();
        }