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());
}
