public List <DiagnosticRepositoryList> GetHierarchycalData(ref OperationResult pobjOperationResult,
List <DiagnosticRepositoryList> dataToIterate)
{
try
{
using (var dbContext = new SigesoftEntitiesModel())
{
var diagnosticIds = dataToIterate.Select(p => p.v_DiagnosticRepositoryId).Distinct();
var medicamentos = MedicamentoDao.ObtenerContasolMedicamentos();
var recetas = (from n in dbContext.receta.Where(p => diagnosticIds.Contains(p.v_DiagnosticRepositoryId)).ToList()
join m in medicamentos on n.v_IdProductoDetalle equals m.IdProductoDetalle into mJoin
from m in mJoin.DefaultIfEmpty()
select new recetaDto
{
v_IdProductoDetalle = n.v_IdProductoDetalle,
NombreMedicamento = m.NombreCompleto,
d_Cantidad = n.d_Cantidad,
i_IdReceta = n.i_IdReceta,
t_FechaFin = n.t_FechaFin,
v_DiagnosticRepositoryId = n.v_DiagnosticRepositoryId,
v_Duracion = n.v_Duracion,
v_Posologia = n.v_Posologia
}).ToList();
if (recetas.Any())
{
var agrupado = recetas.GroupBy(g => g.v_DiagnosticRepositoryId);
foreach (var grupo in agrupado)
{
var parent = dataToIterate.FirstOrDefault(p => p.v_DiagnosticRepositoryId.Equals(grupo.Key));
if (parent != null)
{
parent.RecipeDetail.AddRange(grupo);
}
}
}
pobjOperationResult.Success = 1;
return(dataToIterate);
}
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ErrorMessage = ex.Message;
pobjOperationResult.ExceptionMessage = ex.InnerException != null
? ex.InnerException.Message
: string.Empty;
pobjOperationResult.AdditionalInformation = "RecetaBl.AddUpdateRecipe()";
return(null);
}
}
public recetaDto GetRecipeById(ref OperationResult pobjOperationResult, int recipeId)
{
try
{
using (var dbContext = new SigesoftEntitiesModel())
{
var medicamentos = MedicamentoDao.ObtenerContasolMedicamentos();
var entidad = (from r in dbContext.receta.Where(p => p.i_IdReceta == recipeId).ToList()
join m in medicamentos on r.v_IdProductoDetalle equals m.IdProductoDetalle into mJoin
from m in mJoin.DefaultIfEmpty()
where r.i_IdReceta == recipeId
select new recetaDto
{
v_IdProductoDetalle = r.v_IdProductoDetalle,
i_IdReceta = r.i_IdReceta,
NombreMedicamento = m.NombreCompleto,
d_Cantidad = r.d_Cantidad,
t_FechaFin = r.t_FechaFin,
v_DiagnosticRepositoryId = r.v_DiagnosticRepositoryId,
v_Duracion = r.v_Duracion,
v_Posologia = r.v_Posologia,
v_IdUnidadProductiva = r.v_IdUnidadProductiva
}).FirstOrDefault();
if (entidad == null)
{
throw new Exception("El objeto ya no existe!");
}
pobjOperationResult.Success = 1;
return(entidad);
}
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ErrorMessage = ex.Message;
pobjOperationResult.ExceptionMessage = ex.InnerException != null
? ex.InnerException.Message
: string.Empty;
pobjOperationResult.AdditionalInformation = "RecetaBl.DeleteRecipe()";
return(null);
}
}
public List <recetadespachoDto> GetReceta(string serviceId)
{
using (var dbContext = new SigesoftEntitiesModel())
{
var medicamentos = MedicamentoDao.ObtenerContasolMedicamentos();
var consulta = (from r in dbContext.receta
join d in dbContext.diagnosticrepository on r.v_DiagnosticRepositoryId equals d.v_DiagnosticRepositoryId into dJoin
from d in dJoin.DefaultIfEmpty()
join s in dbContext.service on d.v_ServiceId equals s.v_ServiceId into sJoin
from s in sJoin.DefaultIfEmpty()
where s.v_ServiceId.Equals(serviceId)
select new recetadespachoDto
{
RecetaId = r.i_IdReceta,
CantidadRecetada = r.d_Cantidad ?? 0,
FechaFin = r.t_FechaFin ?? DateTime.Now,
Duracion = r.v_Duracion,
Dosis = r.v_Posologia,
Despacho = (r.i_Lleva ?? 0) == 1,
MedicinaId = r.v_IdProductoDetalle
}).ToList();
foreach (var item in consulta)
{
var prod = medicamentos.FirstOrDefault(p => p.IdProductoDetalle.Equals(item.MedicinaId));
if (prod == null)
{
continue;
}
item.Medicamento = prod.NombreCompleto;
item.Presentacion = prod.Presentacion;
item.Ubicacion = prod.Ubicacion;
}
return(consulta);
}
}
public List <recetadespachoDto> GetRecetaToReport(ref OperationResult pobjOperationResult, string serviceId)
{
try
{
using (var dbContext = new SigesoftEntitiesModel())
{
pobjOperationResult.Success = 1;
var medicamentos = MedicamentoDao.ObtenerContasolMedicamentos();
var FirmaMedicoMedicina = new ServiceBL().ObtenerFirmaMedicoExamen(serviceId, Constants.ATENCION_INTEGRAL_ID, Constants.EXAMEN_FISICO_7C_ID);
var consulta = (from r in dbContext.receta
join d in dbContext.diagnosticrepository on r.v_DiagnosticRepositoryId equals d.v_DiagnosticRepositoryId into dJoin
from d in dJoin.DefaultIfEmpty()
join s in dbContext.service on d.v_ServiceId equals s.v_ServiceId into sJoin
from s in sJoin.DefaultIfEmpty()
join C in dbContext.organization on new { id = "N009-OO000000052" } equals new { id = C.v_OrganizationId } into C_join
from C in C_join.DefaultIfEmpty()
join p in dbContext.person on s.v_PersonId equals p.v_PersonId into pJoin
from p in pJoin.DefaultIfEmpty()
where s.v_ServiceId.Equals(serviceId)
select new recetadespachoDto
{
RecetaId = r.i_IdReceta,
CantidadRecetada = r.d_Cantidad ?? 0,
//Medicamento = m.NombreCompleto,
//Presentacion = m.Presentacion,
//Ubicacion = m.Ubicacion,
NombrePaciente = p.v_FirstLastName + " " + p.v_SecondLastName + " " + p.v_FirstName,
FechaFin = r.t_FechaFin ?? DateTime.Now,
Duracion = r.v_Duracion,
Dosis = r.v_Posologia,
NombreMedico = FirmaMedicoMedicina.Value2,
RubricaMedico = FirmaMedicoMedicina.Value5,
MedicoNroCmp = FirmaMedicoMedicina.Value3,
NombreClinica = C.v_Name,
DireccionClinica = C.v_Address,
LogoClinica = C.b_Image,
Despacho = (r.i_Lleva ?? 0) == 1,
MedicinaId = r.v_IdProductoDetalle
}).ToList();
//consulta = consulta.GroupBy(p => p.RecetaId).Select(p => p.FirstOrDefault()).ToList();
foreach (var item in consulta)
{
var prod = medicamentos.FirstOrDefault(p => p.IdProductoDetalle.Equals(item.MedicinaId));
if (prod == null)
{
continue;
}
item.Medicamento = prod.NombreCompleto;
item.Presentacion = prod.Presentacion;
item.Ubicacion = prod.Ubicacion;
}
return(consulta);
}
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ErrorMessage = ex.Message;
pobjOperationResult.ExceptionMessage = ex.InnerException != null
? ex.InnerException.Message
: string.Empty;
pobjOperationResult.AdditionalInformation = "RecetaDespachoBl.GetDespacho()";
return(null);
}
}
