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);
}
}
private void btnFilter_Click(object sender, EventArgs e)
{
if (txtUnidadProductiva.Text != "")
{
var objDataService = MedicamentoDao.ObtenerLineasWhere(txtUnidadProductiva.Text);
ultraGrid1.DataSource = objDataService;
lblConteoLineas.Text = string.Format("Se encontraron {0} registros.", this.ultraGrid1.Rows.Count());
//this.ultraGrid1.DisplayLayout.AutoFitStyle = Infragistics.Win.UltraWinGrid.AutoFitStyle.ResizeAllColumns;
}
else
{
var objDataService = MedicamentoDao.ObtenerLineas();
ultraGrid1.DataSource = objDataService;
lblConteoLineas.Text = string.Format("Se encontraron {0} registros.", this.ultraGrid1.Rows.Count());
//this.ultraGrid1.DisplayLayout.AutoFitStyle = Infragistics.Win.UltraWinGrid.AutoFitStyle.ResizeAllColumns;
}
}
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);
}
}
private void frmLineaSelector_Load(object sender, EventArgs e)
{
ultraGrid1.DataSource = MedicamentoDao.ObtenerLineas();
lblConteoLineas.Text = string.Format("Se encontraron {0} registros.", this.ultraGrid1.Rows.Count());
}
private void frmMedicalExamEdicion_Load(object sender, EventArgs e)
{
try
{
#region Mayusculas - Normal
var _EsMayuscula = int.Parse(Common.Utils.GetApplicationConfigValue("EsMayuscula"));
if (_EsMayuscula == 1)
{
SearchControlAndSetEvents(this);
}
#endregion
OperationResult objOperationResult = new OperationResult();
//Llenado de combos
Utils.LoadComboTreeBoxList(ddlCategoryId, BLL.Utils.GetSystemParameterForComboTreeBox(ref objOperationResult, 116, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlDiagnosableId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 111, null), DropDownListAction.Select);
Utils.LoadDropDownList(cbRecargable, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 111, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlComponentTypeId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 126, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlKindOfService, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 358, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlUIIsVisibleId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 111, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlIsApprovedId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 111, null), DropDownListAction.Select);
MedicamentoDao.ObtenerLineasParaCombo(ddlUnidadProductiva);
if (Mode == "New")
{
// Additional logic here.
}
else if (Mode == "Edit")
{
// Get the Entity Data
objmedicalexamDto = new componentDto();
objmedicalexamDto = _objMedicalExamBL.GetMedicalExam(ref objOperationResult, MedicalExamId);
txtInsertName.Text = objmedicalexamDto.v_Name;
_NameComponentOld = objmedicalexamDto.v_Name;
ComboTreeNode nodoABuscar = null;
foreach (var nodeParent in ddlCategoryId.Nodes)
{
foreach (var nodeChildCategory in nodeParent.Nodes)
{
if (nodeChildCategory.Tag.ToString() == objmedicalexamDto.i_CategoryId.ToString())
{
foreach (var nodeChildSubCategory in nodeChildCategory.Nodes)
{
if (nodeChildSubCategory.Tag.ToString() == Orden)
{
nodoABuscar = nodeChildSubCategory;
}
}
}
}
}
if (nodoABuscar != null)
{
ddlCategoryId.SelectedNode = nodoABuscar;
}
unBasePrice.Text = objmedicalexamDto.r_BasePrice.ToString();
ddlDiagnosableId.SelectedValue = objmedicalexamDto.i_DiagnosableId.ToString();
ddlComponentTypeId.SelectedValue = objmedicalexamDto.i_ComponentTypeId.ToString();
ddlKindOfService.SelectedValue = objmedicalexamDto.i_KindOfService.ToString();
cbRecargable.SelectedValue = objmedicalexamDto.i_PriceIsRecharged.ToString();
ddlUIIsVisibleId.SelectedValue = objmedicalexamDto.i_UIIsVisibleId.ToString();
unUIIndex.Value = objmedicalexamDto.i_UIIndex;
ddlIsApprovedId.SelectedValue = objmedicalexamDto.i_IsApprovedId.ToString();
unValidInDays.Value = objmedicalexamDto.i_ValidInDays.ToString();
if (objmedicalexamDto.v_IdUnidadProductiva != null)
{
ddlUnidadProductiva.SelectedValue = objmedicalexamDto.v_IdUnidadProductiva;
}
else
{
ddlUnidadProductiva.SelectedIndex = 0;
}
txtTarifaSegus.Text = objmedicalexamDto.r_PriceSegus.ToString();
txtCodigoSegus.Text = objmedicalexamDto.v_CodigoSegus;
}
SetOldValues();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
