private void button1_Click(object sender, RoutedEventArgs e)
{
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
DishProduct dp = new DishProduct()
{
DId = AddDish.d.DishID, Product = l[SelectedIndex], Quantity = Convert.ToInt32(textBox1.Text)
};
AddDish.d.DishProducts.Add(dp);
NavigationService.Navigate(new Uri("/AddDish.xaml", UriKind.Relative));
}
}
// Constructor
public MainPage()
{
InitializeComponent();
using (MyDataContext Db = new MyDataContext(strConnectionString))
{
// Db.DeleteDatabase();
if (Db.DatabaseExists() == false)
{
Db.CreateDatabase();
//inserting in ideal parameters table
List <IdealParameter> ii = new List <IdealParameter>();
ii.Add(new IdealParameter(152.5, 155, 47.8, 49.2, "F", 0));
ii.Add(new IdealParameter(155, 157, 49.2, 50.8, "F", 0));
ii.Add(new IdealParameter(157, 160, 50.8, 52.1, "F", 0));
ii.Add(new IdealParameter(160, 162, 52.1, 53.8, "F", 0));
ii.Add(new IdealParameter(162, 165, 53.8, 55.3, "F", 0));
ii.Add(new IdealParameter(165, 167, 55.3, 56.6, "F", 0));
ii.Add(new IdealParameter(167, 170, 56.6, 57.8, "F", 0));
ii.Add(new IdealParameter(170, 172, 57.8, 59, "F", 0));
ii.Add(new IdealParameter(172, 175, 59, 60.3, "F", 0));
ii.Add(new IdealParameter(175, 177, 60.3, 61.5, "F", 0));
ii.Add(new IdealParameter(177, 180, 61.5, 62.7, "F", 0));
ii.Add(new IdealParameter(152.5, 155, 54, 55.2, "F", 1));
ii.Add(new IdealParameter(155, 157, 55.2, 57, "F", 1));
ii.Add(new IdealParameter(157, 160, 57, 58.5, "F", 1));
ii.Add(new IdealParameter(160, 162, 58.5, 60.1, "F", 1));
ii.Add(new IdealParameter(162, 165, 60.1, 61.8, "F", 1));
ii.Add(new IdealParameter(165, 167, 61.8, 63, "F", 1));
ii.Add(new IdealParameter(167, 170, 63, 64, "F", 1));
ii.Add(new IdealParameter(170, 172, 64, 65.2, "F", 1));
ii.Add(new IdealParameter(172, 175, 65.2, 66.5, "F", 1));
ii.Add(new IdealParameter(175, 177, 61.5, 67.7, "F", 1));
ii.Add(new IdealParameter(177, 180, 62.7, 68.9, "F", 1));
ii.Add(new IdealParameter(152.5, 155, 59, 61.6, "F", 2));
ii.Add(new IdealParameter(155, 157, 61.6, 63.1, "F", 2));
ii.Add(new IdealParameter(157, 160, 63.1, 64.8, "F", 2));
ii.Add(new IdealParameter(160, 162, 64.8, 66.3, "F", 2));
ii.Add(new IdealParameter(162, 165, 66.3, 67.8, "F", 2));
ii.Add(new IdealParameter(165, 167, 67.8, 69, "F", 2));
ii.Add(new IdealParameter(167, 170, 69, 70, "F", 2));
ii.Add(new IdealParameter(170, 172, 70, 71.2, "F", 2));
ii.Add(new IdealParameter(172, 175, 71.2, 72.5, "F", 2));
ii.Add(new IdealParameter(175, 177, 72.5, 73.3, "F", 2));
ii.Add(new IdealParameter(177, 180, 73.3, 74.9, "F", 2));
ii.Add(new IdealParameter(155, 157.5, 49.3, 51.7, "M", 0));
ii.Add(new IdealParameter(157.5, 160, 51.7, 53.5, "M", 0));
ii.Add(new IdealParameter(160, 162.5, 53.5, 55.3, "M", 0));
ii.Add(new IdealParameter(162.5, 165, 55.3, 57.1, "M", 0));
ii.Add(new IdealParameter(165, 167.5, 57.1, 59.3, "M", 0));
ii.Add(new IdealParameter(167.5, 170, 59.3, 60.5, "M", 0));
ii.Add(new IdealParameter(170, 172, 60.5, 63.3, "M", 0));
ii.Add(new IdealParameter(172, 175, 63.3, 63.3, "M", 0));
ii.Add(new IdealParameter(175, 177.5, 63.3, 67.3, "M", 0));
ii.Add(new IdealParameter(177.5, 180, 67.3, 68.9, "M", 0));
ii.Add(new IdealParameter(180, 182.5, 68.9, 70.9, "M", 0));
ii.Add(new IdealParameter(182.5, 185, 70.9, 72.8, "M", 0));
ii.Add(new IdealParameter(155, 157.5, 56, 58, "M", 1));
ii.Add(new IdealParameter(157.5, 160, 58, 60, "M", 1));
ii.Add(new IdealParameter(160, 162.5, 60, 61.7, "M", 1));
ii.Add(new IdealParameter(162.5, 165, 61.7, 63.5, "M", 1));
ii.Add(new IdealParameter(165, 167.5, 63.5, 65.8, "M", 1));
ii.Add(new IdealParameter(167.5, 170, 65.8, 67.8, "M", 1));
ii.Add(new IdealParameter(170, 172, 67.8, 69.7, "M", 1));
ii.Add(new IdealParameter(172, 175, 69.7, 71.7, "M", 1));
ii.Add(new IdealParameter(175, 177.5, 71.7, 73.8, "M", 1));
ii.Add(new IdealParameter(177.5, 180, 73.8, 75.2, "M", 1));
ii.Add(new IdealParameter(180, 182.5, 75.2, 77.2, "M", 1));
ii.Add(new IdealParameter(182.5, 185, 77.2, 79.2, "M", 1));
ii.Add(new IdealParameter(155, 157.5, 62.2, 64, "M", 2));
ii.Add(new IdealParameter(157.5, 160, 64, 66, "M", 2));
ii.Add(new IdealParameter(160, 162.5, 66, 68, "M", 2));
ii.Add(new IdealParameter(162.5, 165, 68, 69.5, "M", 2));
ii.Add(new IdealParameter(165, 167.5, 69.5, 71.8, "M", 2));
ii.Add(new IdealParameter(167.5, 170, 71.8, 73.8, "M", 2));
ii.Add(new IdealParameter(170, 172, 73.8, 76.8, "M", 2));
ii.Add(new IdealParameter(172, 175, 76.8, 77.8, "M", 2));
ii.Add(new IdealParameter(175, 177.5, 77.8, 79.8, "M", 2));
ii.Add(new IdealParameter(177.5, 180, 79.8, 81.2, "M", 2));
ii.Add(new IdealParameter(180, 182.5, 81.2, 83.6, "M", 2));
ii.Add(new IdealParameter(182.5, 185, 83.6, 85.2, "M", 2));
Db.IdealParameters.InsertAllOnSubmit(ii);
Db.SubmitChanges();
List <Product> products = new List <Product>();
Product p1 = new Product("Баклажаны", 0, 1.2, 0.1, 7.1, 24, 0, 15.1, 0);
products.Add(p1);
Product p2 = new Product("Морковь", 0, 1.3, 0.1, 9.3, 34, 0, 15.1, 0);
products.Add(p2);
Product p3 = new Product("Огурцы свежие", 0, 0.8, 0.1, 3.8, 14, 0, 13.5, 0);
products.Add(p3);
Product p4 = new Product("Салат", 0, 1.5, 0.2, 3.1, 17, 0, 14.2, 0);
products.Add(p4);
Product p5 = new Product("Шампиньоны", 0, 4.3, 1, 1, 27, 0, 3.5, 0);
products.Add(p5);
Product p6 = new Product("Творог нежирный", 2, 18, 0.6, 1.8, 88, 0, 1.7, 0);
products.Add(p6);
Product p7 = new Product("Свинина", 3, 14.3, 33, 0, 357, 0, 12.47, 0);
products.Add(p7);
Product p8 = new Product("Говядина", 3, 18.6, 16, 0, 218, 0, 38.61, 0);
products.Add(p8);
Product p9 = new Product("Филе куриное", 3, 23.6, 1.9, 0.4, 113, 0, 24.32, 0);
products.Add(p9);
Product p10 = new Product("Яйцо куриное", 1, 12.7, 11.5, 0.7, 157, 0, 11.16, 1);
products.Add(p10);
Product p11 = new Product("Масло оливковое", 1, 0, 99.8, 0, 898, 0, 6.1, 2);
products.Add(p10);
Db.Products.InsertAllOnSubmit(products);
Db.SubmitChanges();
Dish d1 = new Dish("Салат овощной", 0, 200, 0);
Db.Dishes.InsertOnSubmit(d1);
Db.SubmitChanges();
DishProduct dp = new DishProduct()
{
DId = d1.DishID, Product = p2, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d1.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d1.DishID, Product = p3, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d1.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d1.DishID, Product = p4, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d1.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d1.DishID, Product = p11, Quantity = 20
};
Db.DishProducts.InsertOnSubmit(dp);
d1.DishProducts.Add(dp);
Db.SubmitChanges();
Dish d2 = new Dish("Рагу овощное", 1, 200, 0);
Db.Dishes.InsertOnSubmit(d2);
Db.SubmitChanges();
dp = new DishProduct()
{
DId = d2.DishID, Product = p1, Quantity = 200
};
Db.DishProducts.InsertOnSubmit(dp);
d2.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d2.DishID, Product = p2, Quantity = 300
};
Db.DishProducts.InsertOnSubmit(dp);
d2.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d2.DishID, Product = p11, Quantity = 20
};
Db.DishProducts.InsertOnSubmit(dp);
d2.DishProducts.Add(dp);
Db.SubmitChanges();
Dish d3 = new Dish("Рагу мясное", 3, 200, 0);
Db.Dishes.InsertOnSubmit(d3);
Db.SubmitChanges();
dp = new DishProduct()
{
DId = d3.DishID, Product = p2, Quantity = 200
};
Db.DishProducts.InsertOnSubmit(dp);
d3.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d3.DishID, Product = p5, Quantity = 150
};
Db.DishProducts.InsertOnSubmit(dp);
d3.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d3.DishID, Product = p8, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d3.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d3.DishID, Product = p11, Quantity = 30
};
Db.DishProducts.InsertOnSubmit(dp);
d3.DishProducts.Add(dp);
Db.SubmitChanges();
Dish d4 = new Dish("Салат с курицей", 3, 150, 0);
Db.Dishes.InsertOnSubmit(d4);
Db.SubmitChanges();
dp = new DishProduct()
{
DId = d4.DishID, Product = p4, Quantity = 200
};
Db.DishProducts.InsertOnSubmit(dp);
d4.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d4.DishID, Product = p5, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d4.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d4.DishID, Product = p9, Quantity = 100
};
Db.DishProducts.InsertOnSubmit(dp);
d4.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d4.DishID, Product = p11, Quantity = 10
};
Db.DishProducts.InsertOnSubmit(dp);
d4.DishProducts.Add(dp);
Db.SubmitChanges();
Dish d5 = new Dish("Котлеты морковные", 1, 80, 0);
Db.Dishes.InsertOnSubmit(d5);
Db.SubmitChanges();
dp = new DishProduct()
{
DId = d5.DishID, Product = p2, Quantity = 300
};
Db.DishProducts.InsertOnSubmit(dp);
d5.DishProducts.Add(dp);
dp = new DishProduct()
{
DId = d5.DishID, Product = p10, Quantity = 20
};
Db.DishProducts.InsertOnSubmit(dp);
d5.DishProducts.Add(dp);
Db.SubmitChanges();
List <Ration> r = new List <Ration>();
r.Add(new Ration {
Time = "9:00", DayWeek = 0, WeightDish = 80, Dish = d5
});
r.Add(new Ration {
Time = "9:00", DayWeek = 0, WeightDish = 100, Dish = d1
});
r.Add(new Ration {
Time = "12:00", DayWeek = 0, WeightDish = 150, Dish = d3
});
r.Add(new Ration {
Time = "12:00", DayWeek = 0, WeightDish = 80, Dish = d5
});
r.Add(new Ration {
Time = "18:00", DayWeek = 0, WeightDish = 200, Dish = d4
});
r.Add(new Ration {
Time = "9:00", DayWeek = 1, WeightDish = 80, Dish = d5
});
r.Add(new Ration {
Time = "9:00", DayWeek = 1, WeightDish = 150, Dish = d2
});
r.Add(new Ration {
Time = "12:00", DayWeek = 1, WeightDish = 100, Dish = d4
});
r.Add(new Ration {
Time = "12:00", DayWeek = 1, WeightDish = 80, Dish = d5
});
r.Add(new Ration {
Time = "18:00", DayWeek = 1, WeightDish = 200, Dish = d1
});
r.Add(new Ration {
Time = "9:00", DayWeek = 2, WeightDish = 100, Dish = d1
});
r.Add(new Ration {
Time = "9:00", DayWeek = 2, WeightDish = 150, Dish = d3
});
r.Add(new Ration {
Time = "12:00", DayWeek = 2, WeightDish = 100, Dish = d4
});
r.Add(new Ration {
Time = "12:00", DayWeek = 2, WeightDish = 100, Dish = d2
});
r.Add(new Ration {
Time = "18:00", DayWeek = 2, WeightDish = 100, Dish = d1
});
r.Add(new Ration {
Time = "18:00", DayWeek = 2, WeightDish = 80, Dish = d5
});
Db.Rations.InsertAllOnSubmit(r);
Db.SubmitChanges();
List <DietApp_.Action> a = new List <DietApp_.Action>();
DietApp_.Action a1 = new DietApp_.Action {
Name = "Бег", Energy = 8.14
};
DietApp_.Action a2 = new DietApp_.Action {
Name = "Ходьба", Energy = 3.08
};
DietApp_.Action a3 = new DietApp_.Action {
Name = "Плавание", Energy = 8.8
};
DietApp_.Action a4 = new DietApp_.Action {
Name = "Теннис", Energy = 6.16
};
DietApp_.Action a5 = new DietApp_.Action {
Name = "Катание на коньках", Energy = 4.62
};
DietApp_.Action a6 = new DietApp_.Action {
Name = "Настольный теннис", Energy = 5.5
};
DietApp_.Action a7 = new DietApp_.Action {
Name = "Езда на велосипеде", Energy = 3.52
};
a.Add(a1);
a.Add(a2);
a.Add(a3);
a.Add(a4);
a.Add(a5);
a.Add(a6);
a.Add(a7);
Db.Actions.InsertAllOnSubmit(a);
Db.SubmitChanges();
Schedule s = new Schedule {
DayWeek = 0, Time = "10:00", Action = a2, Duration = 30
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a2;
Db.SubmitChanges();
s = new Schedule {
DayWeek = 0, Time = "06:00", Action = a1, Duration = 25
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a1;
Db.SubmitChanges();
s = new Schedule {
DayWeek = 1, Time = "06:00", Action = a1, Duration = 30
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a1;
Db.SubmitChanges();
s = new Schedule {
DayWeek = 1, Time = "11:00", Action = a7, Duration = 60
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a7;
Db.SubmitChanges();
s = new Schedule {
DayWeek = 2, Time = "19:00", Action = a3, Duration = 45
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a3;
Db.SubmitChanges();
s = new Schedule {
DayWeek = 2, Time = "15:00", Action = a4, Duration = 30
};
Db.Schedules.InsertOnSubmit(s);
Db.SubmitChanges();
s.Action = a3;
Db.SubmitChanges();
List <Product> l = new List <Product>();
Diet diet1 = new Diet("Без диеты", 0);
d = diet1;
Db.Diets.InsertOnSubmit(diet1);
Db.SubmitChanges();
Diet diet2 = new Diet("Диета №1", 30);
Db.Diets.InsertOnSubmit(diet2);
Db.SubmitChanges();
DietProduct dpr = new DietProduct {
DId = diet2.DietID, Product = p1
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p2
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p3
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p4
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p5
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p6
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p9
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p10
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p11
};
Db.DietProducts.InsertOnSubmit(dpr);
diet2.DietProducts.Add(dpr);
Db.SubmitChanges();
diet2 = new Diet("Диета №2", 60);
Db.Diets.InsertOnSubmit(diet2);
Db.SubmitChanges();
dpr = new DietProduct {
DId = diet2.DietID, Product = p1
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p2
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p3
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p4
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p5
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p6
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p7
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p9
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p11
};
Db.DietProducts.InsertOnSubmit(dpr);
diet2.DietProducts.Add(dpr);
Db.SubmitChanges();
diet2 = new Diet("Диета №3", 30);
Db.Diets.InsertOnSubmit(diet2);
Db.SubmitChanges();
dpr = new DietProduct {
DId = diet2.DietID, Product = p1
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p2
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p3
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p4
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p5
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p6
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p7
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p8
};
Db.DietProducts.InsertOnSubmit(dpr);
dpr = new DietProduct {
DId = diet2.DietID, Product = p9
};
Db.DietProducts.InsertOnSubmit(dpr);
diet2.DietProducts.Add(dpr);
Db.SubmitChanges();
MessageBox.Show("База данных успешно создана.");
}
name.Text = Name1;
age.Text = Age1;
height.Text = Height1;
weight.Text = Weight1;
waist.Text = WaistCircumference1;
hip.Text = HipCircumference1;
wrist.Text = WristCircumference1;
if (gender == "M")
{
radioButton1.IsChecked = true;
sex.IsChecked = false;
}
else
{
sex.IsChecked = true; radioButton1.IsChecked = false;
}
IQueryable <Person> PersonQuery = Db.Persons.Select(v => v);
p = PersonQuery.FirstOrDefault();
if (p == null)
{
p = new Person();
IQueryable <Diet> q = from Diet in Db.Diets select Diet;
p.Diet = d;
d = q.FirstOrDefault();
Db.Persons.InsertOnSubmit(p);
Db.SubmitChanges();
preference.Text = preference_;
p.Diet = d;
diet.Text = d.Name;
}
}
}