/// <summary> /// save new treatment /// </summary> public TreatmentRes Save(int doctorId, TreatmentReq req) { try { using (TransactionScope scope = new TransactionScope()) { var cat = new catrecetas { idmedico = doctorId, nombre = req.GroupName, lineas = string.Join("|", req.List) }; Context.catrecetas.Add(cat); Context.SaveChanges(); scope.Complete(); return(new TreatmentRes { Id = cat.idcatreceta }); } } catch (Exception ex) { Log.Write($"WebAPI.Services.Diagnostic - Save=> {ex.Message}"); } return(new TreatmentRes()); }
/// <summary> /// change doctor'password /// </summary> public ChangePwdRes ChangePassword(int doctorId, ChangePwdReq changePwdReq) { var result = new ChangePwdRes(); var doctor = Context.Registro .Join(Context.Medico, reg => reg.idRegistro, med => med.IdRegistro, (reg, med) => new { r = reg, m = med }) .Where(x => x.m.Idmedico == doctorId) .FirstOrDefault()?.r; if (doctor != null) { if (doctor.clave == changePwdReq.CurrentPassword) { try { doctor.clave = changePwdReq.NewPassword; Context.SaveChanges(); } catch (Exception ex) { result.Error = ex.Message; Log.Write($"WebAPI.Services._Doctor, ChangePassword => {ex.Message}"); } } else { result.Error = "Contraseña incorrecta"; } } else { result.Error = "Error al obtener la información del doctor"; } return(result); }
public void UpdateTransaction(StatusT StatusTransaction, string Reference, string ReferenceBank, string PaymentMethod) { using (EmeciEntities DB = new EmeciEntities()) { NewMembership Membership = (from x in DB.NewMembership where x.Reference == Reference select x).First(); if (Membership != null) { Membership.ReferenceBank = ReferenceBank; Membership.Status = (int)StatusTransaction; Membership.PaymentMethod = PaymentMethod; try { DB.SaveChanges(); } catch (Exception) { } } } }
public void AddTransaction(MembershipModel Model, string Reference) { using (EmeciEntities DB = new EmeciEntities()) { DB.NewMembership.Add(new NewMembership() { Name = Model.Name, Phone = Model.Phone, Email = Model.Email, C_Date = DateTime.Now, Reference = Reference, Status = (int)StatusT.Proceso, EMECI = Model.EMECI }); try { DB.SaveChanges(); } catch (Exception) { } } }
public bool SaveGeneralConsult(int doctorId, GeneralConsult req) { try { using (TransactionScope scope = new TransactionScope()) { var now = DateTime.Now; //patient Paciente p = Context.Paciente.FirstOrDefault(x => x.idPaciente == req.PatientId); p.AlergiaMedicina = req.Allergies; p.AlergiaOtros = req.Reserved; p.Patologia = req.RelevantPathologies; Context.SaveChanges(); //consult var consult = new Consultas { idmedico = doctorId, idpaciente = req.PatientId, Peso = req.Weight, Altura = req.Size, Temperatura = req.Temperature, TensionArterial = req.BloodPressure_A, TensionArterialB = req.BloodPressure_B, perimetroCefalico = req.HeadCircuference, FrecuenciaCardiaca = req.HeartRate, FrecuenciaRespiratoria = req.BreathingFrecuency, motivo = req.ReasonForConsultation, SignosSintomas1 = req.PhysicalExploration, MedidasPreventivas = req.PreventiveMeasures, observaciones = req.Observations, Fecha = now, Pronostico = req.Prognostic != null?string.Join("|", req.Prognostic) : "" }; Context.Consultas.Add(consult); Context.SaveChanges(); //treatments var treatments = new Recetas { idconsulta = consult.idconsulta, idmedico = doctorId, idpaciente = req.PatientId, Fecha = now, Lineas = SetLines(req.Treatments) }; Context.Recetas.Add(treatments); Context.SaveChanges(); //diagnostics var diagnostics = new Diagnosticos { idconsulta = consult.idconsulta, idmedico = doctorId, idpaciente = req.PatientId.GetValueOrDefault(), Fecha = now, Lineas = SetLines(req.Diagnostics) }; Context.Diagnosticos.Add(diagnostics); Context.SaveChanges(); //laboratory studies var laboratory = new EstudiosLab { idconsulta = consult.idconsulta, idmedico = doctorId, idpaciente = req.PatientId, Fecha = now, Lineas = SetLines(req.LaboratoryStudies) }; Context.EstudiosLab.Add(laboratory); Context.SaveChanges(); //cabinet studies var cabinet = new EstudiosGab { idconsulta = consult.idconsulta, idmedico = doctorId, idpaciente = req.PatientId, Fecha = now, Lineas = SetLines(req.CabinetStudies) }; Context.EstudiosGab.Add(cabinet); Context.SaveChanges(); scope.Complete(); return(true); } } catch (Exception ex) { Log.Write($"WebAPI.Services._Consults - SaveGeneralConsult => ${ex.Message}"); } return(false); }
public NewPatientRes AddNewPatient(int doctorId, NewPatientReq req) { var result = new NewPatientRes(); string emeci = GetLastEmeci(doctorId); MemoryStream draw = null; try { using (TransactionScope scope = new TransactionScope()) { var r = new Registro { Nombre = req.Name, Apellido = req.LastName, Telefono = req.Phone, Tipo = "P", Status = "V", FechaRegistro = DateTime.Now.Date, FechaExpiracion = DateTime.Now.AddMonths(1).Date, Emails = req.Emails, clave = req.Password, Emeci = emeci }; Context.Registro.Add(r); Context.SaveChanges(); var p = new Paciente { IdRegistro = r.idRegistro, Sexo = req.Sex, FechaNacimiento = DateTime.Parse(req.BirthDate), NombreMadre = req.MothersName, NombrePadre = req.FathersName, AlergiaMedicina = req.Allergy }; Context.Paciente.Add(p); Context.SaveChanges(); draw = DrawDataInCard(emeci); scope.Complete(); result.PatientId = p.idPaciente; } } catch (Exception ex) { Log.Write($"WebAPI.Services._Patient - AddNewPatient => ${ex.Message}"); } if (result.PatientId.HasValue && draw != null) { var emailService = new EmailService(req.Emails); Task.Run(async() => { await emailService.SendPatientRegister(req, draw); }); } return(result); }