public IActionResult ListarFiguras()
{
List <FiguraModel> productos = new List <FiguraModel>();
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DB_Connection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = $"exec sp_listarFiguras";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader productoReader = command.ExecuteReader();
while (productoReader.Read())
{
FiguraModel productoTemp = new FiguraModel();
productoTemp.id = productoReader["id_figura"].ToString();
productoTemp.nombre = productoReader["nombre_figura"].ToString();
productoTemp.marca = productoReader["marca_figura"].ToString();
productoTemp.imagen = productoReader["imagen"].ToString();
productoTemp.precio = int.Parse(productoReader["precio"].ToString());
productos.Add(productoTemp);
} // while
connection.Close();
}
}
} // ModelState.IsValid
ViewBag.Figuras = productos;
return(View());
}
public IActionResult RegistrarFigura(FiguraModel productoModel)
{
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DB_Connection"];
var connection = new SqlConnection(connectionString);
string sqlQuery = $"exec insertFigura @nombre='{productoModel.nombre}'," +
$"@marca='{productoModel.marca}'," +
$"@imagen='{productoModel.imagen}'," +
$"@precio='{productoModel.precio}'";
//@id ,@nombre ,@marca ,@imagen ,@precio
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteReader();
connection.Close();
}
} // ModelState.IsValid
return(View());
} // Registrar
