//Metodo eliminar public int EliminarNews(NewsEN pEN) { _conn.Open(); SqlCommand _Comand = new SqlCommand("EliminarNews", _conn as SqlConnection); _Comand.CommandType = CommandType.StoredProcedure; _Comand.Parameters.Add(new SqlParameter("@Id", pEN.Id)); int Resultado = _Comand.ExecuteNonQuery(); _conn.Close(); _conn.Dispose(); return(Resultado); }
//metodo de agregar public int AgregarNews(NewsEN pEN) { _conn.Open(); SqlCommand _Comand = new SqlCommand("AgregarNews", _conn as SqlConnection); _Comand.CommandType = CommandType.StoredProcedure; _Comand.Parameters.Add(new SqlParameter("@Artista", pEN.Artista)); _Comand.Parameters.Add(new SqlParameter("@TNoticia", pEN.TNoticia)); _Comand.Parameters.Add(new SqlParameter("@foto", pEN.foto)); _Comand.Parameters.Add(new SqlParameter("@DNoticia", pEN.DNoticia)); int Resultado = _Comand.ExecuteNonQuery(); _conn.Close(); _conn.Dispose(); return(Resultado); }
//metodo de consultar public List <NewsEN> ConsultarNews() { _conn.Open(); SqlCommand _comand = new SqlCommand("ConsultarNews", _conn as SqlConnection); _comand.CommandType = CommandType.StoredProcedure; IDataReader _reader = _comand.ExecuteReader(); List <NewsEN> _lista = new List <NewsEN>(); while (_reader.Read()) { NewsEN pEN = new NewsEN(); pEN.Id = _reader.GetInt64(0); pEN.Artista = _reader.GetString(1); pEN.TNoticia = _reader.GetString(2); pEN.foto = _reader.GetString(3); pEN.DNoticia = _reader.GetString(4); _lista.Add(pEN); } _conn.Close(); _conn.Dispose(); return(_lista); }
public int EliminarNews(NewsEN pEN) { return(_dal.EliminarNews(pEN)); }
public int ActualizaNews(NewsEN pEN) { return(_dal.ActualizaNews(pEN)); }
public int AgregarNews(NewsEN pEN) { return(_dal.AgregarNews(pEN)); }