public ActionResult SaveDiet(string food, float protein, float carb, float fat, float cal, string serving, string image, int pref_ID) { DateTime dateTime = DateTime.UtcNow.Date; try { string username = null; //check if user is logged in if (HttpContext.Session.GetString("LoggedIn") != null) { //retrieve user details from respective database tables username = HttpContext.Session.GetString("Username"); foreach (var foods in HttpContext.Session.GetCart()) { using (var context = new DietPlanDBContext()) { //var diet = new DietDb { Username = username, Date = dateTime, MealTime = foods.meal_time, Meals = foods.food }; //var nutrients = new NutritionalValue { Date = dateTime, FoodImg = foods.img, Protein = foods.nprotein, Carbs = foods.ncarb, Fat = foods.nfat, Calorie = foods.ncalorie }; //context.DietDb.Add(diet); //context.NutritionalValue.Add(nutrients); //context.SaveChanges(); var diet = new DietDb { Username = username, Date = dateTime, MealTime = foods.meal_time, Meals = foods.food, PrefId = pref_ID }; context.DietDb.Add(diet); context.SaveChanges(); var nutrients = new NutritionalValue { Food = foods.food, FoodId = diet.FoodId, Date = dateTime, FoodImg = foods.img, Protein = foods.nprotein, Carbs = foods.ncarb, Fat = foods.nfat, Calorie = foods.ncalorie, MealTime = foods.meal_time }; context.NutritionalValue.Add(nutrients); context.SaveChanges(); } } } else { return(RedirectToAction("Login")); } return(View()); } catch (SqlException) { string action = this.ControllerContext.RouteData.Values["action"].ToString(); string controller = this.ControllerContext.RouteData.Values["controller"].ToString(); return(RedirectToAction("Error", new { controllerName = controller, actionName = action })); } }
public IActionResult submittingAddtional(string Activity_Lev, string Preferences, bool IsAllergic, string Allergies, bool IsVeg) { var username = HttpContext.Session.GetString("Username"); Allergies addAllergy = new Allergies(); addAllergy.RecordId = Guid.NewGuid(); addAllergy.UserName = username; addAllergy.IsAllergic = IsAllergic; addAllergy.AllergiesList = Allergies; //allergyList db.Add(addAllergy); Preferences AddPreferences = new Preferences(); AddPreferences.RecordId = Guid.NewGuid(); AddPreferences.Username = username; AddPreferences.PreferencesList = Preferences; db.Add(AddPreferences); double?TDEE = 0; var user = db.ProgressTracker.Where(x => x.UserName.ToLower() == username.ToLower()).FirstOrDefault(); user.ActivityLevel = Activity_Lev; switch (Activity_Lev) { case "sedentary": TDEE = user.Bmr * 1.2; break; case "lightly": TDEE = user.Bmr * 1.375; break; case "mild": TDEE = user.Bmr * 1.55; break; case "very": TDEE = user.Bmr * 1.725; break; case "extra": TDEE = user.Bmr * 1.9; break; } user.Tdee = (double)TDEE; db.Update(user); var dietuser = db.DietUsers.Find(username); dietuser.NewUser = false; db.Update(dietuser); db.SaveChanges(); return(RedirectToAction("Dashboard")); }