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