public void EliminarChofer(E_autobuses chofer) { SqlCommand cmd = new SqlCommand("SP_ELIMINARAUTOBUS", conexion); cmd.CommandType = CommandType.StoredProcedure; conexion.Open(); cmd.Parameters.AddWithValue("@ID", chofer.ID); cmd.ExecuteNonQuery(); conexion.Close(); }
public void insertarChofer(E_autobuses chofer) { SqlCommand cmd = new SqlCommand("SP_GUARDARAUTOBUS", conexion); cmd.CommandType = CommandType.StoredProcedure; conexion.Open(); cmd.Parameters.AddWithValue("@IDCHOFER", chofer.IDCHOFER); cmd.Parameters.AddWithValue("@MARCA", chofer.MARCA); cmd.Parameters.AddWithValue("@MODELO", chofer.MODELO); cmd.Parameters.AddWithValue("@PLACA", chofer.PLACA); cmd.Parameters.AddWithValue("@COLOR", chofer.COLOR); cmd.Parameters.AddWithValue("@ANO", chofer.ANO); cmd.ExecuteNonQuery(); conexion.Close(); }
public void EditandoCategoria(E_autobuses choferes) { objDato.EditarChofer(choferes); }
public void EliminandoCategoria(E_autobuses choferes) { objDato.EliminarChofer(choferes); }
public void InsertandoCategoria(E_autobuses choferes) { objDato.insertarChofer(choferes); }