private List <TestSetup> loadDataByTestId()
{
TestRequest testRequest = (TestRequest)ViewState["TestRequest"];
PatientsAndTest patientsAndTest = new PatientsAndTest();
patientsAndTest.PaitentId = testRequest.Id;
PatientsAndTest patients = testSetupManager.GetAllpaitentBytestreqId(patientsAndTest.PaitentId);
List <TestSetup> testSetups = testSetupManager.GetlistoftestbytestId(patients.TestId);
return(testSetups);
}
public PatientsAndTest GetAllpaitentBytestreqId(int Id)
{
SqlConnection connection = new SqlConnection(connectionString);
string quary = "Select * from PatientTest Where TestReqid='" + Id + "'";
SqlCommand command = new SqlCommand(quary, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
PatientsAndTest patients = new PatientsAndTest();
while (reader.Read())
{
PatientsAndTest patientsAndTest = new PatientsAndTest();
patientsAndTest.PaitentId = Convert.ToInt32(reader["TestReqid"].ToString());
patientsAndTest.TestId = Convert.ToInt32(reader["TestId"].ToString());
patients = patientsAndTest;
}
connection.Close();
reader.Close();
return(patients);
}
