protected void lnkAddWaterAnalysis_OnCommand(object sender, CommandEventArgs e)
        {
            //add water analysis

            //get data on form
            WaterAnalysis wat = new WaterAnalysis();

            wat.ClearIron       = Convert.ToDecimal((fviewWaterAnalysis.FindControl("txtClearIron") as TextBox).Text);
            wat.Hardness        = Convert.ToDecimal((fviewWaterAnalysis.FindControl("txtHardness") as TextBox).Text);
            wat.HydrogenSulfide = Convert.ToDecimal((fviewWaterAnalysis.FindControl("txtHydrogenSulfide") as TextBox).Text);
            wat.PH_Acid         = Convert.ToDecimal((fviewWaterAnalysis.FindControl("txtPh") as TextBox).Text);
            wat.TDS             = Convert.ToDecimal((fviewWaterAnalysis.FindControl("txtTDS") as TextBox).Text);
            wat.AccountID       = _accountID;
            //save
            wat.ReportID = WaterAnalysisManager.Save(wat);

            //clear the fields
            (fviewWaterAnalysis.FindControl("txtClearIron") as TextBox).Text       = "";
            (fviewWaterAnalysis.FindControl("txtHardness") as TextBox).Text        = "";
            (fviewWaterAnalysis.FindControl("txtHydrogenSulfide") as TextBox).Text = "";
            (fviewWaterAnalysis.FindControl("txtPh") as TextBox).Text  = "";
            (fviewWaterAnalysis.FindControl("txtTDS") as TextBox).Text = "";

            //display in gridview
            gviewWaterAnalysis.DataSource = WaterAnalysisManager.GetList(_accountID);
            gviewWaterAnalysis.DataBind();
        }
 private void DisplayWaterAnalysis()
 {
     gviewWaterAnalysis.DataSource = WaterAnalysisManager.GetList(_accountID);
     gviewWaterAnalysis.DataBind();
 }