public ActionResult Create([Bind(Include = "id,Product_id,FoodDay_id,weight,count,caloric,protein,carb,fat")] Product_FoodDay product_FoodDay) { if (ModelState.IsValid) { db.Product_FoodDay.Add(product_FoodDay); db.SaveChanges(); FoodDay foodDay = db.FoodDay.Find(product_FoodDay.FoodDay_id); Product product = db.Product.Find(product_FoodDay.Product_id); product_FoodDay.caloric = product.caloric * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.carb = product.carb * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.protein = product.protein * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.fat = product.fat * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.caloric = product.caloric * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumCarb += product.carb * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumProtein += product.protein * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumFat += product.fat * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumCaloric += product.caloric * (double)product_FoodDay.weight / (double)product.weight; db.Entry(foodDay).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FoodDay_id = new SelectList(db.FoodDay, "id", "Users_id", product_FoodDay.FoodDay_id); ViewBag.Product_id = new SelectList(db.Product, "id", "Users_id", product_FoodDay.Product_id); return(View(product_FoodDay)); }
public ActionResult DeleteConfirmed(int id) { Product_FoodDay product_FoodDay = db.Product_FoodDay.Find(id); db.Product_FoodDay.Remove(product_FoodDay); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,Product_id,FoodDay_id,weight,count,caloric,protein,carb,fat")] Product_FoodDay product_FoodDay) { if (ModelState.IsValid) { db.Entry(product_FoodDay).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FoodDay_id = new SelectList(db.FoodDay, "id", "Users_id", product_FoodDay.FoodDay_id); ViewBag.Product_id = new SelectList(db.Product, "id", "Users_id", product_FoodDay.Product_id); return(View(product_FoodDay)); }
// GET: EveryoneProduct_FoodDay/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Product_FoodDay product_FoodDay = db.Product_FoodDay.Find(id); if (product_FoodDay == null) { return(HttpNotFound()); } return(View(product_FoodDay)); }
// GET: EveryoneProduct_FoodDay/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Product_FoodDay product_FoodDay = db.Product_FoodDay.Find(id); if (product_FoodDay == null) { return(HttpNotFound()); } ViewBag.FoodDay_id = new SelectList(db.FoodDay, "id", "Users_id", product_FoodDay.FoodDay_id); ViewBag.Product_id = new SelectList(db.Product, "id", "Users_id", product_FoodDay.Product_id); return(View(product_FoodDay)); }
public ActionResult Details([Bind(Include = "id,weight")] Product chooseProduct) { var idUser = User.Identity.GetUserId(); AspNetUsers user = db.AspNetUsers.Find(idUser); Product_FoodDay product_FoodDay = new Product_FoodDay(); var foodDay1 = db.FoodDay.Where(model => model.AspNetUsers.Id == idUser).ToList(); var id1 = foodDay1.Last().id; FoodDay LastfoodDay = db.FoodDay.Find(id1); Product p1 = db.Product.Find(chooseProduct.id); product_FoodDay.weight = chooseProduct.weight; product_FoodDay.Product_id = chooseProduct.id; product_FoodDay.FoodDay_id = LastfoodDay.id; chooseProduct.weight = p1.weight; db.Product_FoodDay.Add(product_FoodDay); db.SaveChanges(); FoodDay foodDay = db.FoodDay.Find(product_FoodDay.FoodDay_id); Product product = db.Product.Find(product_FoodDay.Product_id); /*if(product_FoodDay.weight == null) * { * foodDay.sumCaloric = product.caloric * (double)product_FoodDay.count; * foodDay.sumCarb += product.carb * (double)product_FoodDay.count; * foodDay.sumProtein += product.protein * (double)product_FoodDay.count; * foodDay.sumFat += product.fat * (double)product_FoodDay.count; * db.Entry(foodDay).State = EntityState.Modified; * db.SaveChanges(); * }*/ //else if(product_FoodDay.count == null) //{ product_FoodDay.caloric = product.caloric * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.carb = product.carb * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.protein = product.protein * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.fat = product.fat * (double)product_FoodDay.weight / (double)product.weight; product_FoodDay.caloric = product.caloric * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumCaloric += product.caloric * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumCarb += product.carb * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumProtein += product.protein * (double)product_FoodDay.weight / (double)product.weight; foodDay.sumFat += product.fat * (double)product_FoodDay.weight / (double)product.weight; if (user.caloricDemand != null) { if (foodDay.sumCaloric < (int)user.caloricDemand) { foodDay.description = "Za mało spożyłeś kalorii"; } else if (foodDay.sumCaloric > (int)user.caloricDemand) { foodDay.description = "Spożyłeś za dużo kalorii"; } else { foodDay.description = "Spożyłeś odpowiednią ilość kalorii"; } } db.Entry(foodDay).State = EntityState.Modified; db.SaveChanges(); // } return(RedirectToAction("Index")); }