//list everything from patient public List <patientInformation> getAllPatient(MySqlConnection conn) { List <patientInformation> listpatientInfo = new List <patientInformation>(); string sql = "SELECT * FROM patient WHERE 1"; MySqlCommand sqlComm = new MySqlCommand(sql, conn); try { MySqlDataReader myReader; myReader = sqlComm.ExecuteReader(); while (myReader.Read()) { patientInformation patientInfor = new patientInformation(); patientInfor.Id = (int)myReader.GetValue(0); patientInfor.NRIC = (int)myReader.GetValue(1); patientInfor.Fullname = (string)myReader.GetValue(2); patientInfor.Address = (string)myReader.GetValue(3); patientInfor.Email = (string)myReader.GetValue(4); patientInfor.Gender = (string)myReader.GetValue(5); patientInfor.PhoneNum = (int)myReader.GetValue(6); patientInfor.Age = (int)myReader.GetValue(7); patientInfor.BedsideId = (int)myReader.GetValue(8); listpatientInfo.Add(patientInfor); } } catch (Exception e) { Console.WriteLine(e.ToString()); } return(listpatientInfo); }
//display all patient info public int displayPatientInfo(MySqlConnection conn, patientInformation patientss) { string sql = "SELECT * FROM patient (id, NRIC, fullName, address, email, gender, phone, age, bedsideId) " + " VALUES ('" + patientss.Id + "','" + patientss.NRIC + "', " + patientss.Fullname + " , '" + patientss.Address + "','" + patientss.Email + "','" + patientss.Gender + "','" + patientss.PhoneNum + "','" + patientss.Age + "','" + patientss.BedsideId + "')"; MySqlCommand sqlComm = new MySqlCommand(sql, conn); return(sqlComm.ExecuteNonQuery()); }