public int AddDishesUnit(DishUnit dishesUnit)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities()){
entities.DishUnit.Add(dishesUnit);
entities.SaveChanges();
return(dishesUnit.DishUnitId);
}
}
public bool RemoveDishesUnitById(int dishUnitId)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DishUnit dishUnit = entities.DishUnit.Find(dishUnitId);
if (null != dishUnit)
{
entities.DishUnit.Remove(dishUnit);
}
entities.SaveChanges();
return(true);
}
}
public DishesUnitModel CreateDishUnitBean(DishUnit bean)
{
this.DishUnitId = bean.DishUnitId;
this.Name = bean.Name;
this.SaleType = bean.SaleType;
this.OrderNum = bean.OrderNum;
this.CreateDatetime = bean.CreateDatetime;
this.CreateBy = bean.CreateBy;
this.Deleted = bean.Deleted;
this.Status = bean.Status;
this.UpdateDatetime = bean.UpdateDatetime;
this.UpdateBy = bean.UpdateBy;
return(this);
}
//修改数据
public void UpdateDishesUnit()
{
DishUnit du = DishesUnitModelNew.CreateDishUnit(DishesUnitModelNew);
bool flag = _DishService.UpdateDishUnit(du.DishUnitId, du.Name, du.SaleType, du.OrderNum);
if (flag)
{
Init();
_AddDishUnitWin.Close();
MessageBox.Show("修改成功!");
}
else
{
MessageBox.Show("修改失败!");
}
}
public DishUnit CreateDishUnit(DishesUnitModel bean)
{
DishUnit beanBack = new DishUnit();
beanBack.DishUnitId = bean.DishUnitId;
beanBack.Name = bean.Name;
beanBack.SaleType = bean.SaleType;
beanBack.OrderNum = bean.OrderNum;
beanBack.CreateDatetime = bean.CreateDatetime;
beanBack.CreateBy = bean.CreateBy;
beanBack.Deleted = bean.Deleted;
beanBack.Status = bean.Status;
beanBack.UpdateDatetime = bean.UpdateDatetime;
beanBack.UpdateBy = bean.UpdateBy;
return(beanBack);
}
//根据
public DishBean CreateDishBean(Dish dish)
{
this.AidNumber = dish.AidNumber;
this.Code = dish.Code;
this.CreateBy = dish.CreateBy;
this.CreateDatetime = dish.CreateDatetime;
this.Deleted = dish.Deleted;
this.Detail = dish.Detail;
this.DischesType = dish.DischesType;
this.DiscountConfirm = dish.DiscountConfirm;
this.DishFinanceId = dish.DishFinanceId;
this.DishFormat = dish.DishFormat;
this.DishId = dish.DishId;
this.DishName = dish.DishName;
this.DishTypeId = dish.DishTypeId;
this.DishUnitId = dish.DishUnitId;
this.EnglishName = dish.EnglishName;
this.FoodFight = dish.FoodFight;
this.Img = dish.Img;
this.IsStop = dish.IsStop;
this.KitchenType = dish.KitchenType;
this.LineConfirm = dish.LineConfirm;
this.LowConsumerConfirm = dish.LowConsumerConfirm;
this.PackagesConfirm = dish.PackagesConfirm;
this.PingYing = dish.PingYing;
this.PosConfirm = dish.PosConfirm;
this.PriceTimeConfirm = dish.PriceTimeConfirm;
this.PublisherType = dish.PublisherType;
this.SanpConfirm = dish.SanpConfirm;
this.Status = dish.Status;
this.ServerfreeConsumer = dish.ServerfreeConsumer;
this.UpdateBy = dish.UpdateBy;
this.UpdateDatetime = dish.UpdateDatetime;
this.WeightConfirm = dish.WeightConfirm;
this.DishPrice = dish.DishPrice;
this.DishUnit = dish.DishUnit;
this.DishUnitName = this.DishUnit.Name;
return(this);
}
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]);
}
}
}
