public static void Update_MutualPorPaciente(MutualPorPacienteList MutualPorPacienteList, int pPatientId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MutualPorPaciente wMutual = null; foreach (MutualPorPacienteBE wMutualBE in MutualPorPacienteList) { if (wMutualBE.EntityState == Fwk.Bases.EntityState.Added) { wMutual = new MutualPorPaciente(); wMutual.IdPaciente = pPatientId; wMutual.IdMutual = wMutualBE.IdMutual; wMutual.NroAfiliadoMutual = wMutualBE.NroAfiliadoMutual; wMutual.IsActive = true; dc.MutualPorPacientes.AddObject(wMutual); } if (wMutualBE.EntityState == Fwk.Bases.EntityState.Changed) { wMutual = dc.MutualPorPacientes.Where(p => p.IdMutual.Equals(wMutualBE.IdMutual)).FirstOrDefault(); wMutual.NroAfiliadoMutual = wMutualBE.NroAfiliadoMutual; wMutual.IsActive = wMutualBE.IsActive; } } dc.SaveChanges(); } }
public static void Create(Health.BE.PersonaBE personaBE) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Health.Back.BE.Persona persona = new Health.Back.BE.Persona(); persona.UserId = personaBE.UserId; persona.Apellido = personaBE.Apellido; persona.Nombre = personaBE.Nombre; persona.NroDocumento = personaBE.NroDocumento; persona.TipoDocumento = personaBE.TipoDocumento; persona.IdEstadocivil = personaBE.IdEstadocivil; persona.FechaNacimiento = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(personaBE.FechaNacimiento); persona.FechaAlta = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(System.DateTime.Now); persona.LastAccessTime = persona.FechaAlta; persona.LastAccessUserId = personaBE.LastAccessUserId; persona.Street = personaBE.Street; persona.StreetNumber = personaBE.StreetNumber; persona.Floor = personaBE.Floor; persona.CountryId = personaBE.CountryId; persona.ProvinceId = personaBE.ProvinceId; persona.CityId = personaBE.CityId; persona.Neighborhood = personaBE.Neighborhood; persona.mail = personaBE.mail; persona.Telefono1 = personaBE.Telefono1; persona.Telefono2 = personaBE.Telefono2; persona.ZipCode = persona.ZipCode; persona.Foto = personaBE.Foto; dc.Personas.AddObject(persona); dc.SaveChanges(); personaBE.FechaAlta = persona.FechaAlta; personaBE.IdPersona = persona.IdPersona; } }
public static void Update(ResourceSchedulingList resourceSchedulingList, Guid userId) { ResourceScheduling r_db = null; DateTime updateDate = System.DateTime.Now; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (ResourceSchedulingBE rbe in resourceSchedulingList) { r_db = dc.ResourceSchedulings.Where(p => p.IdSheduler.Equals(rbe.IdSheduler)).FirstOrDefault <ResourceScheduling>(); r_db.UpdatedDate = updateDate; r_db.UpdateUserId = userId; r_db.DateEnd = rbe.DateEnd; r_db.DateStart = rbe.DateStart; r_db.Description = rbe.Description; r_db.Duration = rbe.Duration; r_db.TimeEnd = rbe.TimeEnd; r_db.TimeStart = rbe.TimeStart; r_db.WeekDays = rbe.WeekDays; } dc.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="pResourceSchedulingList"></param> /// <param name="userId"></param> public static void Create(ResourceSchedulingList pResourceSchedulingList,Guid userId) { ResourceScheduling r = null; DateTime creationDate = System.DateTime.Now; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (ResourceSchedulingBE rbe in pResourceSchedulingList) { r = new ResourceScheduling(); r.CreationDate = creationDate; r.CreationUserId = userId; r.DateEnd = rbe.DateEnd; r.DateStart = rbe.DateStart; r.Description = rbe.Description; r.Duration = rbe.Duration; r.TimeEnd = rbe.TimeEnd; r.TimeStart = rbe.TimeStart; r.ResourceId = rbe.ResourceId; r.WeekDays = rbe.WeekDays; r.HealthInstitutionId = rbe.HealthInstitutionId; dc.ResourceSchedulings.AddObject(r); } dc.SaveChanges(); } }
/// <summary> /// Por el momento representa Turnos otorgados a un profesional /// </summary> /// <param name="startDate">Fecha desde</param> /// <param name="status">Estado que del appointment se desea cunsultar</param> /// <param name="resourceId">Id a quien pertenezca el appointment</param> /// <returns>AppointmentList, Appointment con ProfesionalAppointment</returns> public static AppointmentList Retrive_ProfessionalAppointment(DateTime?startDate, int?status, int?resourseId = null, Guid?healthInstitutionId = null) { AppointmentList list = new AppointmentList(); if (startDate.HasValue) { startDate = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(startDate.Value); } using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var appointment_db = dc.Appointments.Where <Appointment>(p => (!startDate.HasValue || p.Start.Value >= startDate.Value) && (!status.HasValue || status.Value.Equals(p.Status.Value)) && (!resourseId.HasValue || p.ResourceId.Value.Equals(resourseId.Value)) && (!healthInstitutionId.HasValue || p.HealthInstitutionId.Value.Equals(healthInstitutionId.Value)) );//.OrderByDescending(sort=>sort.CreationDate); foreach (Appointment r in appointment_db) { AppointmentBE wAppoiment = (AppointmentBE)r; wAppoiment.ProfesionalAppointment = (ProfesionalAppointmentBE)r.ProfesionalAppointment; list.Add(wAppoiment); } } return(list); }
/// <summary> /// /// </summary> /// <param name="pResourceSchedulingList"></param> /// <param name="userId"></param> public static void Create(ResourceSchedulingList pResourceSchedulingList, Guid userId) { ResourceScheduling r = null; DateTime creationDate = System.DateTime.Now; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (ResourceSchedulingBE rbe in pResourceSchedulingList) { r = new ResourceScheduling(); r.CreationDate = creationDate; r.CreationUserId = userId; r.DateEnd = rbe.DateEnd; r.DateStart = rbe.DateStart; r.Description = rbe.Description; r.Duration = rbe.Duration; r.TimeEnd = rbe.TimeEnd; r.TimeStart = rbe.TimeStart; r.ResourceId = rbe.ResourceId; r.WeekDays = rbe.WeekDays; r.HealthInstitutionId = rbe.HealthInstitutionId; dc.ResourceSchedulings.AddObject(r); } dc.SaveChanges(); } }
public static void Create(Health.BE.PersonaBE personaBE) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Health.Back.BE.Persona persona = new Health.Back.BE.Persona(); persona.UserId = personaBE.UserId; persona.Apellido = personaBE.Apellido; persona.Nombre = personaBE.Nombre; persona.NroDocumento = personaBE.NroDocumento; persona.TipoDocumento = personaBE.TipoDocumento; persona.IdEstadocivil = personaBE.IdEstadocivil; persona.FechaNacimiento = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(personaBE.FechaNacimiento); persona.FechaAlta = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(System.DateTime.Now); persona.LastAccessTime = persona.FechaAlta; persona.LastAccessUserId = personaBE.LastAccessUserId; persona.Calle = personaBE.Calle; persona.CalleNumero = personaBE.CalleNumero; persona.Piso = personaBE.Piso; persona.IdPais = personaBE.IdPais; persona.IdProvincia = personaBE.IdProvincia; persona.IdLocalidad = personaBE.IdLocalidad; persona.Barrio = personaBE.Barrio; persona.mail = personaBE.mail; persona.Telefono1 = personaBE.Telefono1; persona.Telefono2 = personaBE.Telefono2; persona.Foto = personaBE.Foto; dc.Personas.AddObject(persona); dc.SaveChanges(); personaBE.FechaAlta = persona.FechaAlta; personaBE.IdPersona = persona.IdPersona; } }
/// <summary> /// /// </summary> /// <param name="nombre"></param> /// <param name="apellido"></param> /// <returns></returns> public static List<PersonaBE> SearchByParams(string nombre, string apellido) { List<PersonaBE> wPersonasBEList = new List<PersonaBE>(); List<Persona> wPersonas = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { if (String.IsNullOrEmpty(nombre) || String.IsNullOrEmpty(apellido)) wPersonas = dc.Personas.ToList<Persona>(); else { var Personas = from p in dc.Personas where (String.IsNullOrEmpty(nombre) || p.Nombre.Contains(nombre) || (String.IsNullOrEmpty(apellido) || p.Apellido.Contains(apellido))) select p; wPersonas = Personas.ToList<Persona>(); } foreach (Persona p in wPersonas) { wPersonasBEList.Add( (PersonaBE)p); } } return wPersonasBEList; }
static List <CEI10_Temp> Retrive_Temporal_All() { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { return(dc.CEI10_Temp.ToList <CEI10_Temp>()); } }
static void Insert(CEI_10List list) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { CEI_10 wCEI_10; try { foreach (CEI_10BE c in list) { //falla i10 wCEI_10 = new CEI_10(); wCEI_10.ParentCode = c.ParentCode.Trim(); wCEI_10.Code = c.Code.Trim(); wCEI_10.Description = c.Description; wCEI_10.HasChilds = c.HasChilds; dc.CEI_10.AddObject(wCEI_10); dc.SaveChanges(); } } catch (Exception ex) { throw ex; } } }
/// <summary> /// Determina si es padre /// </summary> /// <param name="healthInstitutionId"></param> /// <returns></returns> public static bool IsParent(Guid healthInstitutionId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { return(dc.HealthInstitutions.Any(s => s.HealthInstitutionId.Equals(healthInstitutionId) && !s.HealthInstitutionIdParent.HasValue)); } }
/// <summary> /// Asigna y/o crea un rol /// </summary> /// <param name="pHealthInstitutionId"></param> /// <param name="pProfesionalId_ToAssign"></param> /// <param name="pUserId"></param> /// <param name="roleName"></param> public static void Profesional_UsersInRoles_Assign(Guid pHealthInstitutionId, Int32 pProfesionalId_ToAssign, Guid pUserId, string roleName) { Back.BE.HealthInstitution_Profesional wHealthInstitution_Profesional = new Back.BE.HealthInstitution_Profesional(); Back.BE.HealtInstitute_UsersInRoles wHealtInstitute_UsersInRoles = new BE.HealtInstitute_UsersInRoles(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { //Si no existe la relacion del profesional con la inst.. se genera if (!dc.HealthInstitution_Profesional.Any(p => p.HealthInstitutionId.Equals(pHealthInstitutionId) && p.Profesional.IdProfesional.Equals(pProfesionalId_ToAssign))) { wHealthInstitution_Profesional.HealthInstitutionId = pHealthInstitutionId; wHealthInstitution_Profesional.ProfesionalId = pProfesionalId_ToAssign; wHealthInstitution_Profesional.UserId = pUserId; wHealthInstitution_Profesional.IsLockedOut = false; wHealthInstitution_Profesional.ActiveFlag = true; if (roleName.Equals("inst_owner") || roleName.Equals("inst_admin")) { wHealthInstitution_Profesional.IsAdmin = roleName.Equals("inst_admin"); wHealthInstitution_Profesional.IsOwner = roleName.Equals("inst_owner"); } dc.HealthInstitution_Profesional.AddObject(wHealthInstitution_Profesional); } wHealtInstitute_UsersInRoles.UserId = pUserId; wHealtInstitute_UsersInRoles.HealthInstitutionId = pHealthInstitutionId; wHealtInstitute_UsersInRoles.RoleName = roleName; dc.HealtInstitute_UsersInRoles.AddObject(wHealtInstitute_UsersInRoles); dc.SaveChanges(); } }
public static void UpdateMedicalEvent(MedicalEventBE medicalEvent, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MedicalEvent medicalEvent_db = dc.MedicalEvents.Where(p => p.MedicalEventId.Equals(medicalEvent.MedicalEventId)).FirstOrDefault<MedicalEvent>(); medicalEvent_db.MedicalEventId_Parent = medicalEvent.MedicalEventId_Parent; medicalEvent_db.ProfesionalId = medicalEvent.ProfesionalId; medicalEvent_db.PatientId = medicalEvent.PatientId; medicalEvent_db.IdEspesialidad = medicalEvent.IdEspesialidad; medicalEvent_db.IdTipoConsulta = medicalEvent.IdTipoConsulta; medicalEvent_db.Motivo = medicalEvent.Motivo; medicalEvent_db.Evolucion = medicalEvent.Evolucion; medicalEvent_db.MetodoComplementario = medicalEvent.MetodoComplementario; medicalEvent_db.AppointmentId = medicalEvent.AppointmentId; medicalEvent_db.HealthInstitutionId = medicalEvent.HealthInstitutionId; //medicalEvent_db.CreatedDate = System.DateTime.Now; //medicalEvent_db.CreatedUserId = createdUserId; dc.SaveChanges(); } }
public static void Update(ResourceSchedulingList resourceSchedulingList, Guid userId) { ResourceScheduling r_db = null; DateTime updateDate = System.DateTime.Now; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (ResourceSchedulingBE rbe in resourceSchedulingList) { r_db = dc.ResourceSchedulings.Where(p => p.IdSheduler.Equals(rbe.IdSheduler)).FirstOrDefault<ResourceScheduling>(); r_db.UpdatedDate = updateDate; r_db.UpdateUserId = userId; r_db.DateEnd = rbe.DateEnd; r_db.DateStart = rbe.DateStart; r_db.Description = rbe.Description; r_db.Duration = rbe.Duration; r_db.TimeEnd = rbe.TimeEnd; r_db.TimeStart = rbe.TimeStart; r_db.WeekDays = rbe.WeekDays; } dc.SaveChanges(); } }
public static void UpdateMedicalEvent(MedicalEventBE medicalEvent, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MedicalEvent medicalEvent_db = dc.MedicalEvents.Where(p => p.MedicalEventId.Equals(medicalEvent.MedicalEventId)).FirstOrDefault <MedicalEvent>(); medicalEvent_db.MedicalEventId_Parent = medicalEvent.MedicalEventId_Parent; medicalEvent_db.ProfesionalId = medicalEvent.ProfesionalId; medicalEvent_db.PatientId = medicalEvent.PatientId; medicalEvent_db.IdEspesialidad = medicalEvent.IdEspesialidad; medicalEvent_db.IdTipoConsulta = medicalEvent.IdTipoConsulta; medicalEvent_db.Motivo = medicalEvent.Motivo; medicalEvent_db.Evolucion = medicalEvent.Evolucion; medicalEvent_db.MetodoComplementario = medicalEvent.MetodoComplementario; medicalEvent_db.AppointmentId = medicalEvent.AppointmentId; medicalEvent_db.HealthInstitutionId = medicalEvent.HealthInstitutionId; //medicalEvent_db.CreatedDate = System.DateTime.Now; //medicalEvent_db.CreatedUserId = createdUserId; dc.SaveChanges(); } }
public static List<PatientBE> SearchByParams(string nombre, string apellido) { List<PatientBE> wPatientsBEList = new List<PatientBE>(); List<Patient> wPatients = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { if (String.IsNullOrEmpty(nombre) || String.IsNullOrEmpty(apellido)) wPatients = dc.Patients.ToList<Patient>(); else { var Patients = from p in dc.Patients where (String.IsNullOrEmpty(nombre) || p.Persona.Nombre.Contains(nombre) || (String.IsNullOrEmpty(apellido) || p.Persona.Apellido.Contains(apellido))) select p; wPatients = Patients.ToList<Patient>(); } PatientBE wPatientBE = null; foreach (Patient p in wPatients) { wPatientBE = (PatientBE)p; wPatientBE.IdPersona = p.Persona.IdPersona; wPatientBE.Persona = (PersonaBE)p.Persona; wPatientsBEList.Add(wPatientBE); } } return wPatientsBEList; }
public static void UpdatePatientAllergy(PatientAllergyBE patientAllergyBE, Guid lastAccessUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientAllergy patientAllergy_db = dc.PatientAllergies.Where(p => p.PatientId.Equals(patientAllergyBE.PatientId)).FirstOrDefault <PatientAllergy>(); patientAllergy_db.AnimalAllergy = patientAllergyBE.AnimalAllergy; patientAllergy_db.ChemicalAllergy = patientAllergyBE.ChemicalAllergy; patientAllergy_db.FoodAllergy = patientAllergyBE.FoodAllergy; patientAllergy_db.InsectAllergy = patientAllergyBE.InsectAllergy; patientAllergy_db.MedicamentsAllergy = patientAllergyBE.MedicamentsAllergy; patientAllergy_db.MiteAllergy = patientAllergyBE.MiteAllergy; patientAllergy_db.PollenAllergy = patientAllergyBE.PollenAllergy; patientAllergy_db.SunAllergy = patientAllergyBE.SunAllergy; patientAllergy_db.Observation = patientAllergyBE.Observation; patientAllergy_db.OtherAllergy = patientAllergyBE.OtherAllergy; patientAllergy_db.GeneralDetails = patientAllergyBE.GeneralDetails; patientAllergy_db.Enabled = patientAllergyBE.Enabled; patientAllergy_db.LastAccessTime = System.DateTime.Now; patientAllergy_db.LastAccessUserId = lastAccessUserId; dc.SaveChanges(); } }
public static void CreatePatientAllergy(PatientAllergyBE patientAllergyBE, Guid lastAccessUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientAllergy patientAllergy_db = new PatientAllergy(); patientAllergy_db.PatientId = patientAllergyBE.PatientId; patientAllergy_db.AnimalAllergy = patientAllergyBE.AnimalAllergy; patientAllergy_db.ChemicalAllergy = patientAllergyBE.ChemicalAllergy; patientAllergy_db.FoodAllergy = patientAllergyBE.FoodAllergy; patientAllergy_db.InsectAllergy = patientAllergyBE.InsectAllergy; patientAllergy_db.MedicamentsAllergy = patientAllergyBE.MedicamentsAllergy; patientAllergy_db.MiteAllergy = patientAllergyBE.MiteAllergy; patientAllergy_db.PollenAllergy = patientAllergyBE.PollenAllergy; patientAllergy_db.SunAllergy = patientAllergyBE.SunAllergy; patientAllergy_db.Observation = patientAllergyBE.Observation; patientAllergy_db.OtherAllergy = patientAllergyBE.OtherAllergy; patientAllergy_db.GeneralDetails = patientAllergyBE.GeneralDetails; patientAllergy_db.MedicalEventId = patientAllergyBE.MedicalEventId; patientAllergy_db.Enabled = true; patientAllergy_db.LastAccessTime = System.DateTime.Now; patientAllergy_db.LastAccessUserId = lastAccessUserId; dc.PatientAllergies.AddObject(patientAllergy_db); dc.SaveChanges(); } }
public static List <PatientBE> SearchByParams(string nombre, string apellido) { List <PatientBE> wPatientsBEList = new List <PatientBE>(); List <Patient> wPatients = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { if (String.IsNullOrEmpty(nombre) || String.IsNullOrEmpty(apellido)) { wPatients = dc.Patients.ToList <Patient>(); } else { var Patients = from p in dc.Patients where (String.IsNullOrEmpty(nombre) || p.Persona.Nombre.Contains(nombre) || (String.IsNullOrEmpty(apellido) || p.Persona.Apellido.Contains(apellido))) select p; wPatients = Patients.ToList <Patient>(); } PatientBE wPatientBE = null; foreach (Patient p in wPatients) { wPatientBE = (PatientBE)p; wPatientBE.IdPersona = p.Persona.IdPersona; wPatientBE.Persona = (PersonaBE)p.Persona; wPatientsBEList.Add(wPatientBE); } } return(wPatientsBEList); }
public static void AddPatientMedicaments(PatientMedicament_ViewBE patientMedicament_View, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientMedicament patientMedicament_db = new PatientMedicament(); patientMedicament_db.Status = patientMedicament_View.Status; patientMedicament_db.MedicalEventId = patientMedicament_View.MedicalEventId; patientMedicament_db.PatientId = patientMedicament_View.PatientId; if (patientMedicament_View.PatientMedicamentId_Parent >= 0) { patientMedicament_db.PatientMedicamentId_Parent = patientMedicament_View.PatientMedicamentId_Parent; } patientMedicament_db.MedicamentName = patientMedicament_View.MedicamentName; patientMedicament_db.MedicamentPresentation = patientMedicament_View.MedicamentPresentation; patientMedicament_db.Dosis = patientMedicament_View.Dosis; patientMedicament_db.Periodicity_hours = patientMedicament_View.Periodicity_hours; patientMedicament_db.CreatedDate = System.DateTime.Now; patientMedicament_db.CreatedUserId = createdUserId; patientMedicament_db.DaysCount = patientMedicament_View.DaysCount; patientMedicament_db.Enabled = true; dc.PatientMedicaments.AddObject(patientMedicament_db); dc.SaveChanges(); } }
public static int CreateMedicalEvent(MedicalEventBE medicalEvent, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MedicalEvent medicalEvent_db = new MedicalEvent(); medicalEvent_db.MedicalEventId_Parent = medicalEvent.MedicalEventId_Parent; medicalEvent_db.ProfesionalId = medicalEvent.ProfesionalId; medicalEvent_db.PatientId = medicalEvent.PatientId; medicalEvent_db.IdEspesialidad = medicalEvent.IdEspesialidad; medicalEvent_db.IdTipoConsulta = medicalEvent.IdTipoConsulta; medicalEvent_db.Motivo = medicalEvent.Motivo; medicalEvent_db.MetodoComplementario = medicalEvent.MetodoComplementario; medicalEvent_db.Evolucion = medicalEvent.Evolucion; medicalEvent_db.AppointmentId = medicalEvent.AppointmentId; medicalEvent_db.CreatedDate = System.DateTime.Now; medicalEvent_db.CreatedUserId = createdUserId; medicalEvent_db.HealthInstitutionId = medicalEvent.HealthInstitutionId; dc.MedicalEvents.AddObject(medicalEvent_db); dc.SaveChanges(); return medicalEvent_db.MedicalEventId; } }
public static bool Existe(string pNombre) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { return(dc.Mutuals.Any <Mutual>(p => p.Nombre.Equals(pNombre))); } }
/// <summary> /// Retorna profecionales directamente relacionados in la inst /// Retorna Profesional_FullViewBE /// </summary> /// <param name="healthInstId"></param> /// <returns></returns> public static List<Profesional_FullViewBE> SearchBy_HealthInstRelated(Guid healthInstId, List<Int32> prof_ids_JustRetrived = null) { Profesional_FullViewList wProfesionalsBEList = new Profesional_FullViewList(); Profesional_FullViewBE wProfesionalBE=null; if (prof_ids_JustRetrived == null) prof_ids_JustRetrived = new List<int>(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { //Profecionales de la institucion var wProfesionals_DB = from p in dc.Profesional_FullView from hp in dc.HealthInstitution_Profesional where hp.HealthInstitutionId.Equals(healthInstId) && hp.ProfesionalId.Equals(p.IdProfesional) && (prof_ids_JustRetrived.Count().Equals(0) || !prof_ids_JustRetrived.Contains(p.IdProfesional)) //Exeptua los just retriveds select p; foreach (var item in wProfesionals_DB) { wProfesionalBE = (Profesional_FullViewBE)item; //wProfesionalBE.HealthInstitution_Profesional = (HealthInstitution_ProfesionalBE)item.Prof_hp; wProfesionalsBEList.Add(wProfesionalBE); } } return wProfesionalsBEList; }
/// <summary> /// /// </summary> /// <param name="nombre"></param> /// <param name="apellido"></param> /// <returns></returns> public static List<Profesional_FullViewBE> SearchByParams(string nombre, string apellido) { Profesional_FullViewList wProfesionalsBEList = new Profesional_FullViewList(); List<Profesional_FullView> wProfesionals = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { if (String.IsNullOrEmpty(nombre) || String.IsNullOrEmpty(apellido)) wProfesionals = dc.Profesional_FullView.ToList<Profesional_FullView>(); else { var Profesionals = from p in dc.Profesional_FullView where (String.IsNullOrEmpty(nombre) || p.Nombre.Contains(nombre) || (String.IsNullOrEmpty(apellido) || p.Apellido.Contains(apellido))) select p; wProfesionals = Profesionals.ToList<Profesional_FullView>(); } Profesional_FullViewBE wProfesionalBE = null; foreach (Profesional_FullView p in wProfesionals) { wProfesionalBE = (Profesional_FullViewBE)p; wProfesionalsBEList.Add(wProfesionalBE); } } return wProfesionalsBEList; }
/// <summary> /// Retorna MedicalEventDetail_ViewList del propieo evento y de eventos anteriores que sean relevante y esten con relevancia activa /// </summary> /// <param name="patientId"></param> /// <param name="medicalEventId"></param> /// <returns></returns> public static MedicalEventDetail_ViewList Retrive_MedicalEventDetail_ViewList_Patinet(int patientId) { MedicalEventDetail_ViewList list = new MedicalEventDetail_ViewList(); try { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var details_from_others_Events = dc.MedicalEventDetail_View.Where(p => p.PatientId.Equals(patientId) && p.RelevanceType.HasValue && p.ActiveRelevance.Value.Equals(true)); foreach (MedicalEventDetail_View item_db in details_from_others_Events) { list.Add((MedicalEventDetail_ViewBE)item_db); } } } catch (Exception ex) { throw ex; } return(list); }
public static int CreateMedicalEvent(MedicalEventBE medicalEvent, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MedicalEvent medicalEvent_db = new MedicalEvent(); medicalEvent_db.MedicalEventId_Parent = medicalEvent.MedicalEventId_Parent; medicalEvent_db.ProfesionalId = medicalEvent.ProfesionalId; medicalEvent_db.PatientId = medicalEvent.PatientId; medicalEvent_db.IdEspesialidad = medicalEvent.IdEspesialidad; medicalEvent_db.IdTipoConsulta = medicalEvent.IdTipoConsulta; medicalEvent_db.Motivo = medicalEvent.Motivo; medicalEvent_db.MetodoComplementario = medicalEvent.MetodoComplementario; medicalEvent_db.Evolucion = medicalEvent.Evolucion; medicalEvent_db.AppointmentId = medicalEvent.AppointmentId; medicalEvent_db.CreatedDate = System.DateTime.Now; medicalEvent_db.CreatedUserId = createdUserId; medicalEvent_db.HealthInstitutionId = medicalEvent.HealthInstitutionId; dc.MedicalEvents.AddObject(medicalEvent_db); dc.SaveChanges(); return(medicalEvent_db.MedicalEventId); } }
/// <summary> /// retorna medicamentos de unevento determinado y /// </summary> /// <param name="patientId"></param> /// <param name="medicalEventId"></param> /// <returns></returns> public static PatientMedicament_ViewList RetrivePatientMedicaments(int patientId, int medicalEventId, bool includePermanets) { PatientMedicament_ViewList list = new PatientMedicament_ViewList(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var list_db = dc.PatientMedicament_View.Where( p => p.PatientId.Equals(patientId) && p.MedicalEventId.Equals(medicalEventId) ); if (includePermanets) { var list_Permanent_db = dc.PatientMedicament_View.Where( p => p.PatientId.Equals(patientId) && !p.MedicalEventId.Equals(medicalEventId) && (p.Status.Equals((int)MedicamentStatus.Permanente) && p.Enabled )); foreach (PatientMedicament_View patientMedicament_db in list_Permanent_db) { list.Add((PatientMedicament_ViewBE)patientMedicament_db); } } foreach (PatientMedicament_View patientMedicament_db in list_db) { list.Add((PatientMedicament_ViewBE)patientMedicament_db); } } return(list); }
public static void Update(PatientBE Patient) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Patient wPatient = dc.Patients.Where(p => p.PatientId.Equals(Patient.PatientId)).FirstOrDefault <Patient>(); wPatient.Persona.Apellido = Patient.Persona.Apellido; wPatient.Persona.Nombre = Patient.Persona.Nombre; wPatient.Persona.NroDocumento = Patient.Persona.NroDocumento; wPatient.Persona.TipoDocumento = Patient.Persona.TipoDocumento; wPatient.Persona.IdEstadocivil = Patient.Persona.IdEstadocivil; wPatient.Persona.FechaNacimiento = Patient.Persona.FechaNacimiento; wPatient.Persona.Sexo = Patient.Persona.Sexo; wPatient.Persona.Street = Patient.Persona.Street; wPatient.Persona.StreetNumber = Patient.Persona.StreetNumber; wPatient.Persona.Floor = Patient.Persona.Floor; wPatient.Persona.CountryId = Patient.Persona.CountryId; wPatient.Persona.ProvinceId = Patient.Persona.ProvinceId; wPatient.Persona.CityId = Patient.Persona.CityId; wPatient.Persona.Neighborhood = Patient.Persona.Neighborhood; wPatient.Persona.mail = Patient.Persona.mail; wPatient.Persona.Telefono1 = Patient.Persona.Telefono1; wPatient.Persona.Telefono2 = Patient.Persona.Telefono2; wPatient.Persona.Foto = Patient.Persona.Foto; wPatient.LastAccessTime = System.DateTime.Now; wPatient.LastAccessUserId = Patient.LastAccessUserId; wPatient.Persona.LastAccessTime = wPatient.LastAccessTime.Value; wPatient.Persona.LastAccessUserId = Patient.Persona.LastAccessUserId; dc.SaveChanges(); } }
public static bool Exist(String nroDocumento) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { return dc.Personas.Any<Persona>(p => p.NroDocumento.Equals(nroDocumento)); } }
private void gridView1_MouseDown(object sender, MouseEventArgs e) { // if (e.Button != MouseButtons.Right) return; _HitInfo = gridView1.CalcHitInfo(new Point(e.X, e.Y)); SelectedPersona = ((PersonaBE)gridView1.GetRow(_HitInfo.RowHandle)); HealthEntities dc = new HealthEntities (); dc.Personas. }
/// <summary> /// /// </summary> /// <param name="activationKey"></param> /// <returns></returns> public static HealthInstitutionBE ValidateCode(String activationKey) { HealthInstitutionBE wHealthInstitutionBE = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var wHealthInstitution = dc.HealthInstitutions.Where(p => p.ActivationKey.Equals(activationKey)).FirstOrDefault<Health.Back.BE.HealthInstitution>(); if (wHealthInstitution != null) wHealthInstitutionBE = new HealthInstitutionBE(wHealthInstitution); return wHealthInstitutionBE; } }
public static PatientBE GetByDoc(int nroDocumento) { PatientBE wPatient = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Patient Patient = dc.Patients.Where(p => p.Persona.NroDocumento.Equals(nroDocumento)).FirstOrDefault<Patient>(); wPatient = (PatientBE)Patient; wPatient.Persona = (PersonaBE)Patient.Persona; } return wPatient; }
public static void Create(MutualBE pMutualBE) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Mutual wMutual = new Mutual(); wMutual.Nombre = pMutualBE.Nombre; wMutual.ExigeCoseguro = pMutualBE.ExigeCoseguro; dc.Mutuals.AddObject(wMutual); dc.SaveChanges(); wMutual.IdMutual = wMutual.IdMutual; } }
public static CEI_10List Retrive_All() { CEI_10List list = new CEI_10List(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (CEI_10BE c in dc.CEI_10) { list.Add((CEI_10BE)c); } } return list; }
public static MutualList RetriveAll() { MutualList list = new MutualList(); MutualBE wMutualBE ; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (Mutual m_db in dc.Mutuals) { wMutualBE = (MutualBE)m_db; list.Add( wMutualBE); } } return list; }
public static CEI_10List Retrive_All_ChildsOnly() { CEI_10List list = new CEI_10List(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { CEI_10BE c; foreach (CEI_10 item in dc.CEI_10.Where(p => p.HasChilds.Equals(false))) { //list.Add((CEI_10BE)c); c = new CEI_10BE(); c.Code = item.Code; c.Description = item.Description; list.Add(c); } } return list; }
/// <summary> /// Elimina rol a Institución /// Si es inst_owner o inst_admin establece .IsAdmin o.IsOwbner a falce respectivamente y posteriormente elimina el rol /// Si NO : l SOLO Elimina el rol /// </summary> /// <param name="pHealthInstitutionId"></param> /// <param name="userId"></param> /// <param name="rolName"></param> public static void Profesional_RemoveRol(Guid pHealthInstitutionId, Int32 pProfesionalId, Guid userId, string rolName) { Back.BE.HealthInstitution_Profesional wHealthInstitution_Profesional = null; Back.BE.HealtInstitute_UsersInRoles wHealtInstitute_UsersInRoles = null; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { wHealthInstitution_Profesional = dc.HealthInstitution_Profesional.Where(p => p.HealthInstitutionId.Equals(pHealthInstitutionId) && p.Profesional.IdProfesional.Equals(pProfesionalId)).FirstOrDefault(); //Si solo queda un unico rol el cual sera removido el usuario queda automaticamente en estado no vigente if (dc.HealtInstitute_UsersInRoles.Count(p => p.UserId.Equals(userId) && p.HealthInstitutionId.Equals(pHealthInstitutionId)) == 1) { wHealthInstitution_Profesional.ActiveFlag = false; wHealthInstitution_Profesional.IsOwner = false; wHealthInstitution_Profesional.IsAdmin = false; } else { if (rolName.Equals("inst_owner") || rolName.Equals("inst_admin")) { if (rolName.Equals("inst_owner")) wHealthInstitution_Profesional.IsOwner = false; if (rolName.Equals("inst_admin")) wHealthInstitution_Profesional.IsAdmin = false; } } //busca la entidad HealtInstitute_UsersInRoles wHealtInstitute_UsersInRoles = dc.HealtInstitute_UsersInRoles.Where(p => p.UserId.Equals(userId) && p.HealthInstitutionId.Equals(pHealthInstitutionId) && p.RoleName.Equals(rolName)).FirstOrDefault(); //Elimina la entidad HealtInstitute_UsersInRoles if (wHealtInstitute_UsersInRoles != null) dc.HealtInstitute_UsersInRoles.DeleteObject(wHealtInstitute_UsersInRoles); dc.SaveChanges(); } }
public static void Create_MutualPorPaciente(MutualPorPacienteList pMutualesDelPatient, int pIdPatient) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { MutualPorPaciente wMutual =null; foreach (MutualPorPacienteBE wMutualBE in pMutualesDelPatient) { wMutual = new MutualPorPaciente(); wMutual.IdPaciente = pIdPatient; wMutual.IdMutual = wMutualBE.IdMutual; wMutual.NroAfiliadoMutual = wMutualBE.NroAfiliadoMutual; dc.MutualPorPacientes.AddObject(wMutual); } dc.SaveChanges(); } }
/// <summary> /// Crea una Institución /// Establece como profesional owner de pHealthInstitution a pProfesionalId/pUserId /// </summary> /// <param name="pHealthInstitution">Institución</param> /// <param name="pProfesionalId">Profesional</param> /// <param name="pUserId"></param> public static void Create_From_Owner(Health.Back.BE.HealthInstitution pHealthInstitution, Int32 pProfesionalId, Guid pUserId) { Back.BE.HealthInstitution_Profesional wHealthInstitution_Profesional = new Back.BE.HealthInstitution_Profesional(); Back.BE.HealtInstitute_UsersInRoles wHealtInstitute_UsersInRoles = new BE.HealtInstitute_UsersInRoles(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { //Busco la institución padre si existe var parentHI = dc.HealthInstitutions.Where(p => !p.HealthInstitutionIdParent.HasValue && p.HealthInstitution_Profesional.Any(prof => prof.ProfesionalId.Equals(pProfesionalId))).FirstOrDefault(); if (parentHI != null) pHealthInstitution.HealthInstitutionIdParent = parentHI.HealthInstitutionId; pHealthInstitution.HealthInstitutionId = Guid.NewGuid(); pHealthInstitution.CreatedDate = System.DateTime.Now; dc.HealthInstitutions.AddObject(pHealthInstitution); wHealthInstitution_Profesional.HealthInstitutionId = pHealthInstitution.HealthInstitutionId; wHealthInstitution_Profesional.ProfesionalId = pProfesionalId; wHealthInstitution_Profesional.ActiveFlag = true; wHealthInstitution_Profesional.UserId = pUserId; wHealthInstitution_Profesional.IsLockedOut = false; wHealthInstitution_Profesional.IsOwner = true; dc.HealthInstitution_Profesional.AddObject(wHealthInstitution_Profesional); wHealtInstitute_UsersInRoles.UserId = pUserId; wHealtInstitute_UsersInRoles.HealthInstitutionId = pHealthInstitution.HealthInstitutionId; wHealtInstitute_UsersInRoles.RoleName = "inst_owner"; dc.HealtInstitute_UsersInRoles.AddObject(wHealtInstitute_UsersInRoles); dc.SaveChanges(); } }
/// <summary> /// Retorna todos los medicamentos asignados al Patient /// No importa si fueron suspendidos /// </summary> /// <param name="patientId"></param> /// <returns></returns> public static PatientMedicament_ViewList RetrivePatientMedicamentsAlls(int patientId) { PatientMedicament_ViewList list = new PatientMedicament_ViewList(); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var list_db = dc.PatientMedicament_View.Where( p => p.PatientId.Equals(patientId) ); foreach (PatientMedicament_View patientMedicament_db in list_db) { list.Add((PatientMedicament_ViewBE)patientMedicament_db); } } return list; }
/// <summary> /// Crea Patient y persona /// </summary> /// <param name="PatientBE"></param> public static void Create(PatientBE PatientBE) { PersonasDAC.Create(PatientBE.Persona); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { Patient p = new Patient(); p.IdPersona = PatientBE.Persona.IdPersona; p.FechaAlta = PatientBE.Persona.FechaAlta; p.LastAccessTime = p.FechaAlta; p.LastAccessUserId = PatientBE.LastAccessUserId; dc.Patients.AddObject(p); dc.SaveChanges(); PatientBE.PatientId = p.PatientId; PatientBE.IdPersona = p.IdPersona; } Create_PlanVacunacion(PatientBE); }
/// <summary> /// Por el momento representa Turnos otorgados a un Patient determinado por patientId /// </summary> /// <param name="startDate">Puede ser nula . Fecha de inicio para la busqueda</param> /// <param name="status"></param> /// <param name="patientId"></param> /// <returns>Patient_Appointments_ViewList, Appointment con ProfesionalAppointment</returns> public static Patient_Appointments_ViewList Retrive_Appointment(int patientId, DateTime? startDate, int? status) { Patient_Appointments_ViewList list = new Patient_Appointments_ViewList(); if (startDate.HasValue) startDate = Fwk.HelperFunctions.DateFunctions.GetStartDateTime(startDate.Value); using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { var appointment_db = dc.Patient_Appointments_View.Where<Patient_Appointments_View>(p => (!startDate.HasValue || p.Start.Value >= startDate.Value) && (!status.HasValue || status.Value.Equals(p.Status.Value)) && (p.PatientId.Equals(patientId)) ); foreach (Patient_Appointments_View r in appointment_db) { Patient_Appointments_ViewBE wAppoimentBE = (Patient_Appointments_ViewBE)r; wAppoimentBE = (Patient_Appointments_ViewBE)r; list.Add(wAppoimentBE); } } return list; }
public static void DisablePatientMedicaments(int patientMedicamentId, Guid guid,MedicamentStatus status) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientMedicament patientMedicament_db = dc.PatientMedicaments.Where(p => p.PatientMedicamentId.Equals(patientMedicamentId)).FirstOrDefault<PatientMedicament>(); if (patientMedicament_db != null) { patientMedicament_db.Status = (int)status; patientMedicament_db.Enabled = false; } dc.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="patientMedicament_View"></param> /// <param name="createdUserId"></param> public static void UpdatePatientMedicaments(PatientMedicament_ViewBE patientMedicament_View, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientMedicament patientMedicament_db = dc.PatientMedicaments.Where(p => p.PatientMedicamentId.Equals(patientMedicament_View.PatientMedicamentId)).FirstOrDefault<PatientMedicament>(); if (patientMedicament_db == null) return; patientMedicament_db.Status = patientMedicament_View.Status; patientMedicament_db.MedicalEventId = patientMedicament_View.MedicalEventId; patientMedicament_db.PatientId = patientMedicament_View.PatientId; patientMedicament_db.PatientMedicamentId_Parent = patientMedicament_View.PatientMedicamentId_Parent; patientMedicament_db.MedicamentName = patientMedicament_View.MedicamentName; patientMedicament_db.MedicamentPresentation = patientMedicament_View.MedicamentPresentation; patientMedicament_db.Dosis = patientMedicament_View.Dosis; patientMedicament_db.Periodicity_hours = patientMedicament_View.Periodicity_hours; patientMedicament_db.CreatedDate = System.DateTime.Now; patientMedicament_db.CreatedUserId = createdUserId; patientMedicament_db.Enabled = patientMedicament_View.Enabled; patientMedicament_db.DaysCount = patientMedicament_View.DaysCount; dc.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="pPatientMedicamentId"></param> public static void RemovePatientMedicaments(int pPatientMedicamentId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientMedicament patientMedicament_db = dc.PatientMedicaments.Where(p => p.PatientMedicamentId.Equals(pPatientMedicamentId)).FirstOrDefault<PatientMedicament>(); dc.PatientMedicaments.DeleteObject(patientMedicament_db); dc.SaveChanges(); } }
public static void AddPatientMedicaments(PatientMedicament_ViewBE patientMedicament_View, Guid createdUserId) { using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { PatientMedicament patientMedicament_db = new PatientMedicament(); patientMedicament_db.Status = patientMedicament_View.Status; patientMedicament_db.MedicalEventId = patientMedicament_View.MedicalEventId; patientMedicament_db.PatientId = patientMedicament_View.PatientId; if(patientMedicament_View.PatientMedicamentId_Parent >=0) patientMedicament_db.PatientMedicamentId_Parent = patientMedicament_View.PatientMedicamentId_Parent; patientMedicament_db.MedicamentName = patientMedicament_View.MedicamentName; patientMedicament_db.MedicamentPresentation = patientMedicament_View.MedicamentPresentation; patientMedicament_db.Dosis = patientMedicament_View.Dosis; patientMedicament_db.Periodicity_hours = patientMedicament_View.Periodicity_hours; patientMedicament_db.CreatedDate = System.DateTime.Now; patientMedicament_db.CreatedUserId = createdUserId; patientMedicament_db.DaysCount = patientMedicament_View.DaysCount; patientMedicament_db.Enabled = true; dc.PatientMedicaments.AddObject(patientMedicament_db); dc.SaveChanges(); } }