static public Entidades.SprayBoom buscarSprayBoom(string id) { Conexion.OpenConnection(); Entidades.SprayBoom s = new Entidades.SprayBoom(); string query = "Select* from SprayBoom Where idSprayBoom LIKE @idSprayBoom"; MySqlCommand comando = new MySqlCommand(query, Conexion.Connection); comando.Parameters.AddWithValue("@idSprayBoom", id); comando.Prepare(); MySqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { s.Boquilla = reader.GetString("boquilla"); s.Capacidad = reader.GetDouble("capacidad"); s.IdSprayBoom = reader.GetString("idSprayBoom"); s.Km = reader.GetString("km"); s.Marcha = reader.GetString("marcha"); s.Metodo = reader.GetString("metodo"); s.Psi = reader.GetDouble("psi"); s.Rpm = reader.GetDouble("rpm"); Conexion.CloseConnection(); return(s); } //retorna valores nulos en caso de no encontrar coincidencias Conexion.CloseConnection(); return(s); }
static public void eliminar(Entidades.SprayBoom s) { Conexion.OpenConnection(); string query = "DELETE from SprayBoom WHERE idSprayBoom = @idSprayBoom"; MySqlCommand comando = new MySqlCommand(query, Conexion.Connection); comando.Parameters.AddWithValue("@idSprayBoom", s.IdSprayBoom); comando.Prepare(); comando.ExecuteNonQuery(); Conexion.CloseConnection(); }
static public void modificar(Entidades.SprayBoom s) { Conexion.OpenConnection(); string query = "UPDATE sprayboom set capacidad = @capacidad, psi = @psi, rpm = @rpm, boquilla = @boquilla, km = @km, marcha = @marcha, metodo = @metodo WHERE idSprayBoom = @idSprayBoom"; MySqlCommand comando = new MySqlCommand(query, Conexion.Connection); comando.Parameters.AddWithValue("@idSprayBoom", s.IdSprayBoom); comando.Parameters.AddWithValue("@capacidad", s.Capacidad); comando.Parameters.AddWithValue("@psi", s.Psi); comando.Parameters.AddWithValue("@rpm", s.Rpm); comando.Parameters.AddWithValue("@boquilla", s.Boquilla); comando.Parameters.AddWithValue("@km", s.Km); comando.Parameters.AddWithValue("@marcha", s.Marcha); comando.Parameters.AddWithValue("@metodo", s.Metodo); comando.Prepare(); comando.ExecuteNonQuery(); Conexion.CloseConnection(); }
static public void insertar(Entidades.SprayBoom s) { Conexion.OpenConnection(); string query = "insert into sprayboom (idSprayBoom, capacidad, psi, rpm, boquilla, km, marcha, metodo) values(@idSprayBoom, @capacidad, @psi, @rpm, @boquilla, @km, @marcha, @metodo)"; MySqlCommand comando = new MySqlCommand(query, Conexion.Connection); comando.Parameters.AddWithValue("@idSprayBoom", s.IdSprayBoom); comando.Parameters.AddWithValue("@capacidad", s.Capacidad); comando.Parameters.AddWithValue("@psi", s.Psi); comando.Parameters.AddWithValue("@rpm", s.Rpm); comando.Parameters.AddWithValue("@boquilla", s.Boquilla); comando.Parameters.AddWithValue("@km", s.Km); comando.Parameters.AddWithValue("@marcha", s.Marcha); comando.Parameters.AddWithValue("@metodo", s.Metodo); comando.Prepare(); comando.ExecuteNonQuery(); Conexion.CloseConnection(); }