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