public ActionResult ChangePlan(NutritionPlanModel nutritionPlan) { //check if the model state is valid or not if (ModelState.IsValid) { //update data in the database based on NutriPlanId impl.UpdateNutritionPlan(nutritionPlan.NutriPlanId, nutritionPlan); //redirect to NutritionPlan/listAllPlans return(RedirectToAction("listAllPlans")); } return(View()); }
public ActionResult CreateNutritionPlan(NutritionPlanModel nutritionPlan) { //check if the model state is valid or not if (ModelState.IsValid) { //save data in the database impl.SavePlan(nutritionPlan); //shows message to user if data is inserted ViewBag.Message = "Nutrition Plan Inserted successfully"; //deletes the data from model ModelState.Clear(); } return(View()); }
//UpdateNutritionPlan() update the NutritionPlans based on NutriPlanId and NutritionPlanModel public bool UpdateNutritionPlan(int plan_id, NutritionPlanModel nutritionPlan) { //open a connection to a database FitnesspointDatabase using (var context = new FitnesspointDatabaseEntities()) { //retrieving nutritionPlan from the database NutritionPlan based on NutriPlanId var nutritionPlan1 = context.NutritionPlans.FirstOrDefault(x => x.NutriPlanId == plan_id); //replace the data in the database with NutritionPlanModel data based on NutriPlanId if (nutritionPlan1 != null) { nutritionPlan1.Name = nutritionPlan.Name; nutritionPlan1.PlanDescription = nutritionPlan.PlanDescription; nutritionPlan1.Updated_At = DateTime.UtcNow; nutritionPlan1.Price = nutritionPlan.Price; } //save the changes to the database context.SaveChanges(); //returns true if data is updated return(true); } }
//SavePlan() saves NutritionPlan in the database public NutritionPlan SavePlan(NutritionPlanModel nutritionPlan) { //open a connection to a database FitnesspointDatabase using (var context = new FitnesspointDatabaseEntities()) { //Creating NutritionPlan object and assigning data using NutritionPlanModel class NutritionPlan nutritionPlan1 = new NutritionPlan() { Name = nutritionPlan.Name, PlanDescription = nutritionPlan.PlanDescription, Created_At = DateTime.UtcNow, Updated_At = DateTime.UtcNow, Price = nutritionPlan.Price, }; //add nutritionPlan to the database NutritionPlan using model NutritionPlan context.NutritionPlans.Add(nutritionPlan1); //save the changes to the database context.SaveChanges(); return(nutritionPlan1); } }