public static int InsertarCaracteristica(Caracteristica c)
{
SqlConnection Conexion = Conectar();
SqlCommand Consulta = Conexion.CreateCommand();
Consulta.CommandText = "InsertarCaracteristica";
Consulta.CommandType = System.Data.CommandType.StoredProcedure;
Consulta.Parameters.AddWithValue("@Nombre", c.Nombre);
Consulta.Parameters.AddWithValue("@fkCategoria", c.IDCategoria);
Consulta.Parameters.AddWithValue("@Pregunta", c.Pregunta);
int regsAfectados = Consulta.ExecuteNonQuery();
return(regsAfectados);
}
public static Caracteristica ObtenerCaracteristica(int ID)
{
Caracteristica c = new Caracteristica(0, "", 0, "");
SqlConnection Conexion = Conectar();
SqlCommand Consulta = Conexion.CreateCommand();
Consulta.CommandText = "ObtenerCaracteristica";
Consulta.CommandType = System.Data.CommandType.StoredProcedure;
Consulta.Parameters.AddWithValue("@id", ID);
SqlDataReader dataReader = Consulta.ExecuteReader();
while (dataReader.Read())
{
int id = Convert.ToInt32(dataReader["IdCaract"]);
string nombre = dataReader["Nombre"].ToString();
int idcategoria = Convert.ToInt32(dataReader["fkCategoria"]);
string pregunta = dataReader["Pregunta"].ToString();
c = new Caracteristica(id, nombre, idcategoria, pregunta);
}
Desconectar(Conexion);
return(c);
}
//CARACTERISTICAS
public static List <Caracteristica> ListarCaracteristica()
{
List <Caracteristica> Caracteristicas = new List <Caracteristica>();
SqlConnection Conexion = Conectar();
SqlCommand Consulta = Conexion.CreateCommand();
Consulta.CommandText = "ObtenerCaracteristica";
Consulta.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader dataReader = Consulta.ExecuteReader();
while (dataReader.Read())
{
int id = Convert.ToInt32(dataReader["IdCaract"]);
string nombre = dataReader["Nombre"].ToString();
int idcategoria = Convert.ToInt32(dataReader["FkCategoria"]);
string pregunta = dataReader["Pregunta"].ToString();
Caracteristica c = new Caracteristica(id, nombre, idcategoria, pregunta);
Caracteristicas.Add(c);
}
Desconectar(Conexion);
return(Caracteristicas);
}
