public bool Agregar(ContactoParticipanteModel Ctc) { SqlConnection connection = null; connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("CONTACTO_PARTICIPANTE_ACT", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ACCION", 1); command.Parameters.AddWithValue("@USR", Ctc.usr_id); command.Parameters.AddWithValue("@PYP", Ctc.pyp_id); command.Parameters.AddWithValue("@INVITACION", Ctc.invitacion); command.Parameters.AddWithValue("@NIVEL_TECNOLOGICO", Ctc.nivel_tecnologico); command.Parameters.AddWithValue("@REQUIERE_ASISTENCIA", Ctc.requiere_asistencia); command.Parameters.AddWithValue("@TIPO_DISPOSITIVO", Ctc.tipo_dispositivo); command.Parameters.AddWithValue("@TIPO_CONEXION", Ctc.tipo_conexion); command.Parameters.AddWithValue("@CMN_ID_CONEXION", Ctc.cmn_id_conexion); command.Parameters.AddWithValue("@DISPOSITIVOS_EXTERNOS", Ctc.dispositivos_externos); command.Parameters.AddWithValue("@OBSERVACION", Ctc.observacion); connection.Open(); int i = command.ExecuteNonQuery(); connection.Close(); if (i >= 1) { return(true); } else { return(false); } }
public ContactoParticipanteModel BuscaPorPyp(int pyp) { var model = new ContactoParticipanteModel(); using (SqlConnection connection = new SqlConnection(connectionString)) using (SqlCommand command = new SqlCommand("CONTACTO_PARTICIPANTE_SEL", connection)) { connection.Open(); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ACCION", 1); command.Parameters.AddWithValue("@PYP", pyp); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { model.ctc_id = (int)reader["ctc_id"]; model.pyp_id = (int)reader["pyp_id"]; model.invitacion = (int)reader["invitacion"]; model.nivel_tecnologico = (int)reader["nivel_tecnologico"]; model.requiere_asistencia = (int)reader["requiere_asistencia"]; model.tipo_dispositivo = (int)reader["tipo_dispositivo"]; model.tipo_conexion = (int)reader["tipo_conexion"]; model.cmn_id_conexion = (int)reader["cmn_id_conexion"]; model.dispositivos_externos = (int)reader["dispositivos_externos"]; model.observacion = (string)reader["observacion"]; } else { model.pyp_id = pyp; } reader.Close(); connection.Close(); } return(model); }