protected void btnUpdate_Click(object sender, EventArgs e)
{
string sUserID = Membership.GetUser().ProviderUserKey.ToString();
int iPersonalSummaryId = Convert.ToInt32(hiddenPersonalSummaryId.Value);
decimal decLeanBodyMass = Convert.ToDecimal(labelLeanBodyMass.Text.Trim());
decimal decWeight = Convert.ToDecimal(labelWeight.Text.Trim());
decimal decLossFrequencyGoal = 0.0m;
int ddlLossFrequencyGoalIndex = ddlLossFrequencyGoal.SelectedIndex;
if (ddlLossFrequencyGoal.SelectedIndex == 0)
decLossFrequencyGoal = 0.5m;
else if (ddlLossFrequencyGoal.SelectedIndex == 1)
decLossFrequencyGoal = 1.0m;
else if (ddlLossFrequencyGoal.SelectedIndex == 2)
decLossFrequencyGoal = 1.5m;
else if (ddlLossFrequencyGoal.SelectedIndex == 3)
decLossFrequencyGoal = 2.0m;
else if (ddlLossFrequencyGoal.SelectedIndex == 4)
decLossFrequencyGoal = 2.5m;
else if (ddlLossFrequencyGoal.SelectedIndex == 5)
decLossFrequencyGoal = 3.0m;
else if (ddlLossFrequencyGoal.SelectedIndex == 6)
decLossFrequencyGoal = 3.5m;
else if (ddlLossFrequencyGoal.SelectedIndex == 7)
decLossFrequencyGoal = 4.0m;
else if (ddlLossFrequencyGoal.SelectedIndex == 8)
decLossFrequencyGoal = 4.5m;
else if (ddlLossFrequencyGoal.SelectedIndex == 9)
decLossFrequencyGoal = 5.0m;
else
decLossFrequencyGoal = 0.5m;
int iActivityLevel = ddlActivityLevel.SelectedIndex;
decimal decWaist = Convert.ToDecimal(hiddenWaist.Value);
decimal decBMI = Convert.ToDecimal(hiddenBMI.Value);
decimal decBodyFATPercentage = Convert.ToDecimal(hiddenBodyFATPercentage.Value);
decimal decWaistToHeight = Convert.ToDecimal(hiddenWaistToHeight.Value);
decimal decWaistToHip = Convert.ToDecimal(hiddenWaistToHip.Value);
CaloricRequirementsCalculatorClass objCaloricRequirementsCalculatorClass = new CaloricRequirementsCalculatorClass(objSqlConnClass.OpenConnection());
objCaloricRequirementsCalculatorClass.SetCaloricRequirementsCalculator(Membership.GetUser().ProviderUserKey.ToString(), iPersonalSummaryId, decLeanBodyMass, decWeight, decLossFrequencyGoal, iActivityLevel, decWaist, decBMI, decBodyFATPercentage, decWaistToHeight, decWaistToHip);
objSqlConnClass.CloseConnection();
}
private void fillOutForm()
{
/*
• Caloric Requirements Calculator Pop-up pre-populated by original DCR calculation during account set-up
• Hitting “Update” Updates the User Caloric Requirements in the DB as well as the goal Calories
• Original Caloric Requirements (Risk Strat) Calculated by:
o Male BMR = (9.99 x (Weight/2.2)) + (6.25 x (Height*2.54)) – 4.92 x Age + 5
o Female BMR = (9.99 x (Weight/2.2)) + (6.25 x (Height*2.54)) – 4.92 x Age -161
o BMR Multiplied by Activity level selected
• Daily Calorie Calculator takes more information into consideration:
o BMR = 370 + (9.79759519 x Lean Body Mass (lbs))
o BMR multiplied by Activity level selected.
• Weight Goal Calories = Caloric Requirement – (Loss Frequency Goal x 3500)/7
• NOTE: If Lean Body Mass has not been calculated, “Update” button is replaced by prompt:
“Please use Body Fat % Calculator to calculate Lean Body Mass prior to updating Caloric requirements”.
o Body Fat % Calculator text hyperlinks to Body Fat % Calculator
*/
string sedentary = "Sedentary - little or no exercise</asp:ListItem";
string lightly = "Lightly Active - light exercise/sports 1-3 days/week</asp:ListItem";
string moderately = "Moderately Active - moderate exercise/sports 3-5 days/week</asp:ListItem";
string very = "Very Active - hard exercise/sports 6-7 days/week</asp:ListItem";
string extra = "Extra Active - very hard daily exercise/sports & physical job or 2X day training";
string sActivityLevel = "";
int iPersonalSummaryId = 0;
decimal decWeight = 0.00m;
decimal decWaist = 0.00m;
decimal decNeck = 0.00m;
decimal decHips = 0.00m;
decimal decBMI = 0.00m;
decimal decBodyFATPercentage = 0.00m;
decimal decWaistToHeight = 0.00m;
decimal decWaistToHip = 0.00m;
decimal decLossFrequencyGoal = 0.00m;
int iActivityLevel = 0;
int iCaloricRequirement = 0;
decimal decLeanBodyMass = 0.00m;
int iGoalCalories = 0;
CaloricRequirementsCalculatorClass objCaloricRequirementsCalculatorClass = new CaloricRequirementsCalculatorClass(objSqlConnClass.OpenConnection());
DataSet MyDataSet = objCaloricRequirementsCalculatorClass.GetCaloricRequirementsCalculator(Membership.GetUser().ProviderUserKey.ToString());
if ((MyDataSet != null) && (MyDataSet.Tables.Count > 0))
{
if (MyDataSet.Tables[0].Rows.Count > 0)
{
iPersonalSummaryId = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["intPersonalSummaryId"])) ? 0 : Convert.ToInt32(MyDataSet.Tables[0].Rows[0]["intPersonalSummaryId"]);
decWeight = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decWeight"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decWeight"]);
decWaist = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decWaist"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decWaist"]);
decNeck = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decNeck"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decNeck"]);
decHips = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decHips"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decHips"]);
decBMI = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decBMI"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decBMI"]);
decBodyFATPercentage = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decBodyFATPercentage"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decBodyFATPercentage"]);
decWaistToHeight = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decWaistToHeight"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decWaistToHeight"]);
decWaistToHip = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decWaistToHip"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decWaistToHip"]);
decLossFrequencyGoal = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["decLossFrequencyGoal"])) ? 0.00m : Convert.ToDecimal(MyDataSet.Tables[0].Rows[0]["decLossFrequencyGoal"]);
iActivityLevel = (Convert.IsDBNull(MyDataSet.Tables[0].Rows[0]["intActivityLevel"])) ? 0 : Convert.ToInt32(MyDataSet.Tables[0].Rows[0]["intActivityLevel"]);
}
}
hiddenPersonalSummaryId.Value = iPersonalSummaryId.ToString();
iCaloricRequirement = objCaloricRequirementsCalculatorClass.GetCurrentCaloricRequirements(Membership.GetUser().ProviderUserKey.ToString());
// Lean Body Mass = Total Body Weight x (1 - Body Fat %)
if (decBodyFATPercentage > 0)
{
decimal percentageMultiplier = .01m;
decimal decBodyFATPercentage1 = Decimal.Multiply(decBodyFATPercentage, percentageMultiplier);
decLeanBodyMass = decWeight * (1 - decBodyFATPercentage1);
decLeanBodyMass = Decimal.Round(decLeanBodyMass, 2);
}
// Weight Goal Calories = Caloric Requirement – (Loss Frequency Goal x 3500)/7
iGoalCalories = iCaloricRequirement - Convert.ToInt32(((decLossFrequencyGoal * 3500) / 7));
labelCalories.Text = iCaloricRequirement.ToString();
labelGoalCalories.Text = iGoalCalories.ToString();
labelWeight.Text = decWeight.ToString();
labelLeanBodyMass.Text = decLeanBodyMass.ToString();
ddlActivityLevel.SelectedIndex = iActivityLevel;
if (decLossFrequencyGoal == 0.5m)
ddlLossFrequencyGoal.SelectedIndex = 0;
else if (decLossFrequencyGoal == 1.0m)
ddlLossFrequencyGoal.SelectedIndex = 1;
else if (decLossFrequencyGoal == 1.5m)
ddlLossFrequencyGoal.SelectedIndex = 2;
else if (decLossFrequencyGoal == 2.0m)
ddlLossFrequencyGoal.SelectedIndex = 3;
else if (decLossFrequencyGoal == 2.5m)
ddlLossFrequencyGoal.SelectedIndex = 4;
else if (decLossFrequencyGoal == 3.0m)
ddlLossFrequencyGoal.SelectedIndex = 5;
else if (decLossFrequencyGoal == 3.5m)
ddlLossFrequencyGoal.SelectedIndex = 6;
else if (decLossFrequencyGoal == 4.0m)
ddlLossFrequencyGoal.SelectedIndex = 7;
else if (decLossFrequencyGoal == 4.5m)
ddlLossFrequencyGoal.SelectedIndex = 8;
else if (decLossFrequencyGoal == 5.0m)
ddlLossFrequencyGoal.SelectedIndex = 9;
else
ddlLossFrequencyGoal.SelectedIndex = 0;
if(string.Compare(sActivityLevel, sedentary, true) == 0)
ddlActivityLevel.SelectedIndex = 0;
else if (string.Compare(sActivityLevel, lightly, true) == 0)
ddlActivityLevel.SelectedIndex = 1;
else if (string.Compare(sActivityLevel, moderately, true) == 0)
ddlActivityLevel.SelectedIndex = 2;
else if (string.Compare(sActivityLevel, very, true) == 0)
ddlActivityLevel.SelectedIndex = 3;
else if (string.Compare(sActivityLevel, extra, true) == 0)
ddlActivityLevel.SelectedIndex = 4;
else
ddlActivityLevel.SelectedIndex = 0;
if (decLeanBodyMass == 0)
{
btnUpdate.Visible = false;
labelLBM1.Visible = true;
hylinkLBM.Visible = true;
labelLBM2.Visible = true;
}
else
{
btnUpdate.Visible = true;
labelLBM1.Visible = false;
hylinkLBM.Visible = false;
labelLBM2.Visible = false;
}
objSqlConnClass.CloseConnection();
}
