public bool UpdateAllergies(string Allergies) { try { var AllergiesToList = db.Allergies.ToList(); var UserAllergies = AllergiesToList.Where(x => x.UserName.ToLower() == Username.ToLower()).FirstOrDefault(); UserAllergies.AllergiesList = Allergies; db.Update(UserAllergies); db.SaveChanges(); return(true); } catch (SqlException) { return(false); } }
public void NewUserConfig(DietUsers dietUsers, double UserWc, double WeightPounds, double HeightInches, double UserWeight, double UserHeight) { //hash the password MD5 md5Hash = MD5.Create(); string hashPassword = GetMd5Hash(md5Hash, dietUsers.UserPassword); dietUsers.UserPassword = hashPassword; dietUsers.Status = "Active"; //Add a record to ProgressTracker Table ProgressTracker FirstPRogress = new ProgressTracker(); double BMI = UserWeight / (UserHeight * UserHeight); FirstPRogress.TrackerId = Guid.NewGuid(); FirstPRogress.UserName = dietUsers.UserName; FirstPRogress.Wc = Convert.ToDouble(UserWc); FirstPRogress.Bmi = BMI; FirstPRogress.Month = 1; FirstPRogress.MonthlyHeight = UserHeight; FirstPRogress.MonthlyWeight = UserWeight; FirstPRogress.DateEntered = DateTime.Today; double?BMR; int WCRange = 0; if (dietUsers.UserGender == "Male") { BMR = 66 + (6.23 * WeightPounds) + (12.7 * HeightInches) - (6.8 * dietUsers.UserAge); if (UserWc < 94) { WCRange = 1; } else if (UserWc < 102) { WCRange = 2; } else { WCRange = 3; } } else { BMR = 655 + (4.35 * WeightPounds) + (4.7 * HeightInches) - (4.7 * dietUsers.UserAge); if (UserWc < 80) { WCRange = 1; } else if (UserWc < 88) { WCRange = 2; } else { WCRange = 3; } } FirstPRogress.Bmr = (double)BMR; db.Add(FirstPRogress); float age = (float)Convert.ToDouble(dietUsers.UserAge); float wc = (float)Convert.ToDouble(UserWc); //send user's details to stochastic class to get weight category dietUsers.UserWeightCategory = WeightClassification.returnClassification((float)BMI, WCRange); dietUsers.NewUser = true; db.Add(dietUsers); db.SaveChanges(); }