public void ModificarDatos(ReservasVehiculo Rvehiculo) { var sql = "UPDATE reservaVehiculo SET tipoauto = '" + Rvehiculo.tipoAuto + "', retira = '" + Rvehiculo.Retira + "', entrega = '" + Rvehiculo.Entrega + "', id_Vehiculo = '" + Rvehiculo.id_Vehiculos + "' WHERE id = '" + Rvehiculo.id + "'"; _dataAccessBase.ExecuteNonQuery(sql); }
public void InsertarDatos(ReservasVehiculo Rvehiculo) { var sql = "INSERT INTO reservaVehiculo (tipoauto, retira, entrega, id_Vehiculo) VALUES ('" + Rvehiculo.tipoAuto + "', '" + Rvehiculo.Retira + "', '" + Rvehiculo.Entrega + "', '" + Rvehiculo.id_Vehiculos + "')"; _dataAccessBase.ExecuteNonQuery(sql); }
private void InsertarReservaV() { var reservaVehi = new ReservasVehiculo { tipoAuto = textBox6.Text, Retira = dateTimePicker5.Value.ToString("dd/MM/yyyy"), Entrega = dateTimePicker6.Value.ToString("dd/MM/yyyy"), id_Vehiculos = dataGridView3.CurrentRow.Cells[0].Value.ToString() }; var rVehi = new ReservaVehiculo(); try { rVehi.InsertarDatos(reservaVehi); MonstrarMensaje("Reserva Vehiculo creado satisfactoriamente"); } catch (Exception e) { MonstrarError(e.Message); } }