public void TestAddNewPatient()
{
DatabaseConnertor databaseConnertor = new DatabaseConnertor();
string resp = databaseConnertor.connect();
Assert.AreEqual("Done", resp);
addPatient addPatient = new addPatient();
addPatient.P_firstName = "Test";
addPatient.P_lastName = "Man";
addPatient.P_age = 30;
addPatient.P_dob = DateTime.Now;
addPatient.P_contact = 140055544;
addPatient.P_emergencyContact = 184845656;
addPatient.P_gender = "Male";
addPatient.P_address = "Cheras";
addPatient.P_bedNum = 5;
addPatient.P_floor = "4";
addPatient.P_admission = DateTime.Now;
addPatientHandler addPatientHandler = new addPatientHandler();
int resp2 = addPatientHandler.addNewPatient(databaseConnertor.getconn(), addPatient);
Assert.AreEqual(1, resp2);
}
public bool getStudByID(addPatient ap)
{
dtable = patient.getStudByID(this);
if (dtable.Rows.Count > 0)
{
uid = dtable.Rows[0][0].ToString();
lastName = dtable.Rows[0][2].ToString();
firstName = dtable.Rows[0][3].ToString();
middleName = dtable.Rows[0][4].ToString();
department = dtable.Rows[0][5].ToString();
course = dtable.Rows[0][6].ToString();
year = dtable.Rows[0][7].ToString();
birthday = dtable.Rows[0][8].ToString();
if (dtable.Rows[0][9].ToString() != "")
{
age = Int32.Parse(dtable.Rows[0][9].ToString());
}
else
{
age = 0;
}
sex = dtable.Rows[0][10].ToString();
civilStatus = dtable.Rows[0][11].ToString();
nationality = dtable.Rows[0][12].ToString();
homeAddress = dtable.Rows[0][13].ToString();
boardingAddress = dtable.Rows[0][14].ToString();
fatherName = dtable.Rows[0][15].ToString();
fatherOccupation = dtable.Rows[0][16].ToString();
fatherNumber = dtable.Rows[0][17].ToString();
motherName = dtable.Rows[0][18].ToString();
motherOccupation = dtable.Rows[0][19].ToString();
motherNumber = dtable.Rows[0][20].ToString();
landladyName = dtable.Rows[0][21].ToString();
landladyNumber = dtable.Rows[0][22].ToString();
emergencyCall = dtable.Rows[0][23].ToString();
relation = dtable.Rows[0][24].ToString();
emergencyNumber = dtable.Rows[0][25].ToString();
firstMenstrualdate = dtable.Rows[0][26].ToString();
lastMenstrualdate = dtable.Rows[0][27].ToString();
if (dtable.Rows[0][28] != System.DBNull.Value)
{
byte[] img = (byte[])dtable.Rows[0][28];
MemoryStream ms = new MemoryStream(img);
ap.pbPhoto.Image = Image.FromStream(ms);
ap.pbPhoto.SizeMode = PictureBoxSizeMode.StretchImage;
ap.pbPhoto.Refresh();
}
valid = true;
}
return(valid);
}
public bool patientAdd(addPatient ap)
{
bool valid = false;
if (patient.patientAdd(this))
{
valid = true;
}
else
{
valid = false;
}
return(valid);
}
public bool patientAdd(addPatient ap)
{
return(valid = (patient.patientAdd(this)) ? true : false);
}