예제 #1
0
        //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);
            }
        }
예제 #2
0
 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());
 }
예제 #3
0
        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());
        }
예제 #4
0
 //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);
     }
 }