public static List <Resumenes> TraerResumenesXPuntYEsc(int idEsc) { List <Resumenes> ListaDeResumenes = new List <Resumenes>(); Conectar(); SqlCommand command = SQL.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = " SELECT TOP 8 * FROM Resumenes where FkEscuela = " + idEsc + " ORDER BY Puntuacion DESC"; //Consulta SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { int idres = Convert.ToInt32(dataReader["IdResumen"]); string Nom = dataReader["Nombre"].ToString(); int fkMat = Convert.ToInt32(dataReader["FkMateria"]); int fkUsu = Convert.ToInt32(dataReader["FkUsuario"]); int punt = Convert.ToInt32(dataReader["Puntuacion"]); int ano = Convert.ToInt32(dataReader["Anio"]); string ft = dataReader["Archivo"].ToString(); int fkesc = Convert.ToInt32(dataReader["FkEscuela"]); Resumenes resu = new Resumenes(idres, Nom, fkMat, fkUsu, punt, ano, ft, fkesc); ListaDeResumenes.Add(resu); } dataReader.Close(); Desconectar(); return(ListaDeResumenes); }
public static void ModificarResumen(Resumenes resu) { Conectar(); SqlCommand command = SQL.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "UPDATE Resumenes SET Nombre = '" + resu.Nombre + "', FkMateria =" + resu.FkMateria + ", FkUsuario = " + resu.FkUsuario + ", Puntuacion = " + resu.Puntuacion + "' WHERE IdResumen = " + resu.IdResumen; //Consulta SqlDataReader dataReader = command.ExecuteReader(); Desconectar(); }
public static void InsertarResumen(Resumenes res) { Conectar(); SqlCommand command = SQL.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "INSERT into Resumenes(Nombre, FkMateria ,FkUsuario,Puntuacion,Anio,Archivo,FkEscuela ) values ('" + res.Nombre + "'," + res.FkMateria + "," + res.FkUsuario + "," + res.Puntuacion + "," + res.Ano + ",'" + res.Archivo + "'," + res.FkEscuela + ")"; //Consulta SqlDataReader dataReader = command.ExecuteReader(); Desconectar(); }
public static List <Resumenes> TraerResumenes(int idRes)//Cuando es -1 trae todo, sino trae esa { List <Resumenes> ListaDeResumenes = new List <Resumenes>(); Conectar(); SqlCommand command = SQL.CreateCommand(); command.CommandType = System.Data.CommandType.Text; if (idRes != -1) { command.CommandText = "SELECT* FROM Resumenes where IdResumen =" + idRes; //Consulta } else { command.CommandText = "SELECT* FROM Resumenes"; //Consulta } SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { int idres = Convert.ToInt32(dataReader["IdResumen"]); string Nom = dataReader["Nombre"].ToString(); int fkMat = Convert.ToInt32(dataReader["FkMateria"]); int fkUsu = Convert.ToInt32(dataReader["FkUsuario"]); int punt = Convert.ToInt32(dataReader["Puntuacion"]); int ano = Convert.ToInt32(dataReader["Anio"]); string ft = dataReader["Archivo"].ToString(); int fkesc = Convert.ToInt32(dataReader["FkEscuela"]); Resumenes resu = new Resumenes(idres, Nom, fkMat, fkUsu, punt, ano, ft, fkesc); ListaDeResumenes.Add(resu); } dataReader.Close(); Desconectar(); return(ListaDeResumenes); }