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