//SaveDietPlan() saves DietPlan in the database public DietPlan SaveDietPlan(DietPlanModel dietPlan) { //open a connection to a database FitnesspointDatabase using (var context = new FitnesspointDatabaseEntities()) { //Creating DietPlan object and assigning data using DietPlanModel class DietPlan dietPlan1 = new DietPlan() { Slots = dietPlan.Slots, FoodType = dietPlan.FoodType, FatRatio = dietPlan.FatRatio, CarbsRatio = dietPlan.CarbsRatio, ProteinRatio = dietPlan.ProteinRatio, TotalCalorie = dietPlan.FatRatio + dietPlan.CarbsRatio + dietPlan.ProteinRatio, UserId = dietPlan.UserId }; //add dietPlan1 to the database DietPlan using model DietPlan context.DietPlans.Add(dietPlan1); //save the changes to the database context.SaveChanges(); return(dietPlan1); } }
public ActionResult ChangeDietPlan(DietPlanModel dietPlan) { //check if the model state is valid or not if (ModelState.IsValid) { //update data in the database based on DietId impl.UpdateDietPlan(dietPlan.DietId, dietPlan); //redirect to DietPlan/ListAllDietPlans return(RedirectToAction("ListAllDietPlans", new { user_id = Session["Id"] })); } return(View()); }
public ActionResult CreateDietPlan(DietPlanModel dietPlan) { //check if the model state is valid or not if (ModelState.IsValid) { //save data in the database impl.SaveDietPlan(dietPlan); //shows message to user if data is inserted ViewBag.Message = "Diet Plan Inserted successfully"; //deletes the data from model ModelState.Clear(); } return(View()); }
//UpdateDietPlan() update the DietPlans based on DietId and DietPlanModel public bool UpdateDietPlan(int diet_id, DietPlanModel dietPlan) { //open a connection to a database FitnesspointDatabase using (var context = new FitnesspointDatabaseEntities()) { //retrieving dietPlan from the database DietPlan based on DietId var dietPlan1 = context.DietPlans.FirstOrDefault(x => x.DietId == diet_id); //replace the data in the database with DietPlanModel data based on DietId if (dietPlan1 != null) { dietPlan1.Slots = dietPlan.Slots; dietPlan1.FoodType = dietPlan.FoodType; dietPlan1.FatRatio = dietPlan.FatRatio; dietPlan1.CarbsRatio = dietPlan.CarbsRatio; dietPlan1.ProteinRatio = dietPlan.ProteinRatio; dietPlan1.TotalCalorie = dietPlan1.FatRatio + dietPlan1.CarbsRatio + dietPlan1.ProteinRatio; dietPlan1.UserId = dietPlan.UserId; } //save the changes to the database context.SaveChanges(); //returns true if data is updated return(true); } }