public static void setMainMenu() { string filePath = @"d:\NoodleD\дизайн\testImages\dishCategories\"; MenuFolder mf1, mf2, mf3, mf4, mf5, mf6; using (NoodleDContext db = new NoodleDContext()) { byte[] image1 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Combo.png"); byte[] image1Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Combo_inv.png"); byte[] image2 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Voki.png"); byte[] image2Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Voki_inv.png"); byte[] image3 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Salads.png"); byte[] image3Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Salads_inv.png"); byte[] image4 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Soups.png"); byte[] image4Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Soups_inv.png"); byte[] image5 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Desserts.png"); byte[] image5Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Desserts_inv.png"); byte[] image6 = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Beverages.png"); byte[] image6Inv = ImageHelper.getImageFromFilePath(filePath + "dishCategory_Beverages_inv.png"); mf1 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image1, ImageInv = image1Inv, ParentId = 0, RowPosition = 1 }; mf2 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image2, ImageInv = image2Inv, ParentId = 0, RowPosition = 2 }; mf3 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image3, ImageInv = image3Inv, ParentId = 0, RowPosition = 3 }; mf4 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image4, ImageInv = image4Inv, ParentId = 0, RowPosition = 4 }; mf5 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image5, ImageInv = image5Inv, ParentId = 0, RowPosition = 5 }; mf6 = new MenuFolder() { RowGUID = Guid.NewGuid(), Image = image6, ImageInv = image6Inv, ParentId = 0, RowPosition = 6 }; db.MenuFolder.AddRange(new[] { mf1, mf2, mf3, mf4, mf5, mf6 }); db.SaveChanges(); LangStringLib.SetValues(db, mf1.RowGUID, FieldTypeIDEnum.Name, "Комбо", "Комбо", "Combo"); LangStringLib.SetValues(db, mf2.RowGUID, FieldTypeIDEnum.Name, "Воки", "Вокi", "Vocki"); LangStringLib.SetValues(db, mf3.RowGUID, FieldTypeIDEnum.Name, "Салаты", "Салати", "Salads"); LangStringLib.SetValues(db, mf4.RowGUID, FieldTypeIDEnum.Name, "Супы", "Супи", "Soups"); LangStringLib.SetValues(db, mf5.RowGUID, FieldTypeIDEnum.Name, "Десерты", "Десерти", "Desserts"); LangStringLib.SetValues(db, mf6.RowGUID, FieldTypeIDEnum.Name, "Напитки", "Напої", "Beverages"); db.SaveChanges(); } }
public static void setInrgImages() { string imgPath = @"d:\NoodleD\дизайн\testImages\ингредиенты\"; byte[][] images = new[] { ImageHelper.getImageFromFilePath(imgPath + "соус терияки.jpg"), ImageHelper.getImageFromFilePath(imgPath + "фасоль стручковая.jpg"), ImageHelper.getImageFromFilePath(imgPath + "курица.jpg"), ImageHelper.getImageFromFilePath(imgPath + "деревестный гриб.jpg"), ImageHelper.getImageFromFilePath(imgPath + "грибы шампиньоны.jpg") }; int idx = 0, i = 0; using (NoodleDContext db = new NoodleDContext()) { List <DishIngredient> ingrList = db.DishIngredient.ToList(); foreach (DishIngredient ingr in ingrList) { idx = i % 5; ingr.Image = images[idx]; i++; } db.SaveChanges(); } }
public static void setRecommends() { // добавить ко ВСЕМ блюдам по три случайные рекомендации using (NoodleDContext db = new NoodleDContext()) { List <Dish> dList = db.Dish.ToList(); Random rnd = new Random(); int cnt = db.Dish.Count(), curRnd; foreach (Dish dish in db.Dish) { curRnd = rnd.Next(1, cnt); Dish dRec1 = dList.ElementAt(curRnd); curRnd = rnd.Next(1, cnt); Dish dRec2 = dList.ElementAt(curRnd); curRnd = rnd.Next(1, cnt); Dish dRec3 = dList.ElementAt(curRnd); db.DishRecommends.Add(new DishRecommends() { DishGUID = dish.RowGUID, RecommendGUID = dRec1.RowGUID, RowPosition = 1 }); db.DishRecommends.Add(new DishRecommends() { DishGUID = dish.RowGUID, RecommendGUID = dRec2.RowGUID, RowPosition = 2 }); db.DishRecommends.Add(new DishRecommends() { DishGUID = dish.RowGUID, RecommendGUID = dRec3.RowGUID, RowPosition = 3 }); } db.SaveChanges(); } }
public static void setAppGlobalData() { using (NoodleDContext db = new NoodleDContext()) { db.FieldType.Add(new FieldType() { FieldName = "Name" }); db.FieldType.Add(new FieldType() { FieldName = "Description" }); db.FieldType.Add(new FieldType() { FieldName = "DishUnit" }); db.SaveChanges(); } }
private static void clearData() { using (NoodleDContext db = new NoodleDContext()) { db.DishGarnish.RemoveRange(db.DishGarnish); db.DishIngredient.RemoveRange(db.DishIngredient); db.DishRecommends.RemoveRange(db.DishRecommends); db.SaveChanges(); db.DishMarks.RemoveRange(db.DishMarks); db.SaveChanges(); db.DishMark.RemoveRange(db.DishMark); db.SaveChanges(); db.DishUnit.RemoveRange(db.DishUnit); db.Dish.RemoveRange(db.Dish); db.SaveChanges(); db.Database.ExecuteSqlCommand("dbcc checkident('[DishGarnish]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[DishIngredient]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[DishRecommends]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[DishMarks]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[DishMark]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[DishUnit]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[Dish]', reseed, 0)"); db.StringValue.RemoveRange(db.StringValue); db.MenuFolder.RemoveRange(db.MenuFolder); db.Setting.RemoveRange(db.Setting); db.Terminal.RemoveRange(db.Terminal); db.SaveChanges(); db.Database.ExecuteSqlCommand("dbcc checkident('[StringValue]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[MenuFolder]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[Terminal]', reseed, 0)"); db.OrderDishGarnish.RemoveRange(db.OrderDishGarnish); db.OrderDishIngredient.RemoveRange(db.OrderDishIngredient); db.OrderDish.RemoveRange(db.OrderDish); db.Order.RemoveRange(db.Order); db.SaveChanges(); db.Database.ExecuteSqlCommand("dbcc checkident('[OrderDishGarnish]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[OrderDishIngredient]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[OrderDish]', reseed, 0)"); db.Database.ExecuteSqlCommand("dbcc checkident('[Order]', reseed, 0)"); } }
public static void setGlobalDataFrom1C() { using (NoodleDContext db = new NoodleDContext()) { // едииницы измерения DishUnit unit; // гр unit = new DishUnit() { RowGUID = Guid.NewGuid() }; db.DishUnit.Add(unit); LangStringLib.SetValues(db, unit.RowGUID, FieldTypeIDEnum.UnitName, "г", "г", "gr"); // мл unit = new DishUnit() { RowGUID = Guid.NewGuid() }; db.DishUnit.Add(unit); LangStringLib.SetValues(db, unit.RowGUID, FieldTypeIDEnum.UnitName, "мл", "мл", "ml"); db.SaveChanges(); // добавить маркеры DishMark dm; string filePath = @"d:\NoodleD\дизайн\testImages\dishMarks\"; dm = new DishMark() { RowGUID = Guid.NewGuid(), Image = ImageHelper.getImageFromFilePath(filePath + "chilli.jpg") }; db.DishMark.Add(dm); LangStringLib.SetValues(db, dm.RowGUID, FieldTypeIDEnum.Name, "острый", "гострий", "chilli"); dm = new DishMark() { RowGUID = Guid.NewGuid(), Image = ImageHelper.getImageFromFilePath(filePath + "Red_Apple.jpg") }; LangStringLib.SetValues(db, dm.RowGUID, FieldTypeIDEnum.Name, "вег", "вег", "veg"); db.DishMark.Add(dm); db.SaveChanges(); // глобальные настройки приложения Setting appSet; // главное окно appSet = new Setting() { UniqName = "appBackgroundColor", RowGUID = Guid.NewGuid(), Value = "122,34,104" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "appNotSelectedItemColor", RowGUID = Guid.NewGuid(), Value = "255,255,255" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "appSelectedItemColor", RowGUID = Guid.NewGuid(), Value = "255,200,62" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "mainMenuSelectedItemColor", RowGUID = Guid.NewGuid(), Value = "99,29,85" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "addButtonBackgroundTextColor", RowGUID = Guid.NewGuid(), Value = "173,32,72" }; appSet = new Setting() { UniqName = "addButtonBackgroundPriceColor", RowGUID = Guid.NewGuid(), Value = "147,29,63" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "cartButtonBackgroundColor", RowGUID = Guid.NewGuid(), Value = "214,244,36" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "garnishBackgroundColor", RowGUID = Guid.NewGuid(), Value = "137,137,137" }; db.Setting.Add(appSet); db.SaveChanges(); appSet = new Setting() { UniqName = "langButtonTextUa", RowGUID = Guid.NewGuid(), Value = "Укр" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "langButtonTextRu", RowGUID = Guid.NewGuid(), Value = "Рус" }; db.Setting.Add(appSet); appSet = new Setting() { UniqName = "langButtonTextEn", RowGUID = Guid.NewGuid(), Value = "Eng" }; db.Setting.Add(appSet); db.SaveChanges(); appSet = new Setting() { UniqName = "langButtonDefaultId", RowGUID = Guid.NewGuid(), Value = "ru" }; db.Setting.Add(appSet); db.SaveChanges(); // Главное окно appSet = new Setting() { UniqName = "invitePromoText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Введите промо-код", "Введіть промо-код", "Enter the promo code"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnCreateOrderText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "ОФОРМИТЬ", "ОФОРМИТИ", "MAKE"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnSelectGarnishText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "ВЫБЕРИТЕ ОСНОВУ", "ВИБЕРІТЬ ОСНОВУ", "SELECT BASE"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnSelectDishText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "ДОБАВИТЬ", "ДОДАТИ", "ADD"); db.Setting.Add(appSet); db.SaveChanges(); // всплывашка appSet = new Setting() { UniqName = "formPopUpHeaderText1", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Вы выбрали блюдо", "Ви вибрали блюдо", "You have chosen a dish"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "formPopUpHeaderText2", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Удвоить ингредиенты", "Подвоїти інгредієнти", "Double the ingredients"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "formPopUpHeaderText3", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Рекомендуем к этому блюду", "Рекомендуємо до цієї страви", "We recommend this dish"); db.Setting.Add(appSet); db.SaveChanges(); // корзина appSet = new Setting() { UniqName = "formOrderHeaderText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Вы заказали", "Ви замовили", "You ordered"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnBackToMenuText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Назад к меню", "Назад до меню", "Back to the menu"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnTakeAwayText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "С собой", "З собою", "Take away"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "btnPrintBillText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Распечатать чек", "Роздрукувати чек", "Print receipt"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "lblTotalText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Всего:", "Всього:", "Total:"); db.Setting.Add(appSet); appSet = new Setting() { UniqName = "lblGoText", RowGUID = Guid.NewGuid(), Value = "StringValue" }; LangStringLib.SetValues(db, appSet.RowGUID, FieldTypeIDEnum.Name, "Подходите с чеком к кассе для оплаты", "Підходьте з чеком до каси для оплати", "Come with a check to the cashier for payment"); db.Setting.Add(appSet); db.SaveChanges(); } }
public static void setDishesTestData() { MenuFolder m1; int unitCount; decimal dishPrice; int menuItemId, cnt; string[] namesList, descrList; Guid dUnitGuid1, dUnitGuid2; Guid dMarkGuid1, dMarkGuid2; Random rnd = new Random(); int r; string imgPath = @"D:\NoodleD\дизайн\изображения блюд от 22.12.2016\изм\"; // 20 изображений блюд byte[][] imagesDish = new[] { ImageHelper.getImageFromFilePath(imgPath + "EmptyName-1.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-3.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-5.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-7.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-9.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-11.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-13.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-15.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-17.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-19.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-21.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-23.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-25.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-29.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-31.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-33.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-34.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-35.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-37.jpg"), ImageHelper.getImageFromFilePath(imgPath + "EmptyName-39.jpg") }; byte[] imageNoodles1 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles1.png"); byte[] imageNoodles2 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles2.png"); byte[] imageNoodles3 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles3.png"); byte[] imageSalad1 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\salad1.png"); byte[] imageSalad2 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\salad2.png"); byte[] imageDessert1 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-44.jpg"); byte[] imageDessert2 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-45.jpg"); byte[] imageDessert3 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-46.jpg"); byte[] imageBeverage1 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-49.jpg"); byte[] imageBeverage2 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-50.jpg"); byte[] imageBeverage3 = ImageHelper.getImageFromFilePath(imgPath + "EmptyName-51.jpg"); // блюда для первого пункта меню (Комбо) namesList = new string[] { "Курица Кунпао", "Куриця Кунпао", "Cunpao chicken" }; descrList = new string[] { "Перец болгарский, фасоль стручковая, перец чили, арахис, лук зеленый", "Перець болгарський, фасоль стручкова, перець чiлi, арахiс, лук зелений", "Bell peppers, green beans, chili, peanuts, green onion" }; menuItemId = 1; cnt = 7; unitCount = 400; dishPrice = 30; using (NoodleDContext db = new NoodleDContext()) { // единицы измерения dUnitGuid1 = db.DishUnit.ToList().ElementAt(0).RowGUID; // гр dUnitGuid2 = db.DishUnit.ToList().ElementAt(1).RowGUID; // мл // маркеры dMarkGuid1 = db.DishMark.ToList().ElementAt(0).RowGUID; // перчик dMarkGuid2 = db.DishMark.ToList().ElementAt(1).RowGUID; // яблочко m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid1, Price = dishPrice, RowPosition = i }; r = rnd.Next(1, 20); dish.Image = imagesDish[r]; db.Dish.Add(dish); db.SaveChanges(); // добавить к блюду маркеры r = rnd.Next(1, 4); if (r == 2) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid1 }); } else if (r == 3) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid2 }); } else if (r == 4) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid1 }); db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid2 }); } db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // блюда для второго пункта меню (Воки) menuItemId = 2; cnt = 14; unitCount = 300; dishPrice = 30; using (NoodleDContext db = new NoodleDContext()) { // маркеры dMarkGuid1 = db.DishMark.ToList().ElementAt(0).RowGUID; // перчик dMarkGuid2 = db.DishMark.ToList().ElementAt(1).RowGUID; // яблочко m1 = db.MenuFolder.First(m => m.Id == menuItemId); DishUnit dUnit = db.DishUnit.ToList().ElementAt(0); // гр for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid1, Price = dishPrice, RowPosition = i }; r = rnd.Next(1, 20); dish.Image = imagesDish[r]; db.Dish.Add(dish); db.SaveChanges(); // добавить к блюду маркеры r = rnd.Next(1, 4); if (r == 2) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid1 }); } else if (r == 3) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid2 }); } else if (r == 4) { db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid1 }); db.DishMarks.Add(new DishMarks() { DishGUID = dish.RowGUID, MarkGUID = dMarkGuid2 }); } db.SaveChanges(); // добавить к блюду ВСЕ гарниры addGarnishes(db, dish, descrList); // добавить к блюду ВСЕ ингредиенты addIngredients(db, dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // блюда для третьего пункта меню (Салаты) namesList = new string[] { "Салат с крабовыми палочками «Красти»", "Салат с крабовими паличками «Крастi»", "Salad with crab \"Krusty\" sticks" }; descrList = new string[] { "Всем знакомый и очень любимый, простой салат с крабовыми палочками, кукурузой и рисом для праздников и неожиданных гостей", "Всім знайомий і дуже коханий, простий салат з крабовими паличками, кукурудзою і рисом для свят і несподіваних гостей", "All the familiar and much loved, a simple salad with crab sticks, corn and rice for holidays and unexpected guests" }; menuItemId = 3; cnt = 4; unitCount = 250; dishPrice = 50; using (NoodleDContext db = new NoodleDContext()) { m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid1, Price = dishPrice, RowPosition = i }; dish.Image = imageSalad1; db.Dish.Add(dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // салаты БЕЗ ингредиентов namesList = new string[] { "Салат «Старый год»", "Салат «Старий рiк»", "Salad \"Old Year\"" }; descrList = new string[] { "С простым рецептом салата «Старый год» не придется долго возиться. Этот аппетитный салатик порадует ваших гостей своим вкусом, а вас простотой приготовления", "З простим рецептом салату «Старий рік» не доведеться довго возитися. Цей апетитний салатик порадує ваших гостей своїм смаком, а вас простотою приготування", "With a simple recipe salad \"old year\" will not have to mess around for a long time. This delicious salad will delight your guests with your taste and your cooking easy" }; menuItemId = 3; cnt = 2; unitCount = 300; dishPrice = 60; using (NoodleDContext db = new NoodleDContext()) { m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid1, Price = dishPrice, RowPosition = i }; dish.Image = imageSalad2; db.Dish.Add(dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // блюда для четвертого пункта меню (Супы) namesList = new string[] { "Суп-лапша с курицей «По-домашнему»", "Суп-локшина з куркою «По-домашньому»", "Noodle soup with chicken \"Home-style\"" }; descrList = new string[] { "Вкусный куриный суп с домашней лапшой наполнит ваш дом ароматами тепла и уюта", "Смачний курячий суп з домашньою локшиною наповнить ваш будинок ароматами тепла і затишку", "Tasty chicken soup with homemade noodles fill your home with warmth and comfort flavors" }; menuItemId = 4; cnt = 5; unitCount = 300; dishPrice = 44; using (NoodleDContext db = new NoodleDContext()) { m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid2, Price = dishPrice, RowPosition = i }; switch ((i + 1) % 3) { case 0: dish.Image = imageNoodles3; break; case 1: dish.Image = imageNoodles1; break; case 2: dish.Image = imageNoodles2; break; default: break; } db.Dish.Add(dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // блюда для пятого пункта меню (Десерты) namesList = new string[] { "Запеченные яблоки в духовке", "Запечені яблука в духовці", "Baked apples in the oven" }; descrList = new string[] { "Запеченные яблоки в духовке, это хит каждой осени и самый полезный десерт для всех возрастов. А приготовить их сможет каждая хозяйка", "Запечені яблука в духовці, це хіт кожної осені та найкорисніший десерт для будь-якого віку. А приготувати їх зможе кожна господиня", "Baked apples in the oven, it's a hit every autumn and most useful dessert for all ages. And they will be able to cook every woman" }; menuItemId = 5; cnt = 3; unitCount = 400; dishPrice = 30; using (NoodleDContext db = new NoodleDContext()) { m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid1, Price = dishPrice, RowPosition = i }; switch (i % 3) { case 0: dish.Image = imageDessert1; break; case 1: dish.Image = imageDessert2; break; case 2: dish.Image = imageDessert3; break; default: break; } db.Dish.Add(dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } // блюда для шестого пункта меню (Напитки) namesList = new string[] { "Бананово-шоколадний коктейль", "Бананово-шоколадний коктейль", "Banana-chocolate cocktail" }; menuItemId = 6; cnt = 4; unitCount = 350; dishPrice = 30; using (NoodleDContext db = new NoodleDContext()) { m1 = db.MenuFolder.First(m => m.Id == menuItemId); for (int i = 0; i < cnt; i++) { Dish dish = new Dish() { MenuFolderGUID = m1.RowGUID, RowGUID = Guid.NewGuid(), UnitCount = unitCount, UnitGUID = dUnitGuid2, Price = dishPrice, RowPosition = i }; switch (i % 3) { case 0: dish.Image = imageBeverage1; break; case 1: dish.Image = imageBeverage2; break; case 2: dish.Image = imageBeverage3; break; default: break; } db.Dish.Add(dish); db.SaveChanges(); // наименование LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Name, namesList[0], namesList[1], namesList[2]); // описание LangStringLib.SetValues(db, dish.RowGUID, FieldTypeIDEnum.Description, descrList[0], descrList[1], descrList[2]); } } }