use of com.github.lantoine.lamsadetools.conferences.Conference in project LAMSADE-tools by LAntoine.
the class Tester method main.
public static void main(String[] args) throws SQLException {
System.setProperty("SWT_GTK3", "0");
Display display = new Display();
Shell shell = new Shell(display);
// shell.setSize(300, 300);
shell.setText("Conference List");
GridLayout gridLayout = new GridLayout();
shell.setLayout(gridLayout);
shell.setLocation(400, 200);
shell.layout(true, true);
final Point newSize = shell.computeSize(SWT.DEFAULT, SWT.DEFAULT, true);
shell.setSize(new Point(888, 661));
/*
* Initialize Group conferencesInfos which will include : -The Grid data
* which will display conferences
*
* -The fields that will allow the user to add a new conference in the
* database
*/
Group grpUserDetails = new Group(shell, SWT.NONE);
GridData gd_grpUserDetails = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
gd_grpUserDetails.widthHint = 848;
gd_grpUserDetails.heightHint = 155;
grpUserDetails.setLayoutData(gd_grpUserDetails);
grpUserDetails.setText("User Details");
Label lblFirstname = new Label(grpUserDetails, SWT.NONE);
lblFirstname.setBounds(10, 26, 70, 15);
lblFirstname.setText("First Name");
Label lblNewLabel_1 = new Label(grpUserDetails, SWT.NONE);
lblNewLabel_1.setBounds(10, 53, 55, 15);
lblNewLabel_1.setText("Last Name");
txt_firstname = new Text(grpUserDetails, SWT.BORDER);
txt_firstname.setBounds(86, 23, 98, 21);
txt_lastname = new Text(grpUserDetails, SWT.BORDER);
txt_lastname.setBounds(86, 50, 98, 21);
/*
* Handle the User Info's Search Throws exception if firstname or
* lastname is wrong
*/
Button btn_searchInfo = new Button(grpUserDetails, SWT.NONE);
btn_searchInfo.addSelectionListener(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent arg0) {
try {
UserDetails user = GetInfosFromYearbook.getUserDetails(txt_lastname.getText(), txt_firstname.getText());
txt_function.setText(user.getFunction());
txt_number.setText(user.getNumber());
txt_email.setText(user.getEmail());
txt_group.setText(user.getGroup());
txt_fax.setText(user.getFax());
txt_office.setText(user.getOffice());
txt_city_ud.setText(user.getCity());
txt_country_ud.setText(user.getCountry());
} catch (@SuppressWarnings("unused") Exception e) {
MessageBox mb = new MessageBox(shell, SWT.ICON_ERROR | SWT.OK);
mb.setText("Error");
mb.setMessage("Please verify firstname and lastname");
mb.open();
}
}
});
btn_searchInfo.setBounds(10, 87, 114, 25);
btn_searchInfo.setText("Search My Infos");
Label lbl_function = new Label(grpUserDetails, SWT.NONE);
lbl_function.setBounds(224, 26, 55, 15);
lbl_function.setText("Function");
Label lbl_number = new Label(grpUserDetails, SWT.NONE);
lbl_number.setBounds(224, 56, 55, 15);
lbl_number.setText("Phone");
Label lbl_email = new Label(grpUserDetails, SWT.NONE);
lbl_email.setBounds(224, 92, 55, 15);
lbl_email.setText("E-mail");
Label lbl_group = new Label(grpUserDetails, SWT.NONE);
lbl_group.setBounds(224, 124, 55, 15);
lbl_group.setText("Group");
txt_function = new Text(grpUserDetails, SWT.BORDER);
txt_function.setBounds(285, 20, 219, 21);
txt_number = new Text(grpUserDetails, SWT.BORDER);
txt_number.setBounds(285, 53, 219, 21);
txt_email = new Text(grpUserDetails, SWT.BORDER);
txt_email.setBounds(285, 87, 219, 21);
txt_group = new Text(grpUserDetails, SWT.BORDER);
txt_group.setBounds(285, 121, 219, 21);
Label lbl_fax = new Label(grpUserDetails, SWT.NONE);
lbl_fax.setText("Fax");
lbl_fax.setBounds(535, 26, 55, 15);
Label lbl_office = new Label(grpUserDetails, SWT.NONE);
lbl_office.setText("Office");
lbl_office.setBounds(535, 59, 55, 15);
Label lbl_city = new Label(grpUserDetails, SWT.NONE);
lbl_city.setText("City");
lbl_city.setBounds(535, 92, 55, 15);
Label lbl_country = new Label(grpUserDetails, SWT.NONE);
lbl_country.setText("Country");
lbl_country.setBounds(535, 124, 55, 15);
txt_fax = new Text(grpUserDetails, SWT.BORDER);
txt_fax.setBounds(596, 23, 219, 21);
txt_office = new Text(grpUserDetails, SWT.BORDER);
txt_office.setBounds(596, 56, 219, 21);
txt_city_ud = new Text(grpUserDetails, SWT.BORDER);
txt_city_ud.setBounds(596, 89, 219, 21);
txt_country_ud = new Text(grpUserDetails, SWT.BORDER);
txt_country_ud.setBounds(596, 121, 219, 21);
Group grp_conferencesInfos = new Group(shell, SWT.NONE);
GridData gd_conferencesInfos = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
gd_conferencesInfos.heightHint = 237;
gd_conferencesInfos.widthHint = 854;
grp_conferencesInfos.setLayoutData(gd_conferencesInfos);
grp_conferencesInfos.setText("Conferences");
Table table = new Table(grp_conferencesInfos, SWT.V_SCROLL);
table.setBounds(165, 16, 502, 134);
table.setHeaderVisible(true);
fillConferenceTable(table);
Button btn_addNewConf = new Button(grp_conferencesInfos, SWT.NONE);
btn_addNewConf.setBounds(165, 156, 149, 25);
btn_addNewConf.setText("Create conference");
Label lblTitle = new Label(grp_conferencesInfos, SWT.NONE);
lblTitle.setAlignment(SWT.RIGHT);
lblTitle.setBounds(25, 16, 50, 15);
lblTitle.setText("Title");
Text txt_title = new Text(grp_conferencesInfos, SWT.BORDER);
txt_title.setBounds(81, 15, 78, 21);
Label lblUrl = new Label(grp_conferencesInfos, SWT.NONE);
lblUrl.setAlignment(SWT.RIGHT);
lblUrl.setText("URL");
lblUrl.setBounds(25, 45, 50, 15);
Text txt_url = new Text(grp_conferencesInfos, SWT.BORDER);
txt_url.setBounds(81, 42, 78, 21);
Label lblStartDate = new Label(grp_conferencesInfos, SWT.NONE);
lblStartDate.setAlignment(SWT.RIGHT);
lblStartDate.setText("Start Date");
lblStartDate.setBounds(10, 72, 65, 15);
Text txt_startDate = new Text(grp_conferencesInfos, SWT.BORDER);
txt_startDate.setBounds(81, 69, 78, 21);
Label lblEndDate = new Label(grp_conferencesInfos, SWT.NONE);
lblEndDate.setAlignment(SWT.RIGHT);
lblEndDate.setText("End Date");
lblEndDate.setBounds(10, 99, 65, 15);
Text txt_endDate = new Text(grp_conferencesInfos, SWT.BORDER);
txt_endDate.setBounds(81, 96, 78, 21);
Label lblFee = new Label(grp_conferencesInfos, SWT.NONE);
lblFee.setText("Fee");
lblFee.setBounds(42, 126, 33, 15);
Text txt_fee = new Text(grp_conferencesInfos, SWT.BORDER);
txt_fee.setBounds(81, 123, 78, 21);
// add news fields
/*
* Label lblCity= new Label(grp_conferencesInfos, SWT.NONE);
* lblCity.setAlignment(SWT.RIGHT); lblCity.setBounds(25, 38, 50, 15);
* lblCity.setText("City"); Text txt_city = new
* Text(grp_conferencesInfos, SWT.BORDER); txt_city.setBounds(81, 35,
* 78, 21);
*/
Label lblCity = new Label(grp_conferencesInfos, SWT.NONE);
lblCity.setAlignment(SWT.RIGHT);
lblCity.setBounds(25, 153, 50, 15);
lblCity.setText("City");
Text txt_city = new Text(grp_conferencesInfos, SWT.BORDER);
txt_city.setBounds(81, 150, 78, 21);
Label lbladdress = new Label(grp_conferencesInfos, SWT.NONE);
lbladdress.setAlignment(SWT.RIGHT);
lbladdress.setBounds(25, 180, 50, 15);
lbladdress.setText("Address");
Text txt_address = new Text(grp_conferencesInfos, SWT.BORDER);
txt_address.setBounds(81, 177, 78, 21);
// Create new Conference object, assign it values from
// selection, then pass it function to export to desktop
// public Conference(int id, String title, String url, LocalDate
// start_date, LocalDate end_date, double entry_fee)
Button btnExportEvent = new Button(grp_conferencesInfos, SWT.NONE);
btnExportEvent.addSelectionListener(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent e) {
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd/M/yyyy");
TableItem[] ti = table.getSelection();
if (ti.length == 0) {
// Put somewhere that an event should be selected
} else {
Conference conf = new Conference(ti[0].getText(0), ti[0].getText(1), LocalDate.parse(ti[0].getText(2), formatter), LocalDate.parse(ti[0].getText(3), formatter), Double.parseDouble(ti[0].getText(4)), ti[0].getText(5), ti[0].getText(6));
try {
FileDialog dialog = new FileDialog(shell, SWT.SAVE);
dialog.setFilterNames(new String[] { "Calendar Files", "All Files (*.*)" });
// Windows
dialog.setFilterExtensions(new String[] { "*.ics", "*.*" });
switch(Util.getOS()) {
case WINDOWS:
dialog.setFilterPath("c:\\");
break;
case LINUX:
dialog.setFilterPath("/");
break;
case MAC:
dialog.setFilterPath("/");
break;
case SOLARIS:
dialog.setFilterPath("/");
break;
default:
dialog.setFilterPath("/");
}
dialog.setFileName("conference.ics");
conf.generateCalendarFile(dialog.open());
} catch (IOException | ValidationException | ParserException e2) {
e2.printStackTrace();
}
}
}
});
btnExportEvent.setBounds(320, 154, 104, 28);
btnExportEvent.setText("Export Event");
/*
* Behavior of a click on the add new conference button
*/
btn_addNewConf.addSelectionListener(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent arg0) {
System.out.println("Appui sur le bouton");
if (!txt_title.getText().isEmpty() && !txt_url.getText().isEmpty() && !txt_startDate.getText().isEmpty() && !txt_startDate.getText().isEmpty() && !txt_endDate.getText().isEmpty() && !txt_fee.getText().isEmpty()) {
try {
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd/MM/yyyy");
LocalDate startDate = LocalDate.parse(txt_startDate.getText(), formatter);
LocalDate endDate = LocalDate.parse(txt_endDate.getText(), formatter);
Conference conf = new Conference(txt_title.getText(), txt_url.getText(), startDate, endDate, Double.parseDouble(txt_fee.getText()), txt_city.getText(), txt_address.getText());
ConferenceDatabase.insertInDatabase(conf);
/*
* Reload the conference table
*/
table.removeAll();
fillConferenceTable(table);
} catch (DateTimeParseException e1) {
MessageBox mb = new MessageBox(shell, SWT.ICON_ERROR | SWT.OK);
mb.setText("Date format error");
mb.setMessage("Please fill the dates in the following format : dd/MM/YYYY");
mb.open();
} catch (SQLException e2) {
throw new IllegalStateException(e2);
}
} else {
MessageBox mb = new MessageBox(shell, SWT.ICON_ERROR | SWT.OK);
mb.setText("Information missing");
mb.setMessage("Please fill in the information regarding the conference");
mb.open();
}
}
});
/*
* This group will help the user to see his itinerary into the browser
*/
Group grp_map = new Group(shell, SWT.NONE);
grp_map.setText("Visualize your travel");
GridData gd_map = new GridData(SWT.LEFT, SWT.CENTER, false, true, 1, 1);
gd_map.heightHint = 85;
gd_map.widthHint = 860;
grp_map.setLayoutData(gd_map);
Text departure = new Text(grp_map, SWT.BORDER);
departure.setLocation(101, 22);
departure.setSize(196, 21);
Text arrival = new Text(grp_map, SWT.BORDER);
arrival.setLocation(101, 51);
arrival.setSize(196, 21);
Button btnItinerary = new Button(grp_map, SWT.NONE);
btnItinerary.setText("Validate");
btnItinerary.setBounds(303, 49, 68, 25);
Label lblDeparture = new Label(grp_map, SWT.NONE);
lblDeparture.setAlignment(SWT.RIGHT);
lblDeparture.setBounds(10, 25, 73, 15);
lblDeparture.setText("Departure");
Label lblArrival = new Label(grp_map, SWT.NONE);
lblArrival.setAlignment(SWT.RIGHT);
lblArrival.setBounds(10, 54, 73, 15);
lblArrival.setText("Arrival");
/*
* Behavior of the btnItinerary : Takes the addresses entered in
* departure and arrival Texts and call the ItineraryMap class to open
* the itinerary into the browser
*/
btnItinerary.addSelectionListener(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent arg0) {
System.out.println("Appui sur le bouton");
if (!departure.getText().isEmpty() && !arrival.getText().isEmpty()) {
try {
AddressInfos dep = new AddressInfos(departure.getText());
AddressInfos arr = new AddressInfos(arrival.getText());
// ItineraryMap itinerary = new
// ItineraryMap(dep.getLongitude(),
// dep.getLatitude(),arr.getLongitude(),
// arr.getLatitude());
GoogleItineraryMap itinerary = new GoogleItineraryMap(departure.getText(), arrival.getText());
String url = itinerary.setMapUrl();
System.out.println(url);
itinerary.openMapUrl(url);
} catch (IllegalArgumentException e) {
LOGGER.error("Error : ", e);
}
} else {
MessageBox mb = new MessageBox(shell, SWT.ICON_ERROR | SWT.OK);
mb.setText("Infromation missing");
mb.setMessage("Please fill in the departure and arrival fields");
mb.open();
}
}
});
arrival.addModifyListener(new ModifyListener() {
@Override
public void modifyText(ModifyEvent e) {
System.out.println("nouvelle valeur = " + ((Text) e.widget).getText());
}
});
departure.addModifyListener(new ModifyListener() {
@Override
public void modifyText(ModifyEvent e) {
System.out.println("nouvelle valeur = " + ((Text) e.widget).getText());
}
});
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
display.dispose();
}
use of com.github.lantoine.lamsadetools.conferences.Conference in project LAMSADE-tools by LAntoine.
the class ConferenceDatabasePrompter method editConference.
/**
* A menu which enables the user to edit a conference
*
* @throws SQLException
*/
public static void editConference() throws SQLException {
try (Scanner sc = new Scanner(System.in)) {
DateTimeFormatter dtf = DateTimeFormatter.ofPattern(Conference.DATE_FORMAT);
dtf.withLocale(Locale.FRANCE);
System.out.println("conférenceID : ");
int id = sc.nextInt();
System.out.println("New title (optional): ");
String title = sc.nextLine();
System.out.println("New URL (optional): ");
String url = sc.nextLine();
System.out.println("New start date (" + Conference.DATE_FORMAT + ") (optional): ");
LocalDate start_date = LocalDate.parse(sc.nextLine(), dtf);
System.out.println("New end date (" + Conference.DATE_FORMAT + ") (optional): ");
LocalDate end_date = LocalDate.parse(sc.nextLine(), dtf);
System.out.println("New title (optional): ");
double entry_fee = sc.nextDouble();
System.out.println("New city: ");
String city = sc.nextLine();
System.out.println("New country: ");
String country = sc.nextLine();
Conference conf = new Conference(id, title, url, start_date, end_date, entry_fee, city, country);
if (ConferenceDatabasePrompter.editConferenceInDatabase(conf)) {
System.out.println("Edit Successful");
} else {
System.out.println("Edit failed");
}
}
}
use of com.github.lantoine.lamsadetools.conferences.Conference in project LAMSADE-tools by LAntoine.
the class ConferenceDatabase method returnAllConferencesFromDatabase.
/**
* Function to return an ArrayList of conferences
*
* @return an ArrayList of all the conferences
* @throws SQLException
*/
public static ArrayList<Conference> returnAllConferencesFromDatabase() throws SQLException {
ArrayList<Conference> conferencesArray = new ArrayList<>();
ConnectionDataBase connectionDataBase2 = ConferenceDatabase.getConnectionDataBase();
assert connectionDataBase2 != null;
try (Connection conn = connectionDataBase2.getConnection()) {
createTable();
try (Statement state = conn.createStatement()) {
try (ResultSet result = state.executeQuery("SELECT * FROM conference")) {
DateFormat format = new SimpleDateFormat(Conference.DATE_FORMAT);
format.setLenient(false);
while (result.next()) {
int _id = result.getInt(1);
String _url = result.getString(2);
String _title = result.getString(3);
LocalDate _start_date = LocalDate.parse(result.getString(4));
LocalDate _end_date = LocalDate.parse(result.getString(5));
double _entry_fee = result.getDouble(6);
String city = result.getString(7);
String address = result.getString(8);
conferencesArray.add(new Conference(_id, _url, _title, _start_date, _end_date, _entry_fee, city, address));
}
result.close();
}
return conferencesArray;
}
}
}
use of com.github.lantoine.lamsadetools.conferences.Conference in project LAMSADE-tools by LAntoine.
the class ConferenceDatabase method enumerateResultsToCreateConference.
/**
* Enumerates the data from a ResultSet object created in the
* getConferencesFromDatabase and creates a conference. This method should
* not be called manually!!
*
* @param result
* a ResultSet object containing the results of a SQL query to
* the database
* @throws SQLException
*/
private static void enumerateResultsToCreateConference(ResultSet result) throws SQLException {
ArrayList<Conference> conferencesArray = new ArrayList<>();
while (result.next()) {
int id = result.getInt(1);
String url = result.getString(2);
String title = result.getString(3);
LocalDate start_date = LocalDate.parse(result.getString(4));
LocalDate end_date = LocalDate.parse(result.getString(5));
double entry_fee = result.getDouble(6);
String city = result.getString(7);
String country = result.getString(8);
conferencesArray.add(new Conference(id, url, title, start_date, end_date, entry_fee, city, country));
}
for (Conference i : conferencesArray) {
System.out.println("####################");
System.out.println("Conference: " + i.getTitle() + " (" + i.getUrl() + ")");
System.out.println("From the " + i.getStart_date() + " to the " + i.getEnd_date());
System.out.println("in " + i.getCity() + " to this country " + i.getCountry());
System.out.println("Fee: " + i.getEntry_fee());
}
}
use of com.github.lantoine.lamsadetools.conferences.Conference in project LAMSADE-tools by LAntoine.
the class Tester method fillConferenceTable.
/**
* fillConferenceTable takes a table in parameter that will be filled with
* all the conferences information
*
* @param table
* @throws SQLException
*/
private static void fillConferenceTable(Table table) throws SQLException {
String[] titles = { "Title", "URL", "Start Date", "End Date", "Fee", "City", "Address" };
ArrayList<Conference> confs = ConferenceDatabase.returnAllConferencesFromDatabase();
for (String title : titles) {
System.out.println(title);
TableColumn column = new TableColumn(table, SWT.NULL);
column.setText(title);
}
for (Conference i : confs) {
TableItem item = new TableItem(table, SWT.NULL);
item.setText(0, i.getTitle());
System.out.println(item.getText(0));
item.setText(1, i.getUrl());
item.setText(2, convertLocaldateToString(i.getStart_date()));
item.setText(3, convertLocaldateToString(i.getEnd_date()));
item.setText(4, Double.toString(i.getEntry_fee()));
item.setText(5, i.getCity());
item.setText(6, i.getAddress());
}
for (int loopIndex = 0; loopIndex < titles.length; loopIndex++) {
table.getColumn(loopIndex).pack();
}
}
Aggregations