/// <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);
}