public List <Diagnosis> SearchByName(string name)
{
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.diagnosis.Where(x => x.title.Contains(name) && x.deleted != true)
.Select(x => new Diagnosis()
{
id = x.id,
code = x.code,
title = x.title,
chapterId = x.chapter_id,
}).ToList());
}
}
public void SaveNurse(Nurse mNurse)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efNurse = context.nurses.Where(m => m.id == mNurse.id).FirstOrDefault();
if (efNurse == null)
{
efNurse = new DataAccess.nurse();
context.nurses.Add(efNurse);
}
efNurse.id = mNurse.id;
efNurse.medicRegistration = mNurse.medicRegistration;
context.SaveChanges();
}
}
public void SaveSpecialtie(NurseSpecialties mNurseSpecialties)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efNurseSpecialties = context.nurse_specialties.Where(m => m.Nurse_id == mNurseSpecialties.nurseId).FirstOrDefault();
if (efNurseSpecialties == null)
{
efNurseSpecialties = new DataAccess.nurse_specialties();
context.nurse_specialties.Add(efNurseSpecialties);
}
efNurseSpecialties.Nurse_id = mNurseSpecialties.nurseId;
efNurseSpecialties.specialties = mNurseSpecialties.specialties;
context.SaveChanges();
}
}
public Province GetProvinceById(long id)
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.provinces.Where(x => x.id == id && x.deleted != true)
.Select(x => new Province()
{
id = x.id,
name = x.name,
deleted = x.deleted,
departmentId = x.department_id
}).FirstOrDefault());
}
}
public List <Exam> GetAllExam()
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from ex in context.exams
where ex.deleted != true
select new Exam()
{
id = ex.id,
name = ex.name,
type = ex.type
}).ToList());
}
}
public List <Province> GetAllProvinceByName(string name)
{
using (var context = new DataAccess.registroclinicoEntities())
{
return((from c in context.provinces
where c.name.ToLower().Contains(name.ToLower())
select new Province()
{
deleted = c.deleted,
name = c.name,
id = c.id,
departmentId = c.department_id,
}).ToList());
}
}
public bool DeletePatientById(long id)
{
bool isSuccess = false;
using (var context = new DataAccess.registroclinicoEntities())
{
var efPatient = context.patients.Where(m => m.user_id == id).FirstOrDefault();
if (efPatient != null)
{
context.patients.Remove(efPatient);
context.SaveChanges();
isSuccess = true;
}
return(isSuccess);
}
}
public District GetDistrictById(long id)
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.districts.Where(x => x.id == id && x.deleted != true)
.Select(x => new District()
{
id = x.id,
name = x.name,
deleted = x.deleted,
provinceId = x.province_id,
ubigeo = x.ubigeo
}).FirstOrDefault());
}
}
public List <Province> GetAllProvince()
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from c in context.provinces
where c.deleted != true
select new Province()
{
deleted = c.deleted,
name = c.name,
id = c.id,
departmentId = c.department_id,
}).OrderBy(x => x.name).ToList());
}
}
public bool DeleteMedicById(long id)
{
bool isSuccess = false;
using (var context = new DataAccess.registroclinicoEntities())
{
var efMedics = context.medics.Where(m => m.id == id).FirstOrDefault();
if (efMedics != null)
{
context.medics.Remove(efMedics);
context.SaveChanges();
isSuccess = true;
}
return(isSuccess);
}
}
public bool DeleteExamById(long id)
{
bool isSuccess = false;
using (var context = new DataAccess.registroclinicoEntities())
{
var efExam = context.exams.Where(m => m.id == id).FirstOrDefault();
if (efExam != null)
{
efExam.deleted = true;//BitConverter.GetBytes(true);
context.SaveChanges();
isSuccess = true;
}
return(isSuccess);
}
}
public int SaveChapter(Chapter mChapter)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efChapter = context.chapters.Where(x => x.id == mChapter.id).FirstOrDefault();
if (efChapter == null)
{
efChapter = new DataAccess.chapter();
context.chapters.Add(efChapter);
}
efChapter.code = mChapter.code;
efChapter.title = mChapter.title;
context.SaveChanges();
return(Convert.ToInt16(efChapter.id));
}
}
public int SaveExam(Exam mExam)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efExam = context.exams.Where(x => x.id == mExam.id).FirstOrDefault();
if (efExam == null)
{
efExam = new DataAccess.exam();
context.exams.Add(efExam);
}
efExam.name = mExam.name;
efExam.type = mExam.type;
context.SaveChanges();
return(Convert.ToInt32(efExam.id));
}
}
public bool DeleteCardiovascularNoteById(long id)
{
bool isSuccess = false;
using (var context = new DataAccess.registroclinicoEntities())
{
var efCardiovascularnotes = context.cardiovascularnotes.Where(m => m.id == id).FirstOrDefault();
if (efCardiovascularnotes != null)
{
context.Entry(efCardiovascularnotes).State = EntityState.Deleted;
context.SaveChanges();
isSuccess = true;
}
return(isSuccess);
}
}
public void SavePatient(Patient mPatient)
{
try
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efPatients = context.patients.Where(m => m.id == mPatient.id).FirstOrDefault();
if (efPatients == null)
{
efPatients = new DataAccess.patient();
context.patients.Add(efPatients);
}
efPatients.id = mPatient.id;
efPatients.user_id = mPatient.userId;
efPatients.alcohol = mPatient.alcohol;
efPatients.bloodType = mPatient.bloodType;
efPatients.cigaretteNumber = mPatient.cigaretteNumber;
efPatients.createdTicket = mPatient.createdTicket;
efPatients.dormNumber = mPatient.dormNumber;
efPatients.educationalAttainment = mPatient.educationalAttainment;
efPatients.electricity = mPatient.electricity;
efPatients.fractureNumber = mPatient.fractureNumber;
efPatients.fruitsVegetables = mPatient.fruitsVegetables;
efPatients.highGlucose = mPatient.highGlucose;
efPatients.homeMaterial = mPatient.homeMaterial;
efPatients.homeOwnership = mPatient.homeOwnership;
efPatients.homeType = mPatient.homeType;
efPatients.occupation = mPatient.occupation;
efPatients.otherAllergies = mPatient.otherAllergies;
efPatients.otherFatherBackground = mPatient.otherFatherBackground;
efPatients.otherMedicines = mPatient.otherMedicines;
efPatients.otherMotherBackground = mPatient.otherMotherBackground;
efPatients.otherPersonalBackground = mPatient.otherPersonalBackground;
efPatients.physicalActivity = mPatient.physicalActivity;
efPatients.residentNumber = mPatient.residentNumber;
efPatients.sewage = mPatient.sewage;
efPatients.departmentId = mPatient.departmentId;
efPatients.water = mPatient.water;
context.SaveChanges();
mPatient.id = efPatients.id;
}
}
catch (DbEntityValidationException e)
{
throw;
}
}
public Country SaveCountry(Country mCountry)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efCountries = context.countries.Where(m => m.id == mCountry.id).FirstOrDefault();
if (efCountries == null)
{
efCountries = new DataAccess.country();
efCountries.deleted = true;// BitConverter.GetBytes(false);
context.countries.Add(efCountries);
}
efCountries.name = mCountry.name;
context.SaveChanges();
mCountry.id = efCountries.id;
}
return(mCountry);
}
public List <District> GetDistrictByprovinceId(long id)
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from c in context.districts
where c.deleted != true && c.province_id == id
select new District()
{
deleted = c.deleted,
name = c.name,
id = c.id,
provinceId = c.province_id,
ubigeo = c.ubigeo,
}).OrderBy(x => x.name).ToList());
}
}
public Triage SaveTriage(Triage triage)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efTriages = context.triages.Where(m => m.id == triage.id).FirstOrDefault();
if (efTriages == null)
{
efTriages = new DataAccess.triage();
efTriages.createdDate = DateTime.UtcNow;
efTriages.deleted = false;// BitConverter.GetBytes(false);
context.triages.Add(efTriages);
}
efTriages.abdominalPerimeter = triage.abdominalPerimeter;
efTriages.bmi = triage.bmi;
efTriages.breathingRate = triage.breathingRate;
efTriages.createdBy = triage.createdBy;
efTriages.deposition = triage.deposition;
efTriages.diastolicBloodPressure = triage.diastolicBloodPressure;
efTriages.glycemia = triage.glycemia;
efTriages.hdlCholesterol = triage.hdlCholesterol;
efTriages.heartRate = triage.heartRate;
efTriages.heartRisk = triage.heartRisk;
efTriages.hunger = triage.hunger;
efTriages.hypertensionRisk = triage.hypertensionRisk;
efTriages.ldlCholesterol = triage.ldlCholesterol;
efTriages.modifiedBy = triage.modifiedBy;
efTriages.modifiedDate = triage.modifiedDate;
efTriages.patient_id = triage.patientId;
efTriages.size = triage.size;
efTriages.sleep = triage.sleep;
efTriages.systolicBloodPressure = triage.systolicBloodPressure;
efTriages.temperature = triage.temperature;
efTriages.thirst = triage.thirst;
efTriages.ticket_id = triage.ticketId;
efTriages.totalCholesterol = triage.totalCholesterol;
efTriages.urine = triage.urine;
efTriages.weight = triage.weight;
efTriages.weightEvolution = triage.weightEvolution;
context.SaveChanges();
triage.id = efTriages.id;
}
return(triage);
}
public Medicine GetMedicineById(long id)
{
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.medicines.Where(x => x.id == id && x.deleted != false)
.Select(x => new Medicine()
{
id = x.id,
concentration = x.concentration,
form = x.form,
fractions = x.fractions,
healthRegistration = x.healthRegistration,
name = x.name,
owner = x.owner,
presentation = x.presentation
}).FirstOrDefault());
}
}
public Department SaveDepartment(Department mDepartment)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efDept = context.departments.Where(m => m.id == mDepartment.id).FirstOrDefault();
if (efDept == null)
{
efDept = new DataAccess.department();
efDept.deleted = true; // BitConverter.GetBytes(false);
context.departments.Add(efDept);
}
efDept.name = mDepartment.name;
efDept.country_id = mDepartment.country_id;
context.SaveChanges();
mDepartment.id = efDept.id;
}
return(mDepartment);
}
public int SaveDiagnosis(Diagnosis mDiagnosis)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efDiagnosis = context.diagnosis.Where(x => x.id == mDiagnosis.id).FirstOrDefault();
if (efDiagnosis == null)
{
efDiagnosis = new DataAccess.diagnosi();
context.diagnosis.Add(efDiagnosis);
//efDiagnosis.CreatedDate = DateTime.Now;
}
efDiagnosis.code = mDiagnosis.code;
efDiagnosis.title = mDiagnosis.title;
efDiagnosis.chapter_id = mDiagnosis.chapterId;
context.SaveChanges();
return(Convert.ToInt16(efDiagnosis.id));
}
}
public List <Diagnosis> GetAllDiagnosis()
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from dg in context.diagnosis
where dg.deleted != true
orderby dg.code ascending
select new Diagnosis()
{
id = dg.id,
code = dg.code,
title = dg.title,
chapterId = dg.chapter_id
}
).ToList());
}
}
public Note getByTicket(string serie, string nroTicket)
{
//var bytes = BitConverter.GetBytes(false);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from n in context.notes
join t in context.tickets on n.ticket.id equals t.id
where t.serie == serie && t.nroTicket == nroTicket &&
n.deleted != false && t.deleted != false
select new Domain.Note
{
age = n.age,
completed = n.completed,
control = n.control,
userId = n.user_id,
createdBy = n.createdBy,
createdDate = n.createdDate,
diagnosis = n.diagnosis,
deleted = n.deleted,
establishmentId = n.establishment_id,
exam = n.exam,
id = n.id,
medicId = n.medic_id,
modifiedBy = n.modifiedBy,
modifiedDate = n.modifiedDate,
physicalExam = n.physicalExam,
patientId = n.patient_id,
sicknessTime = n.sicknessTime,
sicknessUnit = n.sicknessUnit,
triageId = n.triage_id,
treatment = n.treatment,
ticketId = n.ticket_id,
symptom = n.symptom,
story = n.story,
stage = n.stage,
specialty = n.specialty,
secondOpinion = n.secondOpinion,
//patient = n.patient,
//note2 = n.note2,
//medic = n.medic,
//ticket = n.ticket
}).FirstOrDefault());
}
}
public Province SaveProvince(Province mProvince)
{
//var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
var efProvince = context.provinces.Where(m => m.id == mProvince.id && m.deleted != true).FirstOrDefault();
if (efProvince == null)
{
efProvince = new DataAccess.province();
efProvince.deleted = false;// BitConverter.GetBytes(false);
context.provinces.Add(efProvince);
}
efProvince.name = mProvince.name;
efProvince.department_id = mProvince.departmentId;
context.SaveChanges();
mProvince.id = efProvince.id;
}
return(mProvince);
}
public Department GetByName(string name)
{
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.departments.Where(x => x.name == name)
.Select(x => new Department()
{
id = x.id,
name = x.name,
deleted = x.deleted,
country = new Domain.Country
{
id = x.country.id,
name = x.country.name
},
country_id = x.country_id,
}).FirstOrDefault());
}
}
public List <Note> getByPatient(long?patientId = 0)
{
//var bytes = BitConverter.GetBytes(false);
//var bytesComplete = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return((from n in context.notes
where n.deleted != false && n.patient_id == patientId && n.completed == true
select new Note()
{
age = n.age,
completed = n.completed,
control = n.control,
userId = n.user_id,
createdBy = n.createdBy,
createdDate = n.createdDate,
diagnosis = n.diagnosis,
deleted = n.deleted,
establishmentId = n.establishment_id,
exam = n.exam,
id = n.id,
medicId = n.medic_id,
modifiedBy = n.modifiedBy,
modifiedDate = n.modifiedDate,
physicalExam = n.physicalExam,
patientId = n.patient_id,
sicknessTime = n.sicknessTime,
sicknessUnit = n.sicknessUnit,
triageId = n.triage_id,
treatment = n.treatment,
ticketId = n.ticket_id,
symptom = n.symptom,
story = n.story,
stage = n.stage,
specialty = n.specialty,
secondOpinion = n.secondOpinion,
//patient = n.patient,
//note2 = n.note2,
//medic = n.medic,
//ticket = n.ticket
}).ToList());
}
}
public Establishment GetEstablishmentById(long id)
{
var bytes = BitConverter.GetBytes(true);
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.establishments.Where(x => x.id == id && x.deleted != bytes)
.Select(x => new Establishment()
{
id = x.id,
name = x.name,
deleted = x.deleted,
address = x.address,
initials = x.initials,
establishmentType = x.establishmentType,
phone = x.phone
}).FirstOrDefault());
}
}
public Upload Upload(Upload mUpload)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efUpload = context.uploads.Where(m => m.id == mUpload.id).FirstOrDefault();
if (efUpload == null)
{
efUpload = new DataAccess.upload();
efUpload.createdDate = DateTime.UtcNow;
efUpload.deleted = false; /*BitConverter.GetBytes()*/
context.uploads.Add(efUpload);
}
efUpload.createdBy = mUpload.createdBy;
efUpload.path = mUpload.path;
context.SaveChanges();
mUpload.id = efUpload.id;
}
return(mUpload);
}
public Ticket SaveTicket(Ticket mTicket)
{
using (var context = new DataAccess.registroclinicoEntities())
{
var efTicket = context.tickets.Where(m => m.id == mTicket.id).FirstOrDefault();
if (efTicket == null)
{
efTicket = new DataAccess.ticket();
efTicket.deleted = false;// BitConverter.GetBytes(false);
context.tickets.Add(efTicket);
}
efTicket.closed = mTicket.closed;
efTicket.status = mTicket.status;
efTicket.serie = mTicket.serie;
efTicket.nroTicket = mTicket.nroTicket;
context.SaveChanges();
mTicket.id = efTicket.id;
}
return(mTicket);
}
public Country GetByName(string name)
{
using (var context = new DataAccess.registroclinicoEntities())
{
return(context.countries.Where(x => x.name == name)
.Select(x => new Country()
{
id = x.id,
name = x.name,
deleted = x.deleted,
departments = x.departments.Select(c => new Department()
{
country_id = c.country_id,
id = c.id,
name = c.name,
deleted = c.deleted
}).ToList()
}).FirstOrDefault());
}
}
