public void crearPlatoDeComida(PlatoDeComida platoDeComida) { using (var conn = new SqlConnection(this.CONECCION_STRING)) { conn.Open(); // 1. create a command object identifying the stored procedure SqlCommand cmd = new SqlCommand("dbo.crearPlatoDeComida", conn); // 2. set the command object so it knows to execute a stored procedure cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@nombrePlato", platoDeComida.obtenerNombrePlato())); cmd.Parameters.Add(new SqlParameter("@precioPlato", platoDeComida.obtenerValorPlato())); // execute the command using (SqlDataReader rdr = cmd.ExecuteReader()) { // iterate through results, printing each to console while (rdr.Read()) { Console.WriteLine("Product: {0,-35} Total: {1,2}", rdr["nombrePlato"], rdr["precioPlato"]); } } conn.Close(); } }
public int registrarPlato(PlatoDeComida plato) { consultaString = "insert into PlatoDeComida (nombrePlato,precioPlato,tipoPlato,activoPlato )" + " values ('" + plato.obtenerNombrePlato() + "', '" + plato.obtenerValorPlato() + "', '" + plato.obtenerTipo() + "', 'Si' );"; coneccion = new SqlConnection(CONECCION_STRING); coneccion.Open(); if (coneccion.State == System.Data.ConnectionState.Open) { comandoQuery = new SqlCommand(consultaString, coneccion); int i = Convert.ToInt16(comandoQuery.ExecuteNonQuery()); coneccion.Close(); return(i); } return(-1); }