public ActionResult Create(DailyDetail dailyDetail, FormCollection formCollection)
        {
            decimal amount, totalAmount;
            dailyDetail.NutrientAmountsDict = new Dictionary<int, decimal>();

            User user = db.Users.Find(1);

            // Create a dictionary from the form fields for each nutrient present
            Dictionary<int, string> NutrientValues = formCollection.AllKeys
                .Where(k => System.Text.RegularExpressions.Regex.IsMatch(k, @"^[0-9]+$"))
                .ToDictionary(k => Convert.ToInt32(k), k => formCollection[k]);

            var servings = dailyDetail.Servings;
            var saveMeal = formCollection.Get("SaveMeal");

            // Get the Totals for the day if it already exists, if not, create a new Total
            DailyTotal dailyTotal = new DailyTotal();
            Meal meal = new Meal();
            meal.NutrientAmountsDict = new Dictionary<int, decimal>();

            // ************************
            var results = db.DailyTotals.Where(s => s.Day == dailyDetail.Day).Where(s => s.UserID == 1).Single();
            if (results != null) {
                dailyTotal = results;
                dailyTotal.NutrientAmountsDict = new Dictionary<int, decimal>();
                dailyTotal.NutrientAmountsDict = gl.DictionaryUnSerializer(dailyTotal.NutrientAmounts);
                dailyTotal.Calories += dailyDetail.Calories;
                dailyTotal.CaloriesFromFat += dailyDetail.CaloriesFromFat;
                dailyTotal.MealCount++;
            }
            else
            {
                dailyTotal = new DailyTotal();
                dailyTotal.Day = dailyDetail.Day;
                dailyTotal.Calories = dailyDetail.Calories * dailyDetail.Servings;
                dailyTotal.CaloriesFromFat = dailyDetail.CaloriesFromFat * dailyDetail.Servings;
                dailyTotal.MealCount = 1;
                dailyTotal.NutrientAmountsDict = new Dictionary<int, decimal>();
                dailyTotal.UserID = user.UserID;
            }

            // Look through all the nutrients to build a list
            foreach (var nutrient in db.Nutrients)
            {
                if (NutrientValues.ContainsKey(nutrient.NutrientID))
                {
                    // Only add the Nutrient if it has a valid, non zero, value
                    try { amount = Convert.ToDecimal(NutrientValues[nutrient.NutrientID]) * nutrient.PercentageMultiplier; }
                    catch (FormatException) { amount = 0; }
                    catch (OverflowException) { amount = 0; }

                    if (amount != 0)
                    {
                        // If a value for the nutrient already exists in the Day's Totals, add it. else set it equal to the amount
                        if (dailyTotal.NutrientAmountsDict.ContainsKey(nutrient.NutrientID)) { totalAmount = dailyTotal.NutrientAmountsDict[nutrient.NutrientID] + amount * dailyDetail.Servings; }
                        else { totalAmount = amount * dailyDetail.Servings; }

                        // Add the amounts to the appropriate dictionaries
                        dailyDetail.NutrientAmountsDict[nutrient.NutrientID] = amount * dailyDetail.Servings;
                        dailyTotal.NutrientAmountsDict[nutrient.NutrientID] = totalAmount;
                        meal.NutrientAmountsDict[nutrient.NutrientID] = amount;
                    }
                }
            }

            // Serialize the Dictionaries to save to the db
            dailyTotal.NutrientAmounts = gl.DictionarySerializer(dailyTotal.NutrientAmountsDict);
            dailyDetail.NutrientAmounts = gl.DictionarySerializer(dailyDetail.NutrientAmountsDict);

            //******************************
            // Save the Meal if the user chose to do so
            if (saveMeal != null) {
                string mealName = formCollection.Get("MealName");
                if (mealName == "") { mealName = "Temp Meal Name"; }

                meal.NutrientAmounts = gl.DictionarySerializer(meal.NutrientAmountsDict);
                meal.Calories = dailyDetail.Calories;
                meal.CaloriesFromFat = dailyDetail.CaloriesFromFat;
                meal.Name = mealName;
                meal.UserID = user.UserID;
                db.NutrientAmounts.Add(meal);
            }

            // Multiply the Calories by the Serving Size
            dailyDetail.Calories *= dailyDetail.Servings;
            dailyDetail.CaloriesFromFat *= dailyDetail.Servings;

            // Commit the changes
            if (ModelState.IsValid)
            {
                db.NutrientAmounts.Add(dailyDetail);
                if (dailyTotal.MealCount == 1) { db.NutrientAmounts.Add(dailyTotal); }
                else { db.Entry(dailyTotal).State = EntityState.Modified; }
                db.SaveChanges();
                return RedirectToAction("Index", "Home");
            }

            ViewBag.UserID = new SelectList(db.Users, "UserID", "FirstName", dailyDetail.UserID);
            return RedirectToAction("Index", "Home");
        }
 public ActionResult Edit(DailyDetail dailyDetail)
 {
     if (ModelState.IsValid)
     {
         db.Entry(dailyDetail).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.UserID = new SelectList(db.Users, "UserID", "FirstName", dailyDetail.UserID);
     return View(dailyDetail);
 }