public List <ViewPatientHistory> GetPatient(long voterId)
{
int i = 0;
ASqlConnection.Open();
string query = "SELECT * FROM v_patient_history WHERE voter_id = '" + voterId + "' ORDER BY date";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlDataReader = ASqlCommand.ExecuteReader();
List <ViewPatientHistory> aViewPatientHistoryList = new List <ViewPatientHistory>();
while (ASqlDataReader.Read())
{
i++;
ViewPatientHistory aViewPatientHistory = new ViewPatientHistory();
aViewPatientHistory.CenterName = ASqlDataReader["name"].ToString();
aViewPatientHistory.HistoryNo = i;
aViewPatientHistoryList.Add(aViewPatientHistory);
}
ASqlDataReader.Close();
ASqlConnection.Close();
return(aViewPatientHistoryList);
}
public List <ViewPatientHistory> GetPatient(long voterId)
{
ASqlConnection.Open();
string query = "SELECT * FROM v_patient_history WHERE voter_id = '" + voterId + "'";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlCommand.CommandType = CommandType.Text;
ASqlDataReader = ASqlCommand.ExecuteReader();
List <ViewPatientHistory> aViewPatientHistoryList = new List <ViewPatientHistory>();
while (ASqlDataReader.Read())
{
ViewPatientHistory aViewPatientHistory = new ViewPatientHistory();
aViewPatientHistory.VoterId = (long)ASqlDataReader["voter_id"];
aViewPatientHistory.PatientId = (int)ASqlDataReader["patient_id"];
aViewPatientHistory.CenterName = ASqlDataReader["name"].ToString();
aViewPatientHistoryList.Add(aViewPatientHistory);
}
ASqlDataReader.Close();
ASqlConnection.Close();
return(aViewPatientHistoryList);
}