public Dish[] display(int id) { var data = new GymDietManagementEntities1(); var buaAn = data.Dishes.Where(b => b.Meal_id == id).ToArray(); return(buaAn); }
public Dish GetFood(string Food) { var db = new GymDietManagementEntities1(); var getfood = db.Dishes.Find(Food); return(getfood); }
public void DeleteFood(string Food) { var db = new GymDietManagementEntities1(); var oldFood = db.Dishes.Find(Food); db.Dishes.Remove(oldFood); db.SaveChanges(); }
private void CbxTypeLoad() { var meallist = this.manage.GetMeal(); this.cbxType.DisplayMember = "Type"; this.cbxType.ValueMember = "id"; this.cbxType.DataSource = meallist; var mealid = int.Parse(this.cbxType.SelectedValue.ToString()); var db = new GymDietManagementEntities1(); var meal = db.Meals.Where(p => p.id == mealid).Single(); this.lblNote.Text = meal.Note; }
private void UpdateFood_Load(object sender, EventArgs e) { var OldFood = this.manage.GetFood(this.Foodid); this.txtFood.Text = OldFood.Food; this.txtAmount.Text = OldFood.Amount; this.txtCalori.Text = OldFood.Calori.ToString(); this.txtCalori.ForeColor = Color.Black; if (OldFood.Lipid == null) { this.txtLipid.Text = "Unknown"; } else { this.txtLipid.Text = OldFood.Lipid.ToString(); } if (OldFood.Glucid == null) { this.txtGlucid.Text = "Unknown"; } else { this.txtGlucid.Text = OldFood.Glucid.ToString(); } if (OldFood.Protein == null) { this.txtProtein.Text = "Unknown"; } else { this.txtProtein.Text = OldFood.Protein.ToString(); } if (OldFood.Cellulose == null) { this.txtCellulose.Text = "Unknown"; } else { this.txtCellulose.Text = OldFood.Cellulose.ToString(); } var db = new GymDietManagementEntities1(); var meal = db.Dishes.Find(this.Foodid); var mealid = meal.Meal_id; var mealtype = db.Meals.Where(p => p.id == mealid).Single(); this.txtType.Text = mealtype.Type.ToString(); }
public void GetMenu(int bmr, out string[] menu) { var Breakfast = this.display(1); var Lunch = this.display(3); var Dinner = this.display(4); var Snack = this.display(5); Random rand = new Random(); var breakfast = Breakfast[rand.Next(0, Breakfast.Length - 1)].Food; var lunch = Lunch[rand.Next(0, Lunch.Length - 1)].Food; var dinner = Dinner[rand.Next(0, Dinner.Length - 1)].Food; var snack = Snack[rand.Next(0, Snack.Length - 1)].Food; menu = new string[4]; var db = new GymDietManagementEntities1(); var B = db.Dishes.Find(breakfast); var L = db.Dishes.Find(lunch); var D = db.Dishes.Find(dinner); var S = db.Dishes.Find(snack); while ((B.Calori + (L.Calori + 300) + (D.Calori + 300) + S.Calori > bmr) || (B.Calori + (L.Calori + 300) + (D.Calori + 300) + S.Calori < bmr - 100)) { rand = new Random(); breakfast = Breakfast[rand.Next(0, Breakfast.Length - 1)].Food; lunch = Lunch[rand.Next(0, Lunch.Length - 1)].Food; dinner = Dinner[rand.Next(0, Dinner.Length - 1)].Food; snack = Snack[rand.Next(0, Snack.Length - 1)].Food; B = db.Dishes.Find(breakfast); L = db.Dishes.Find(lunch); D = db.Dishes.Find(dinner); S = db.Dishes.Find(snack); } if ((B.Calori + (L.Calori + 300) + (D.Calori + 300) + S.Calori <= bmr) && B.Calori + (L.Calori + 300) + (D.Calori + 300) + S.Calori >= bmr - 100) { menu[0] = breakfast; menu[1] = lunch; menu[2] = dinner; menu[3] = snack; } }
//Tính BMR private int CountBMR() { int calculate = 0; var Age = DateTime.Now.Year - this.B.Year; var db = new GymDietManagementEntities1(); var act = db.Actives.Find(float.Parse(this.A)); if (this.G == true) { calculate = (int)Math.Ceiling((88.362 + (13.397 * this.W) + (4.799 * this.H) - (5.677 * Age)) * (double)act.Value); } else { calculate = (int)Math.Ceiling((447.593 + (9.247 * this.W) + (3.098 * this.H) - (4.330 * Age)) * (double)act.Value); } return(calculate); }
void cbxType_SelectedIndexChanged(object sender, EventArgs e) { var mealid = int.Parse(this.cbxType.SelectedValue.ToString()); var db = new GymDietManagementEntities1(); var meal = db.Meals.Where(p => p.id == mealid).Single(); this.lblNote.Text = meal.Note; var display = this.manage.display(mealid); var displayView = new FoodFormal[display.Length]; for (int i = 0; i < display.Length; i++) { displayView[i] = new FoodFormal(display[i]); } this.grdDIsplay.DataSource = displayView; }
public void UpdateFood(string Food, string Amount, int Calori, string Type, Nullable <float> Li, Nullable <float> Gl, Nullable <float> Pr, Nullable <float> Cel) { var db = new GymDietManagementEntities1(); var oldFood = db.Dishes.Find(Food); oldFood.Food = Food; oldFood.Amount = Amount; oldFood.Calori = Calori; oldFood.Lipid = Li; oldFood.Glucid = Gl; oldFood.Protein = Pr; oldFood.Cellulose = Cel; var meal = db.Meals.Where(p => p.Type == Type).Single(); oldFood.Meal_id = meal.id; db.Entry(oldFood).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public void AddFood(string Food, string Amount, int Calori, string Type, Nullable <int> Li, Nullable <int> Gl, Nullable <int> Pr, Nullable <int> Cel) { var NewFood = new Dish(); NewFood.Food = Food; NewFood.Amount = Amount; NewFood.Calori = Calori; NewFood.Lipid = Li; NewFood.Glucid = Gl; NewFood.Protein = Pr; NewFood.Cellulose = Cel; NewFood.Meal_id = int.Parse(Type); var db = new GymDietManagementEntities1(); db.Dishes.Add(NewFood); db.SaveChanges(); }
void Menu_Load(object sender, EventArgs e) { //Load Combobox this.cbxMeal.DisplayMember = "Type"; this.cbxMeal.ValueMember = "id"; this.cbxMeal.DataSource = this.manage.GetMeal(4); //load Tên this.lblName.Text = "Welcome " + this.N; //Load dữ liệu món ăn this.manage.GetMenu(bmr, out menu); this.txtFood.Text = menu[0]; var db = new GymDietManagementEntities1(); var calo = db.Dishes.Find(menu[0]); this.txtCalori.Text = calo.Calori.ToString(); this.txtTotal.Text = bmr.ToString(); }
//thay đổi dữ liệu khi combobox thay đổi giá trị được chọn void cbxMeal_SelectedIndexChanged(object sender, EventArgs e) { var db = new GymDietManagementEntities1(); var value = int.Parse(this.cbxMeal.SelectedValue.ToString()); var calo = db.Dishes.Find(menu[0]); this.manage.GetMenu(bmr, out this.menu); if (value.Equals(3)) { calo = db.Dishes.Find(menu[1]); this.txtFood.Text = menu[1]; this.txtCalori.Text = calo.Calori.ToString(); this.txtAmount.Text = calo.Amount; } else if (value.Equals(4)) { this.txtFood.Text = menu[2]; calo = db.Dishes.Find(menu[2]); this.txtCalori.Text = calo.Calori.ToString(); this.txtAmount.Text = calo.Amount; } else if (value.Equals(5)) { this.txtFood.Text = menu[3]; calo = db.Dishes.Find(menu[3]); this.txtCalori.Text = calo.Calori.ToString(); this.txtAmount.Text = calo.Amount; } else { this.txtFood.Text = menu[0]; calo = db.Dishes.Find(menu[0]); this.txtCalori.Text = calo.Calori.ToString(); this.txtAmount.Text = calo.Amount; } }
public Dish[] GetDish() { var data = new GymDietManagementEntities1(); return(data.Dishes.ToArray()); }
public Meal[] GetMeal() { var db = new GymDietManagementEntities1(); return(db.Meals.ToArray()); }
public Active[] GetActive() { var db = new GymDietManagementEntities1(); return(db.Actives.ToArray()); }