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