public PatientViewModel(Patient obj)
{
this._patientObj = new Patient();
Name = obj.name;
Surname = obj.surname;
Gender = obj.gender;
DateOfBirth = obj.dateOfBirth;
DateOfRegistration = obj.dateOfRegistration;
MobileNumber = obj.mobileNumber;
Email = obj.email;
CurrentlyUnderTreatment = obj.currentlyUnderTreatment;
PatientID = obj.patientID;
MedicalCardID = obj.medicalCardID;
}
public void registerNewPatient()
{
DateTime now = DateTime.Now;
_patient = new Patient(Name, Surname, Gender, DateOfBirth, Convert.ToInt32(MobileNumber), Email, now);
_receptionist = new Receptionist();
try
{
_receptionist.registerNewPatient(_patient);
_medicalCard = new MedicalCard(_patient.getPatientIDFromDb());
_receptionist.createMedicalCard(_medicalCard);
_receptionist.updatePatientMedicalCard(_patient, _medicalCard);
CloseAction.Invoke();
}
catch (MySqlException ex)
{
ErrorMessage = "Problem with writing data(MySQLException)";
}
}
public void registerNewPatient(Patient patient)
{
String query = String.Format("INSERT INTO Patients (name, surname, gender, dateOfBirth, mobileNumber, email, dateOfRegistration) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", patient.name, patient.surname, patient.gender, patient.dateOfBirth.ToString("yyyy-MM-dd"), patient.mobileNumber, patient.email, patient.dateOfRegistration.ToString("yyyy-MM-dd HH:mm:ss"));
_database.executeQuery(query);
}
public void openNewCase(Case caseObj, Patient patient)
{
String query = String.Format("INSERT INTO Cases (patientID, start_date, description) VALUES('{0}', '{1}', '{2}')", caseObj.patientID, caseObj.startDate.ToString("yyyy-MM-dd HH:mm:ss"), caseObj.description);
_database.executeQuery(query);
// patient.startTreatment();
}
public List<Appointment> getPatientAppointmentList(Patient patient)
{
return new List<Appointment>();
}
public List<Admission> getPatientAdmissionList(Patient patient)
{
return new List<Admission>();
}
public void createAdmission(Patient patient, int bedNumber, Doctor doctor)
{
}
public void updatePatientMedicalCard(Patient patient, MedicalCard medicalCardObj)
{
String query = String.Format("UPDATE Patients SET medicalCardID={0} WHERE patientID={1}", medicalCardObj.getMedicalCardIDFromDb(), patient.getPatientIDFromDb());
_database.executeQuery(query);
}
public void scheduleSurgery(Patient patient, DateTime date, Room room)
{
}
public String getLabTestResults(Patient patient)
{
String query = String.Format("SELECT result FROM Samples WHERE patient_id={0} AND doctor_id={1} AND tested=TRUE", patient.getPatientIDFromDb(), this.doctorID);
String result = this._database.selectSingleQuery(query);
return result;
}
public void closePatientCase(Case caseObj, Patient patient, DateTime date)
{
String query = String.Format("UPDATE Cases SET end_date='{0}' WHERE case_id={1}", date.ToString("yyyy-MM-dd"), caseObj.getCaseIDFromDb());
this._database.executeQuery(query);
patient.endTreatment();
}
