Exemplo n.º 1
0
    protected void DisplayResults()
    {
        SQL_utils sql = new SQL_utils("data");

        DataSet dset = sql.DataSet_from_SQLstring("exec spSleepInfo " + cboFile.Value);

        LoadSleepInfo(dset.Tables[0], "Diary Times");
        LoadSleepInfo(dset.Tables[1], "Compare Actiwatch and DB scoring");
        LoadSleepInfo(dset.Tables[2], "DB scoring");
        LoadSleepInfo(dset.Tables[3], "Actiwatch scoring");
        sql.Close();
    }
Exemplo n.º 2
0
    //protected void btnProcess_Click(object sender, EventArgs e)
    //{
    //    int docversid = Convert.ToInt32(cboFile.Value);
    //    int timepointid = Convert.ToInt32(cboTimeptID.Value);

    //    lbl.ForeColor = System.Drawing.Color.Black;

    //    if (docversid > 0 & timepointid > 0)
    //    {
    //        LoadActigraphy(docversid, timepointid);

    //    }
    //    else
    //    {
    //        lbl.Text = "Select a file and timepoint.";
    //        lbl.ForeColor = System.Drawing.Color.Red;
    //    }
    //}

    protected void DisplayResults()
    {
        SQL_utils sql = new SQL_utils("data");

        string  id   = sql.StringScalar_from_SQLstring(String.Format("select dbo.fnGetID_from_DocVersID('{0}')", cboFile.Value));
        DataSet dset = sql.DataSet_from_SQLstring("exec spSleepInfo " + cboFile.Value);


        ASPxLabel lbl = new ASPxLabel();

        lbl.EncodeHtml = false;
        lbl.Text       = String.Format("<br/>Actigraphy Details for {0}", id);
        lbl.Font.Size  = 14;
        lbl.Font.Bold  = true;

        panel.Controls.Add(lbl);
        LoadSleepInfo(dset.Tables[0], "Diary Times");
        LoadSleepInfo(dset.Tables[1], "Compare Actiwatch and DB scoring");
        LoadSleepInfo(dset.Tables[2], "DB scoring");
        LoadSleepInfo(dset.Tables[3], "Actiwatch scoring");
        sql.Close();
    }