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 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();
}
}
private static string getDbConnectionString()
{
string retVal = null;
using (NoodleDContext dbContext = new NoodleDContext())
{
retVal = dbContext.Database.Connection.ConnectionString;
}
return(retVal);
}
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 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 addIngredients(NoodleDContext db, Dish dish)
{
// добавить ингредиенты
DishIngredient ingr;
ingr = new DishIngredient()
{
RowGUID = Guid.NewGuid(), Price = 19, DishGUID = dish.RowGUID, RowPosition = 1
};
LangStringLib.SetValues(db, ingr.RowGUID, FieldTypeIDEnum.Name, "Двойной соус терияки", "Подвійний соус теріякі", "Double teriyaki sauce");
db.DishIngredient.Add(ingr);
ingr = new DishIngredient()
{
RowGUID = Guid.NewGuid(), Price = 9, DishGUID = dish.RowGUID, RowPosition = 2
};
LangStringLib.SetValues(db, ingr.RowGUID, FieldTypeIDEnum.Name, "Двойная фасоль стручковая", "Подвійна квасоля стручкова", "Double runner beans");
db.DishIngredient.Add(ingr);
ingr = new DishIngredient()
{
RowGUID = Guid.NewGuid(), Price = 23, DishGUID = dish.RowGUID, RowPosition = 3
};
LangStringLib.SetValues(db, ingr.RowGUID, FieldTypeIDEnum.Name, "Двойная курица", "Подвійна курка", "Double chicken");
db.DishIngredient.Add(ingr);
ingr = new DishIngredient()
{
RowGUID = Guid.NewGuid(), Price = 13, DishGUID = dish.RowGUID, RowPosition = 4
};
LangStringLib.SetValues(db, ingr.RowGUID, FieldTypeIDEnum.Name, "Двойной деревестный гриб", "Подвійний дерев'янистий гриб", "Double tree fungus");
db.DishIngredient.Add(ingr);
ingr = new DishIngredient()
{
RowGUID = Guid.NewGuid(), Price = 18, DishGUID = dish.RowGUID, RowPosition = 5
};
LangStringLib.SetValues(db, ingr.RowGUID, FieldTypeIDEnum.Name, "Двойные грибы шампиньоны", "Подвійні гриби печериці", "Double champignons");
db.DishIngredient.Add(ingr);
}
public static void readSettingFromDB()
{
MessageListener.Instance.ReceiveMessage("Читаю настройки из БД...");
AppLib.WriteLogTraceMessage("Получаю настройки приложения из таблицы Setting ...");
using (NoodleDContext db = new NoodleDContext())
{
try
{
List <Setting> setList = db.Setting.ToList();
List <StringValue> stringTable = db.StringValue.ToList();
foreach (Setting item in setList)
{
// AppLib.WriteLogTraceMessage("- параметр "+ item.UniqName + "...");
AppLib.SetAppGlobalValue(item.UniqName, item.Value);
if (item.UniqName.EndsWith("Color") == true) // преобразовать и переопределить цвета
{
convertAppColor(item.UniqName);
checkAppColor(item.UniqName);
}
if (item.Value == "StringValue") // заменить в Application.Properties строку StringValue на словарь языковых строк
{
Dictionary <string, string> d = getLangTextDict(stringTable, item.RowGUID, 1);
AppLib.SetAppGlobalValue(item.UniqName, d);
}
// AppLib.WriteLogTraceMessage("- параметр " + item.UniqName + "... Ready");
}
}
catch (Exception ex)
{
AppLib.WriteLogErrorMessage(string.Format("Fatal error: {0}\nSource: {1}\nStackTrace: {2}", ex.Message, ex.Source, ex.StackTrace));
appExit(5, "Ошибка доступа к данным: " + ex.Message + "\nПрограмма будет закрыта.");
}
}
AppLib.WriteLogTraceMessage("Получаю настройки приложения из таблицы Setting ... READY");
}
private static void addGarnishes(NoodleDContext db, Dish dish, string[] descrList)
{
byte[] img1 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles1.png");
byte[] img2 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles2.png");
byte[] img3 = ImageHelper.getImageFromFilePath(@"D:\NoodleD\дизайн\NodDod\noodles3.png");
// добавить гарниры
DishGarnish garn;
garn = new DishGarnish()
{
RowGUID = Guid.NewGuid(), Price = 34, DishGUID = dish.RowGUID, RowPosition = 1,
Image = img1, ImageDishWithGarnish = img1
};
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Name, "Яичная лапша", "Яєчна локшина", "Egg noodles");
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Description, descrList[0] + " с гарниром: Яичная лапша", descrList[1] + " з гарнiром: Яєчна локшина", descrList[2] + " with garnish: Egg noodles");
db.DishGarnish.Add(garn);
garn = new DishGarnish()
{
RowGUID = Guid.NewGuid(), Price = 19, DishGUID = dish.RowGUID, RowPosition = 2,
Image = img2, ImageDishWithGarnish = img2
};
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Name, "Рис басмати", "Рис басматі", "Basmati rice");
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Description, descrList[0] + " с гарниром: Рис басмати", descrList[1] + " з гарнiром: Рис басматі", descrList[2] + " with garnish: Basmati rice");
db.DishGarnish.Add(garn);
garn = new DishGarnish()
{
RowGUID = Guid.NewGuid(), Price = 24, DishGUID = dish.RowGUID, RowPosition = 3,
Image = img3, ImageDishWithGarnish = img3
};
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Name, "Стеклянная лапша", "Cкляна локшина", "Glass noodles");
LangStringLib.SetValues(db, garn.RowGUID, FieldTypeIDEnum.Description, descrList[0] + " с гарниром: Стеклянная лапша", descrList[1] + " з гарнiром: Cкляна локшина", descrList[2] + " with garnish: Glass noodles");
db.DishGarnish.Add(garn);
}
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();
}
}
private static DishMark getDishMark(NoodleDContext db, int id)
{
return(db.DishMark.First(dm => dm.Id == id));
}
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]);
}
}
}