public void PopulateHospitalId()
{
if (usertype == "2")
{
db1.strCommand = "select HospitalID from Hospital hp " +
"inner join LoginTb lg on lg.LoginID=hp.LoginID where lg.Username='******' ";
hospid = db1.executescalar();
}
}
//function to select performance test ID
public void retrieve_performancename()
{
db1.strCommand = "select max(ValueID) from Performance_Values";
perfvalueid_hidden.Value = db1.executescalar();
db1.strCommand = "select Perf_TestName from PerformanceTest inner join Performance_Values " +
" on PerformanceTest.PerfID=Performance_Values.PerfID where Performance_Values.ValueID='" + perfvalueid_hidden.Value + "' ";
DataTable dt = db1.selecttable();
if (dt.Rows.Count > 0)
{
perf_namehidden.Value = dt.Rows[0]["Perf_TestName"].ToString();
}
}
public void select_Reportinfo()
{
db1.strCommand = "select max(Report_info_ID) from Report_Info";
reportid = db1.executescalar().ToString();
}
//function to select performance test ID
public void retrieve_performancetest()
{
db1.strCommand = "select max(PerfID) from PerformanceTest ";
perfid = db1.executescalar();
}