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();
}
