public String tryMakeReservation(String date, String movieName, String username) {
		Savepoint savepoint = null;
		try {
			savepoint = conn.setSavepoint();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if(savepoint == null){
			return null;
		}
		
		if(getNumberOfAvailableSeats(date, movieName) > 0){
			
			int rNum =  makeReservation(date, movieName, username);
			if(rNum >= 0){
				return Integer.toString(rNum);
			} else {
				try {
					conn.rollback(savepoint);
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		} else {
			try {
				conn.rollback(savepoint);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}