public bool pagarconTarjeta(Pago pago, string nroTarjeta, int idReserva) { bool reserva = false; bool exito = false; ReservaDAO reservadao = new ReservaDAO(); TarjetaDAO tarjetadao = new TarjetaDAO(); double montoAPagar = reservadao.retornarmonto(idReserva); double saldoDisponible = tarjetadao.retornarSaldoTarjeta(nroTarjeta); if (saldoDisponible > montoAPagar) { //Quitar saldo : bool resul = false; resul = tarjetadao.quitarSaldo(montoAPagar, nroTarjeta); if (resul) { //Insertar Pago : string query = "INSERT INTO Pago values(@p1,@p2,@p3,@p4)"; SqlParameter[] dbParams = new SqlParameter[] { DBHelper.MakeParam("@p1", pago.nroPago), DBHelper.MakeParam("@p2", montoAPagar), DBHelper.MakeParam("@p3", "Cancelado"), DBHelper.MakeParam("@p4", idReserva) }; exito = DBHelper.ExecuteNonQuery(query, dbParams) > 0; if (exito) { //Cancelar Reservar : reserva = reservadao.cancelarReserva(idReserva); } } } return(reserva); }
public bool pagarConEfectivo(string nropago) { ReservaDAO reservadao = new ReservaDAO(); bool resul = false; int idReservaUp = retornaidReserva(nropago); bool exito = false; string query = "update Pago set estado='Cancelado' where nroPago=@pnroPago"; SqlParameter[] dbParam = new SqlParameter[] { DBHelper.MakeParam("@pnroPago", nropago) }; exito = DBHelper.ExecuteNonQuery(query, dbParam) > 0; if (exito) { //Cancelar-Reserva. resul = reservadao.cancelarReserva(idReservaUp); } return(resul); }