public void CreateClinicHistory(clinicHistory objClinicHistory)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.clinicHistories.Add(objClinicHistory);
dataContext.SaveChanges();
}
}
public clinicHistory GetClinicHistoryByPatientId(int patientid)
{
using (var dataContext = new FinalAppWebEntities())
{
var custs = from c in dataContext.clinicHistories
where c.patientId == patientid
select c;
clinicHistory objCH = custs.FirstOrDefault();
return(objCH);
}
}
private void btnCreateClinicHistory_Click(object sender, EventArgs e)
{
if (isANewHistory)
{
clinicHistory objClinicHistory = new clinicHistory();
objClinicHistory.patientId = idPatient;
objClinicHistory.weight = txtWeigth.Value;
objClinicHistory.height = txtHeigth.Value;
objClinicHistory.date = DateTime.Today.Date;
objClinicHistory.description = txtDescription.Text.ToString();
if (ckAlergias.Checked)
{
objClinicHistory.alergies = "si";
}
else
{
objClinicHistory.alergies = "no";
}
clinicHistoryService.CreateClinicHistory(objClinicHistory);
idPClinicHsitory = objClinicHistory.id;
this.load();
MessageBox.Show("Clinic History created");
enableTextboxCreateUpdateClinicHistory(true);
}
else
{
if (!isANewHistory)
{
clinicHistory objClinicHistory = clinicHistoryService.GetClinicHistoryByPatientId(idPatient);
idPClinicHsitory = objClinicHistory.id;
objClinicHistory.date = DateTime.Today;
objClinicHistory.weight = txtWeigth.Value;
objClinicHistory.height = txtHeigth.Value;
objClinicHistory.description = txtDateOfCreation.Text.ToString();
if (ckAlergias.Checked)
{
objClinicHistory.alergies = "si";
}
else
{
objClinicHistory.alergies = "no";
}
clinicHistoryService.UpdateClinicHistory(objClinicHistory);
MessageBox.Show("Clinic History updated");
}
}
}
public void UpdateClinicHistory(clinicHistory objClinicHistory)
{
using (var dataContext = new FinalAppWebEntities())
{
var trs = from t in dataContext.clinicHistories
where t.id == objClinicHistory.id
select t;
clinicHistory transaction = trs.FirstOrDefault();
//Update field by field
transaction.date = objClinicHistory.date;
transaction.weight = objClinicHistory.weight;
transaction.height = objClinicHistory.height;
transaction.description = objClinicHistory.description;
dataContext.SaveChanges();
}
}
//BUSCA DNI
private void btnBuscar_Click(object sender, EventArgs e)
{
//BUscar persona por DNI
int dni = Convert.ToInt32(txtDNI.Text);
person person = personServ.GetPersonByDni(dni);
//Validaicon de existencia de persona
if (person == null)
{
MessageBox.Show("La persona " + dni + " no se encutra registrada en el sistema");
}
else
{
patient patient = patientServ.GetPatientByPersonId(person.ID);
//validaicon es un paciente
if (patient == null)
{
MessageBox.Show("EL usuairo no es un paciente");
}
else
{
clinicHistory clinicHistory = clinicHistoryService.GetClinicHistoryByPatientId(patient.id);
//validaicon es un paciente
if (clinicHistory == null)
{
MessageBox.Show("EL paciente no tienie un historial clinico ");
}
else
{
allergy = clinicHistory.alergies;
IDclinicHistoy = clinicHistory.id;
cbSpeciality.Enabled = true;
txtHeigth.Text = clinicHistory.height.ToString();
txtWiegth.Text = clinicHistory.weight.ToString();
this.load();
}
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtDNI.Text.ToString().Length != 8)
{
MessageBox.Show("Invalid DNI. Try Again");
}
else
{
//DNI validos
int dni = Int32.Parse(txtDNI.Text.ToString());
DNI = dni;
//Guradmos persona
objPerson = personServ.GetPersonByDni(dni);
//SI existe (Perosna ya registrasa)(Update)
if (objPerson != null)
{
MessageBox.Show("Person: " + objPerson.name + " " + objPerson.lastName);
btnAdd.Text = "Update";
//Obtengo el usuario
String name = objPerson.name;
char firstletter = name[0];
int dniValue = Decimal.ToInt32(objPerson.DNI);
username = firstletter + dniValue.ToString();
//guardamos usuario
objUser = userService.GetUserByUsername(username);
enableTextboxUpdate(true);
isANewPerson = false;
//Coloco los datos en los textboxs
txtName.Text = objPerson.name;
txtLastName.Text = objPerson.lastName;
txtDNI2.Text = objPerson.DNI.ToString();
if (objPerson.gender.Equals("Male"))
{
cmbGender.SelectedIndex = 1;
}
else
{
cmbGender.SelectedIndex = 0;
}
numericAge.Value = objPerson.age;
numericPhoneNumber.Value = objPerson.phone;
dateOfBirth.Text = objPerson.dateOfBith.ToString();
txtEmail.Text = objPerson.email;
txtAddress.Text = objPerson.address;
txtNationality.Text = objPerson.nationality;
//Para ver si ya tinte i¿un clinic History
patient objPatient = patientServ.GetPatientByPersonId(objPerson.ID);
clinicHistory objClinicHistory = clinicHistoryService.GetClinicHistoryByPatientId(objPatient.id);
objClinicHistory = clinicHistoryService.GetClinicHistoryByPatientId(objPatient.id);
idPatient = objPatient.id;
if (objPatient == null)
{
MessageBox.Show("No es un paciente");
enableTextboxCreateUpdateClinicHistory(false);
btnAddAlergi.Enabled = false;
}
else
{
if (objClinicHistory == null)
{
enableTextboxCreateUpdateClinicHistory(true);
btnCreateClinicHistory.Text = "create clinic history";
MessageBox.Show("Person: " + objPerson.name + " " + objPerson.lastName + " no cuenta con una historia clinica");
isANewHistory = true;
txtDateOfCreation.Text = DateTime.Today.ToString();
btnAddAlergi.Enabled = false;
}
else
{
idPClinicHsitory = objClinicHistory.id;
this.load();
btnCreateClinicHistory.Text = "update clinic history";
MessageBox.Show("Person: " + objPerson.name + " " + objPerson.lastName + " cuenta con una historia clinica");
isANewHistory = false;
txtDateOfCreation.Text = objClinicHistory.date.ToString();
txtDescription.Text = objClinicHistory.description;
txtHeigth.Value = objClinicHistory.height.Value;
txtWeigth.Value = objClinicHistory.weight.Value;
enableTextboxCreateUpdateClinicHistory(true);
if (objClinicHistory.alergies.Equals("si"))
{
ckAlergias.Checked = true;
btnAddAlergi.Enabled = true;
}
else
{
ckAlergias.Checked = false;
btnAddAlergi.Enabled = false;
}
}
}
}
else
{
isANewPerson = true;
MessageBox.Show("New Person");
enableTextbox(true);
initialize();
}
}
}
public void UpdateClinicHistory(clinicHistory objClinicHistory)
{
IClinicHistoryRepository repo = new ClinicHistoryRepository();
repo.UpdateClinicHistory(objClinicHistory);
}
