private void button3_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel);
if (m == MessageBoxResult.OK)
{
Dish s = null;
if (listBox2.SelectedIndex >= 0)
{
s = l[listBox2.SelectedIndex];
}
else if (listBox3.SelectedIndex >= 0)
{
s = l[listBox3.SelectedIndex];
}
else if (listBox1.SelectedIndex >= 0)
{
s = l[listBox1.SelectedIndex];
}
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
if (s != null)
{
var s3 = from DishProduct in Db.DishProducts
where DishProduct.DId == s.DishID
select DishProduct;
List <DishProduct> dp = s3.ToList();
Db.DishProducts.DeleteAllOnSubmit(dp);
Db.SubmitChanges();
var s4 = from Ration in Db.Rations
where Ration.Dish.DishID == s.DishID
select Ration;
List <Ration> rp = s4.ToList();
Db.Rations.DeleteAllOnSubmit(rp);
Db.SubmitChanges();
var s1 = from Dish in Db.Dishes
where Dish.DishID == s.DishID
select Dish;
Db.Dishes.DeleteOnSubmit(s1.FirstOrDefault());
Db.SubmitChanges();
}
}
init();
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel);
if (m == MessageBoxResult.OK)
{
Schedule s = null;
if (listBox1.SelectedIndex >= 0)
{
s = l[listBox1.SelectedIndex];
}
else if (listBox3.SelectedIndex >= 0)
{
s = l[listBox2.SelectedIndex];
}
else if (listBox3.SelectedIndex >= 0)
{
s = l[listBox3.SelectedIndex];
}
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
if (s != null)
{
var s1 = from Schedule in Db.Schedules
where Schedule.ScheduleID == s.ScheduleID
select Schedule;
Db.Schedules.DeleteOnSubmit(s1.FirstOrDefault());
Db.SubmitChanges();
}
}
init();
}
}
private void button4_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel);
if (m == MessageBoxResult.OK)
{
Diet s = null;
if (ListboxDiet.SelectedIndex >= 0)
{
s = l[ListboxDiet.SelectedIndex];
}
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
if (s != null)
{
var s1 = from Diet in Db.Diets
where Diet.DietID == s.DietID
select Diet;
Db.Diets.DeleteOnSubmit(s1.FirstOrDefault());
Db.SubmitChanges();
}
}
init();
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
Dish d1 = new Dish(name1, d.Type, portion1, d.Measure);
Db.Dishes.InsertOnSubmit(d1);
Db.SubmitChanges();
foreach (DishProduct dpr in d.DishProducts)
{
dpr.DId = d1.DishID;
Db.DishProducts.InsertOnSubmit(dpr);
d1.DishProducts.Add(dpr);
Db.SubmitChanges();
}
NavigationService.Navigate(new Uri("/InfoPage.xaml", UriKind.Relative));
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
Product p = new Product(name.Text, listBox1.SelectedIndex, Convert.ToDouble(protein.Text), Convert.ToDouble(fat.Text),
Convert.ToDouble(carbohydrates.Text), Convert.ToInt32(calories.Text), Convert.ToInt32(cost.Text), Convert.ToDouble(acidity.Text), listBox2.SelectedIndex);
NavigationService.Navigate(new Uri("/ProductList.xaml", UriKind.Relative));
Db.Products.InsertOnSubmit(p);
Db.SubmitChanges();
}
}
private void button3_Click(object sender, RoutedEventArgs e)
{
Product s = null;
MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel);
if (m == MessageBoxResult.OK)
{
if (listBox1.SelectedIndex >= 0)
{
s = l[listBox1.SelectedIndex];
}
else if (listBox3.SelectedIndex >= 0)
{
s = l[listBox2.SelectedIndex];
}
else if (listBox3.SelectedIndex >= 0)
{
s = l[listBox3.SelectedIndex];
}
else if (listBox4.SelectedIndex >= 0)
{
s = l[listBox4.SelectedIndex];
}
else if (listBox5.SelectedIndex >= 0)
{
s = l[listBox5.SelectedIndex];
}
else if (listBox6.SelectedIndex >= 0)
{
s = l[listBox6.SelectedIndex];
}
using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString))
{
if (s != null)
{
var s2 = from DietProduct in Db.DietProducts
where DietProduct.PId == s.ProductID
select DietProduct;
List <DietProduct> lp = s2.ToList();
Db.DietProducts.DeleteAllOnSubmit(lp);
Db.SubmitChanges();
var s3 = from DishProduct in Db.DishProducts
where DishProduct.PId == s.ProductID
select DishProduct;
List <DishProduct> dp = s3.ToList();
Db.DishProducts.DeleteAllOnSubmit(dp);
Db.SubmitChanges();
var s1 = from Product in Db.Products
where Product.ProductID == s.ProductID
select Product;
Db.Products.DeleteOnSubmit(s1.FirstOrDefault());
Db.SubmitChanges();
}
}
init();
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
using (MyDataContext context = new MyDataContext(strConnectionString))
{
if (name.Text != "" && age.Text != "" && height.Text != "" && weight.Text != "" &&
waist.Text != "" && hip.Text != "" && wrist.Text != "")
{
p.Name = name.Text;
p.Age = Convert.ToInt32(age.Text);
p.Height = Convert.ToInt32(height.Text);
p.Weight = Convert.ToInt32(weight.Text);
p.Sex = gender;
p.WaistCircumference = Convert.ToInt32(waist.Text);
p.HipCircumference = Convert.ToInt32(hip.Text);
p.WristCircumference = Convert.ToInt32(wrist.Text);
p.Ration = "";
//STUB!
/*p.Name = "Аня";
* p.Age = 21;
* p.Height = 174;
* p.Weight = 63;
* p.Sex = "F";
* p.WaistCircumference = 62;
* p.HipCircumference = 88;
* p.WristCircumference = 16;
* p.Preference = 0;*/
//constitution
if (p.WristCircumference > 18.5)
{
p.ConstitutionId = 2;
}
else if (p.WristCircumference < 16)
{
p.ConstitutionId = 0;
}
else
{
p.ConstitutionId = 1;
}
//fat percentage
p.PercentFat = Math.Round(((p.Weight * 1.0) / (p.Height * p.Height) * 10000), 1);
//bioage
double rl = 0;
double kss = 0;
if (gender == "M")
{
rl = p.Age - 21;
kss = (p.WaistCircumference * p.Weight) / (p.HipCircumference * p.Height * p.Height * (17.2 + 0.31 * rl + 0.0012 * rl * rl));
}
else
{
rl = p.Age - 18;
kss = (p.WaistCircumference * p.Weight) / (p.HipCircumference * p.Height * p.Height * (14.7 + 0.26 * rl + 0.001 * rl * rl));
} double bioage = 0;
if (gender == "M")
{
bioage = kss * (p.Age - 18) + 18;
}
else
{
bioage = kss * (p.Age - 21) + 21;
}
p.BioAge = (int)Math.Round(bioage);
if (d != null)
{
IQueryable <Diet> q = from Diet in context.Diets where d.DietID == Diet.DietID select Diet;
d = q.FirstOrDefault();
}
if (d == null)
{
IQueryable <Diet> q = from Diet in context.Diets select Diet;
d = q.FirstOrDefault();
}
p.Diet = d;
//insert
context.Persons.InsertOnSubmit(p);
context.SubmitChanges();
NavigationService.Navigate(new Uri("/InfoPage.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;
}
}
}