private void btnVerHabitaciones_Click(object sender, EventArgs e) { //var v_HopitalizacionId = grdData.Selected.Rows[0].Cells["v_HopitalizacionId"].Value.ToString(); var frm = new frmHabitaciones("", "View", "", ""); frm.ShowDialog(); }
private void btnEditarHabitacion_Click(object sender, EventArgs e) { try { var v_HopitalizacionId = grdData.Selected.Rows[0].Cells["v_HopitalizacionId"].Value.ToString(); #region Conexion SIGESOFT Obtener Protocolo ConexionSigesoft conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); var cadena1 = "select PR.v_ProtocolId " + "from hospitalizacionservice HS " + "inner join service SR on SR.v_ServiceId= HS.v_ServiceId " + "inner join protocol PR on SR.v_ProtocolId=PR.v_ProtocolId " + "where v_HopitalizacionId='" + v_HopitalizacionId + "'"; SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft); SqlDataReader lector = comando.ExecuteReader(); v_ProtocoloId = ""; while (lector.Read()) { v_ProtocoloId = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); #endregion #region Conexion SIGESOFT Obtener Plan conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); cadena1 = "select PL.i_PlanId from [dbo].[plan] PL where PL.v_ProtocoloId ='" + v_ProtocoloId + "'"; comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft); lector = comando.ExecuteReader(); string plan = ""; while (lector.Read()) { plan = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); #endregion string modoMasterService; if (plan != "") { modoMasterService = "ASEGU"; } else { modoMasterService = "HOSPI"; } var hospitalizacionId = grdData.Selected.Rows[0].Cells["v_HopitalizacionId"].Value.ToString(); var hospitalizacionHabitacionId = grdData.Selected.Rows[0].Cells["v_HospitalizacionHabitacionId"].Value.ToString(); frmHabitaciones frm = new frmHabitaciones(hospitalizacionId, "Edit" + modoMasterService, hospitalizacionHabitacionId, v_ProtocoloId); //frmHabitacion frm = new frmHabitacion(hospitalizacionId, "Edit" + modoMasterService, hospitalizacionHabitacionId, v_ProtocoloId); //frmHabitacion frm = new frmHabitacion(hospitalizacionId, "Edit", hospitalizacionHabitacionId, v_ProtocoloId); frm.ShowDialog(); btnFilter_Click(sender, e); btnEditarHabitacion.Enabled = false; } catch (Exception ex) { //Console.WriteLine(ex); MessageBox.Show("NO SE PUEDE EDITAR HABITACIÓN - YA ASIGNADO", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information); //throw; } }