public void insertarDD(Maestro aux) { cnn = c.conectar; query = "INSERT INTO MAESTRO(IDPROYECTO,IDPERSONA,CARGO,carrera)VALUES(" + aux.idProyecto + "," + aux.idPersona + "," + "'DD','" + aux.carrera + "')"; cmd = new SqlCommand(query, cnn); cmd.ExecuteNonQuery(); cnn.Close(); }
public void agregarMaestro(Maestro ma) { cnn = c.conectar; query = @"INSERT INTO MAESTRO(IDPROYECTO, IDPERSONA, CARGO, CARRERA) VALUES(" + ma.idProyecto + "," + ma.idPersona + ",'" + ma.cargo + "','" + ma.carrera.Trim() + "')"; cmd = new SqlCommand(query, cnn); cmd.ExecuteNonQuery(); cnn.Close(); c.desconectar(); }
public void registrarTutorAcademico(Maestro maestro, Estudiante estudiate) { SqlCommand cmd = new SqlCommand(); cnn = c.conectar; query = "UPDATE ESTUDIANTE SET IDMAPERSONA=" + maestro.idPersona + " WHERE IDPERSONA=" + estudiate.idPersona + ""; cmd = new SqlCommand(query, cnn); cmd.ExecuteNonQuery(); cnn.Close(); c.desconectar(); }
public List <Maestro> queryDocentesProyecto() { List <Maestro> listaMaestro = new List <Maestro>(); cnn = c.conectar; using (cnn) { query = @"SELECT DISTINCT m.IDPROYECTO,m.IDPERSONA,m.CARGO,m.CARGO,P.NOMBREPERSONA, p.APELLIDOPERSONA FROM Persona p,MAESTRO m, ESTUDIANTE e WHERE m.CARGO = 'MP' AND M.IDPERSONA=P.IDPERSONA"; SqlCommand cmd = new SqlCommand(query, cnn); SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { Maestro maestro = new Maestro(Convert.ToInt16(read[0]), Convert.ToInt16(read[1]), Convert.ToString(read[2]), Convert.ToString(read[3]), Convert.ToString(read[4]), Convert.ToString(read[5])); listaMaestro.Add(maestro); } } cnn.Close(); c.desconectar(); return(listaMaestro); }