Exemplo n.º 1
0
        private void SearchRecipe(string nameCategory)
        {
            //настройка соединения с БД
            SQLite_Android dbPATH   = new SQLite_Android();
            var            db       = new SQLiteConnection(dbPATH.GetDbPath("Cooking.db"));
            List <String>  add      = new List <String>();
            List <String>  Recipe   = new List <String>();
            List <String>  RecipeID = new List <String>();
            Intent         myIntent = new Intent(this, typeof(MaketCategory));

            //поиск по категории блюда
            var ctg = db.Query <Category>("SELECT Category_ID FROM category WHERE Category_name = '" + nameCategory + "';");

            foreach (Category j in ctg)
            {
                var Dish = db.Query <Recipe>("SELECT Recip_ID, Recipe_name, Cooking_method FROM recipe WHERE Rec_Category_ID = " + j.Category_ID + ";");
                foreach (Recipe k in Dish)
                {
                    add.Add(k.Recipe_name);
                    Recipe.Add(k.Cooking_method);
                    RecipeID.Add("r" + k.Recip_ID.ToString());
                }
            }
            myIntent.PutStringArrayListExtra("recipeNAME", add.ToList());
            myIntent.PutStringArrayListExtra("recipeCOOKING", Recipe.ToList());
            myIntent.PutStringArrayListExtra("recipeID", RecipeID.ToList());
            OverridePendingTransition(Resource.Animation.slide_right, Resource.Animation.fade_out);
            StartActivity(myIntent);
        }
Exemplo n.º 2
0
        private void SearchRecipe(string nameCategory, string country, string ingredients)
        {
            //настройка соединения с БД
            SQLite_Android dbPATH = new SQLite_Android();
            var            db     = new SQLiteConnection(dbPATH.GetDbPath("Cooking.db"));

            Intent        myIntent   = new Intent(this, typeof(Maket));
            List <String> nameRecipe = new List <String>();
            List <String> Recipe     = new List <String>();
            List <String> RecipeID   = new List <String>();

            if ((nameCategory != "Не выбрано") && (country != "Не выбрано") && (ingredients != ""))
            {
                //поиск блюда по стране и категории
                Regex    myReg          = new Regex("\\,\\s");
                string[] STRingredients = myReg.Split(ingredients);

                var ctry     = db.Query <Cuisine>("SELECT Cuisine_ID FROM cuisine WHERE Cuisine_name = '" + country + "';");
                var ctg      = db.Query <Category>("SELECT Category_ID FROM category WHERE Category_name = '" + nameCategory + "';");
                int checkING = 0;
                foreach (Cuisine i in ctry)
                {
                    foreach (Category j in ctg)
                    {
                        foreach (string s in STRingredients)
                        {
                            if (s != "")
                            {
                                checkING++;
                                var ingID = db.Query <Ingredient>("SELECT Ingredient_ID FROM ingredient WHERE Ingredient_name = '" + s + "'");
                                foreach (Ingredient ing in ingID)
                                {
                                    var cmpstn = db.Query <Composition>("SELECT Comp_recipe_ID FROM composition WHERE Comp_Ingredient_ID = " + ing.Ingredient_ID + ";");
                                    foreach (Composition c in cmpstn)
                                    {
                                        var Dish = db.Query <Recipe>("SELECT Recip_ID, Rec_Cuisine_ID, Rec_Category_ID, Recipe_name, Cooking_method FROM recipe WHERE Recip_ID = " + c.Comp_recipe_ID + ";");
                                        foreach (Recipe k in Dish)
                                        {
                                            if ((i.Cuisine_ID == k.Rec_Cuisine_ID) && (j.Category_ID == k.Rec_Category_ID) && (checkING == LenghtING(ingredients)))
                                            {
                                                nameRecipe.Add(k.Recipe_name);
                                                Recipe.Add(k.Cooking_method);
                                                RecipeID.Add("r" + k.Recip_ID.ToString());
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
                if (nameRecipe.Count != 0)
                {
                    myIntent.PutStringArrayListExtra("recipeNAME", nameRecipe.ToList());
                    myIntent.PutStringArrayListExtra("recipeCOOKING", Recipe.ToList());
                    myIntent.PutStringArrayListExtra("recipeID", RecipeID.ToList());
                    OverridePendingTransition(Resource.Animation.slide_right, Resource.Animation.fade_out);
                    StartActivity(myIntent);
                }
                else
                {
                    string toast = string.Format("Подходящих рецептов не найдено.");
                    Toast.MakeText(this, toast, ToastLength.Long).Show();
                }
            }
            else
            {
                string toast = string.Format("Некоторые поля не заполнены.");
                Toast.MakeText(this, toast, ToastLength.Long).Show();
            }
        }