public static ResponsePatient GetPatient(string identification)
{
PatientModel patient = null;
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
string SP = AppManagement.SP_GetPatient;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_id_patient", identification);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
patient = new PatientModel()
{
Identification = rdr["id_patient"].ToString(),
IdParent = rdr["id_parent"].ToString(),
Name = rdr["name"].ToString(),
BirthDate = Convert.ToDateTime(rdr["birth_date"]),
Age = Convert.ToInt32(rdr["age"]),
Ethnic = new EthnicModel()
{
Id = Convert.ToInt32(rdr["id_ethnic_group"]),
Name = rdr["ethnic_name"].ToString()
},
Gender = rdr["gender"].ToString()
};
}
}
}
if (patient.IsNotNull())
{
patient.Treatments = PatientTreatmentDeseaseModel.GetAllTreatmentDeseasest(patient.Identification).PatientTreatmentDeseases;
patient.Attachments = AttachmentsModel.GetAllAttachments(patient.Identification).ResponseAttachments;
patient.Cases = PatientCaseModel.GetAllPatientCases(patient.Identification).PatientCases;
}
return(new ResponsePatient {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_GetPatient_Success, Patient = patient
});
}
