private void txtMedicamento_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { TicketBL oTicketBL = new TicketBL(); var f = new frmSearchMedicamento(); var result = f.ShowDialog(); if (result == DialogResult.OK) { var medicamento = f.MedicamentoSeleccionado; if (medicamento == null) { return; } txtMedicamento.Text = medicamento.NombreCompleto; txtMedicamento.Tag = medicamento.IdProductoDetalle; idUnidadProductiva = medicamento.IdLinea; txtUnidadProductiva.Text = medicamento.IdLinea; txtPrecio.Text = medicamento.PrecioVenta.ToString(); var tienePlan = false; var resultplan = oTicketBL.TienePlan(_protocolId, txtUnidadProductiva.Text); if (resultplan.Count > 0) { tienePlan = true; } else { tienePlan = false; } if (tienePlan) { if (resultplan[0].i_EsCoaseguro == 1) { #region Conexion SAM ConexionSigesoft conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); #endregion var cadena1 = "select PR.r_MedicineDiscount, OO.v_Name, PR.v_CustomerOrganizationId from Organization OO inner join protocol PR On PR.v_AseguradoraOrganizationId = OO.v_OrganizationId where PR.v_ProtocolId ='" + _protocolId + "'"; SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft); SqlDataReader lector = comando.ExecuteReader(); string eps = ""; while (lector.Read()) { eps = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); //calculo nuevo precio txtPPS.Text = medicamento.d_PrecioMayorista.ToString(); txtDctoEPS.Text = eps; decimal nuevoPrecio = decimal.Parse(txtPPS.Text) - ((decimal.Parse(eps) * decimal.Parse(txtPPS.Text)) / 100); txtNuevoPrecio.Text = nuevoPrecio.ToString(); } } } }
private void btnBuscar_Click(object sender, EventArgs e) { var f = new frmSearchMedicamento(); var result = f.ShowDialog(); #region Conexion SIGESOFT Obtener Porcentaje de descuento EPS ConexionSigesoft conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); var cadena = "select PR.r_MedicineDiscount from protocol PR inner join organization OO on PR.v_CustomerOrganizationId = OO.v_OrganizationId where PR.v_ProtocolId='" + _protocolId + "'"; SqlCommand comando = new SqlCommand(cadena, connection: conectasam.conectarsigesoft); SqlDataReader lector = comando.ExecuteReader(); string EPS = ""; while (lector.Read()) { EPS = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); #endregion if (result == DialogResult.OK) { var medicamento = f.MedicamentoSeleccionado; if (medicamento == null) { return; } txtMedicamento.Text = medicamento.NombreCompleto; txtCodigo.Text = medicamento.CodInterno; txtMedicamento.Tag = medicamento.IdProductoDetalle; //Nuevo Precio con descuento EPS txtPrecioVenta.Text = (decimal.Round((medicamento.d_PrecioMayorista - (medicamento.d_PrecioMayorista * decimal.Parse(EPS)) / 100), 2)).ToString(); txtUnidadProductiva.Text = medicamento.IdLinea; txtPrecio.Text = (decimal.Round((decimal)medicamento.PrecioVenta, 2)).ToString(); txtPPS.Text = (decimal.Round((decimal)medicamento.d_PrecioMayorista, 2)).ToString(); txtDesctoEPS.Text = EPS; } }