protected void btnSave_Click(object sender, EventArgs e)
    {
        string sDateSelected = textEntryDate.Text.Trim();
        if (sDateSelected.Length == 0)
            sDateSelected = DateTime.Now.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.GetCultureInfo("en-US"));
        else
        {
            DateTime dt = DateTime.Parse(sDateSelected);
            sDateSelected = dt.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.GetCultureInfo("en-US"));
        }

        string sUserID = Membership.GetUser().ProviderUserKey.ToString();
        int iPersonalSummaryId = Convert.ToInt32(hiddenPersonalSummaryId.Value);
        decimal decWeight = Convert.ToDecimal(textLatestWeight.Text);
        decimal decWaist = Convert.ToDecimal(textLatestWaist.Text);
        decimal decNeck = Convert.ToDecimal(textLatestNeck.Text);
        decimal decHips = Convert.ToDecimal(textLatestHips.Text);
        BodyFatCalculatorClass bfc = new BodyFatCalculatorClass(objSqlConnClass.OpenConnection());
        bfc.SetBodyFatCalculator(Membership.GetUser().ProviderUserKey.ToString(), sDateSelected, iPersonalSummaryId, decWeight, decWaist, decNeck, decHips);
    }
    private void fillOutForm()
    {
        int iBaselinePersonalSummaryId = 0;
        decimal decBaselineWeight = 0.00m;
        decimal decBaselineWaist = 0.00m;
        decimal decBaselineNeck = 0.00m;
        decimal decBaselineHips = 0.00m;
        int iLatestPersonalSummaryId = 0;
        decimal decLatestWeight = 0.00m;
        decimal decLatestWaist = 0.00m;
        decimal decLatestNeck = 0.00m;
        decimal decLatestHips = 0.00m;

        decimal decWeightChange = 0.00m;
        decimal decWaistChange = 0.00m;
        decimal decNeckChange = 0.00m;
        decimal decHipsChange = 0.00m;

        decimal decWeightPercentageChange = 0.00m;
        decimal decWaistPercentageChange = 0.00m;
        decimal decNeckPercentageChange = 0.00m;
        decimal decHipsPercentageChange = 0.00m;

        string sDateSelected = textEntryDate.Text.Trim();
        if (sDateSelected.Length == 0)
            sDateSelected = DateTime.Now.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.GetCultureInfo("en-US"));
        else
        {
            DateTime dt = DateTime.Parse(sDateSelected);
            sDateSelected = dt.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.GetCultureInfo("en-US"));
        }

        BodyFatCalculatorClass bfc = new BodyFatCalculatorClass(objSqlConnClass.OpenConnection());

        DataSet MyDataSetBaseline = bfc.GetBodyFatCalculatorBaseline(Membership.GetUser().ProviderUserKey.ToString());
        if ((MyDataSetBaseline != null) && (MyDataSetBaseline.Tables.Count > 0))
        {
            if (MyDataSetBaseline.Tables[0].Rows.Count > 0)
            {
                iBaselinePersonalSummaryId = (Convert.IsDBNull(MyDataSetBaseline.Tables[0].Rows[0]["intPersonalSummaryId"])) ? 0 : Convert.ToInt32(MyDataSetBaseline.Tables[0].Rows[0]["intPersonalSummaryId"]);
                decBaselineWeight = (Convert.IsDBNull(MyDataSetBaseline.Tables[0].Rows[0]["decWeight"])) ? 0 : Convert.ToDecimal(MyDataSetBaseline.Tables[0].Rows[0]["decWeight"]);
                decBaselineWaist = (Convert.IsDBNull(MyDataSetBaseline.Tables[0].Rows[0]["decWaist"])) ? 0 : Convert.ToDecimal(MyDataSetBaseline.Tables[0].Rows[0]["decWaist"]);
                decBaselineNeck = (Convert.IsDBNull(MyDataSetBaseline.Tables[0].Rows[0]["decBMI"])) ? 0 : Convert.ToDecimal(MyDataSetBaseline.Tables[0].Rows[0]["decBMI"]);
                decBaselineHips = (Convert.IsDBNull(MyDataSetBaseline.Tables[0].Rows[0]["decBodyFATPercentage"])) ? 0 : Convert.ToDecimal(MyDataSetBaseline.Tables[0].Rows[0]["decBodyFATPercentage"]);
            }
        }

        DataSet MyDataSetLatest = bfc.GetBodyFatCalculatorLatest(Membership.GetUser().ProviderUserKey.ToString(), sDateSelected);
        if ((MyDataSetLatest != null) && (MyDataSetLatest.Tables.Count > 0))
        {
            if (MyDataSetLatest.Tables[0].Rows.Count > 0)
            {
                iLatestPersonalSummaryId = (Convert.IsDBNull(MyDataSetLatest.Tables[0].Rows[0]["intPersonalSummaryId"])) ? 0 : Convert.ToInt32(MyDataSetLatest.Tables[0].Rows[0]["intPersonalSummaryId"]);
                decLatestWeight = (Convert.IsDBNull(MyDataSetLatest.Tables[0].Rows[0]["decWeight"])) ? 0 : Convert.ToDecimal(MyDataSetLatest.Tables[0].Rows[0]["decWeight"]);
                decLatestWaist = (Convert.IsDBNull(MyDataSetLatest.Tables[0].Rows[0]["decWaist"])) ? 0 : Convert.ToDecimal(MyDataSetLatest.Tables[0].Rows[0]["decWaist"]);
                decLatestNeck = (Convert.IsDBNull(MyDataSetLatest.Tables[0].Rows[0]["decBMI"])) ? 0 : Convert.ToDecimal(MyDataSetLatest.Tables[0].Rows[0]["decBMI"]);
                decLatestHips = (Convert.IsDBNull(MyDataSetLatest.Tables[0].Rows[0]["decBodyFATPercentage"])) ? 0 : Convert.ToDecimal(MyDataSetLatest.Tables[0].Rows[0]["decBodyFATPercentage"]);
            }
        }
        decWeightChange = decBaselineWeight - decLatestWeight;
        decWaistChange = decBaselineWaist - decLatestWaist;
        decNeckChange = decBaselineNeck - decLatestNeck;
        decHipsChange = decBaselineHips - decLatestHips;

        if (decBaselineWeight > 0) decWeightPercentageChange = decWeightChange/decBaselineWeight;
        if (decBaselineWaist > 0) decWaistPercentageChange = decWaistChange/decBaselineWaist;
        if (decBaselineNeck > 0) decNeckPercentageChange = decNeckChange/decBaselineNeck;
        if (decBaselineHips > 0) decHipsPercentageChange = decHipsChange / decBaselineHips;

        textBaselineWeight.Text = decBaselineWeight.ToString();
        textBaselineWeight.ReadOnly = true;
        textLatestWeight.Text = decLatestWaist.ToString();
        textLatestWeight.Attributes.Add("onkeypress", "return (window.event.keyCode == 45 || window.event.keyCode == 13 || window.event.keyCode == 8 || window.event.keyCode == 9 || window.event.keyCode == 189 || window.event.keyCode == 109 || (window.event.keyCode >= 48 && window.event.keyCode <= 58) )");
        textChangeWeight.Text = decWeightChange.ToString();
        textChangeWeight.ReadOnly = true;
        textPercentChangeWeight.Text = decWeightPercentageChange.ToString();
        textPercentChangeWeight.ReadOnly = true;

        textBaselineWaist.Text = decBaselineWaist.ToString();
        textBaselineWaist.ReadOnly = true;
        textLatestWaist.Text = decLatestWaist.ToString();
        textLatestWaist.Attributes.Add("onkeypress", "return (window.event.keyCode == 45 || window.event.keyCode == 13 || window.event.keyCode == 8 || window.event.keyCode == 9 || window.event.keyCode == 189 || window.event.keyCode == 109 || (window.event.keyCode >= 48 && window.event.keyCode <= 58) )");
        textChangeWaist.Text = decWaistChange.ToString();
        textChangeWaist.ReadOnly = true;
        textPercentChangeWaist.Text = decWaistPercentageChange.ToString();
        textPercentChangeWaist.ReadOnly = true;

        textBaselineNeck.Text = decBaselineNeck.ToString();
        textBaselineNeck.ReadOnly = true;
        textLatestNeck.Text = decLatestNeck.ToString();
        textLatestNeck.Attributes.Add("onkeypress", "return (window.event.keyCode == 45 || window.event.keyCode == 13 || window.event.keyCode == 8 || window.event.keyCode == 9 || window.event.keyCode == 189 || window.event.keyCode == 109 || (window.event.keyCode >= 48 && window.event.keyCode <= 58) )");
        textChangeNeck.Text = decNeckChange.ToString();
        textChangeNeck.ReadOnly = true;
        textPercentChangeNeck.Text = decNeckPercentageChange.ToString();
        textPercentChangeNeck.ReadOnly = true;

        textBaselineHips.Text = decBaselineHips.ToString();
        textBaselineHips.ReadOnly = true;
        textLatestHips.Text = decLatestHips.ToString();
        textLatestHips.Attributes.Add("onkeypress", "return (window.event.keyCode == 45 || window.event.keyCode == 13 || window.event.keyCode == 8 || window.event.keyCode == 9 || window.event.keyCode == 189 || window.event.keyCode == 109 || (window.event.keyCode >= 48 && window.event.keyCode <= 58) )");
        textChangeHips.Text = decHipsChange.ToString();
        textChangeHips.ReadOnly = true;
        textPercentChangeHips.Text = decHipsPercentageChange.ToString();
        textPercentChangeHips.ReadOnly = true;

        hiddenPersonalSummaryId.Value = iLatestPersonalSummaryId.ToString();
        textEntryDate.Text = sDateSelected;
    }