private void btnTicket_Click(object sender, EventArgs e) { // obtener serviceId y protocolId var ServiceId = grdData.Selected.Rows[0].Cells["v_ServiceId"].Value.ToString(); var protocolId = grdData.Selected.Rows[0].Cells["v_ProtocolId"].Value.ToString(); #region Conexion SAM Obtener Plan ConexionSigesoft conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); var cadena1 = "select PL.i_PlanId from [dbo].[plan] PL where PL.v_ProtocoloId ='" + protocolId + "'"; SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft); SqlDataReader lector = comando.ExecuteReader(); string plan = ""; while (lector.Read()) { plan = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); string modoMasterService; if (plan != "") { modoMasterService = "ASEGU"; } else { modoMasterService = "HOSPI"; } #endregion // construir formulario ticket frmTicket ticket = new frmTicket(_tempTicket, ServiceId, string.Empty, "New", protocolId, modoMasterService); ticket.ShowDialog(); btnFilter_Click(sender, e); btnTicket.Enabled = false; }
private void btnTicket_Click(object sender, EventArgs e) { var ServiceId = grdData.Selected.Rows[0].Cells["v_ServiceId"].Value.ToString(); var protocolId = grdData.Selected.Rows[0].Cells["v_ProtocolId"].Value.ToString(); //MessageBox.Show("Service: " + TserviceId); frmTicket ticket = new frmTicket(_tempTicket, ServiceId, string.Empty, "New", protocolId); ticket.ShowDialog(); btnFilter_Click(sender, e); btnTicket.Enabled = false; }
private void btnEditarTicket_Click(object sender, EventArgs e) { var ServiceId = grdData.Selected.Rows[0].Cells["v_ServiceId"].Value.ToString(); var ticketId = grdData.Selected.Rows[0].Cells["v_TicketId"].Value.ToString(); var protocolId = grdData.Selected.Rows[0].Cells["v_ProtocolId"].Value.ToString(); _ticketId = ticketId; frmTicket ticket = new frmTicket(_tempTicket, ServiceId, _ticketId, "Edit", protocolId); ticket.ShowDialog(); btnFilter_Click(sender, e); }
private void btnEditarTicket_Click(object sender, EventArgs e) { OperationResult objOperationResult = new OperationResult(); var ServiceId = grdData.Selected.Rows[0].Cells["v_ServiceId"].Value.ToString(); var ticketId = grdData.Selected.Rows[0].Cells["v_TicketId"].Value.ToString(); #region Conexion SAM ConexionSigesoft conectasam = new ConexionSigesoft(); conectasam.opensigesoft(); #endregion var cadena1 = "select PL.i_PlanId from service SR inner join protocol PR on SR.v_ProtocolId = PR.v_ProtocolId inner join [dbo].[plan] PL on PR.v_ProtocolId = PL.v_ProtocoloId where SR.v_ServiceId ='" + ServiceId + "'"; SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft); SqlDataReader lector = comando.ExecuteReader(); string plan = ""; string protocolId = ""; while (lector.Read()) { plan = lector.GetValue(0).ToString(); } lector.Close(); conectasam.closesigesoft(); ServiceList personData = _serviceBL.GetServicePersonData(ref objOperationResult, ServiceId); string modoMasterService; if (plan != "") { modoMasterService = "ASEGU"; } else { modoMasterService = "HOSPI"; } _ticketId = ticketId; frmTicket ticket = new frmTicket(_tempTicket, ServiceId, _ticketId, "Edit", personData.v_ProtocolId, modoMasterService); ticket.ShowDialog(); btnFilter_Click(sender, e); }