public void init() {
a = new TextArea("", 15, 50);
add(a);
Button t = new Button("Translate");
add(t);
b = new TextArea("", 15, 50);
add(b);
t.addActionListener(this);
}
/** Method declaration */
private void initGUI() {
Panel pQuery = new Panel();
Panel pCommand = new Panel();
pResult = new Panel();
pQuery.setLayout(new BorderLayout());
pCommand.setLayout(new BorderLayout());
pResult.setLayout(new BorderLayout());
Font fFont = new Font("Dialog", Font.PLAIN, 12);
txtCommand = new TextArea(5, 40);
txtCommand.addKeyListener(this);
txtResult = new TextArea(20, 40);
txtCommand.setFont(fFont);
txtResult.setFont(new Font("Courier", Font.PLAIN, 12));
butExecute = new Button("Execute");
butClear = new Button("Clear");
butExecute.addActionListener(this);
butClear.addActionListener(this);
pCommand.add("East", butExecute);
pCommand.add("West", butClear);
pCommand.add("Center", txtCommand);
gResult = new Grid();
setLayout(new BorderLayout());
pResult.add("Center", gResult);
pQuery.add("North", pCommand);
pQuery.add("Center", pResult);
fMain.add("Center", pQuery);
tTree = new Tree();
// (ulrivo): screen with less than 640 width
Dimension d = Toolkit.getDefaultToolkit().getScreenSize();
if (d.width >= 640) {
tTree.setMinimumSize(new Dimension(200, 100));
} else {
tTree.setMinimumSize(new Dimension(80, 100));
}
gResult.setMinimumSize(new Dimension(200, 300));
fMain.add("West", tTree);
doLayout();
fMain.pack();
}
public Deta_Ventas_r() {
setBackground(Color.gray);
setLayout(null);
setSize(400, 400);
l1 = new Label(" clave ");
t1 = new TextField(36);
l2 = new Label("Vendedor");
t2 = new TextField(20);
l3 = new Label("Cliente");
t3 = new TextField(20);
l4 = new Label("Fechas");
t4 = new TextField(5);
l5 = new Label("monto_final");
t5 = new TextField(5);
t4.setEditable(false);
t5.setEditable(false);
b = new Button("Registrar");
add(l1);
add(t1);
add(l2);
add(t2);
add(l3);
add(t3);
add(l4);
add(t4);
add(l5);
add(t5);
add(b);
l1.setBounds(24, 75, 71, 23);
l2.setBounds(24, 103, 90, 23);
l3.setBounds(24, 131, 90, 23);
l4.setBounds(24, 159, 90, 23);
l5.setBounds(24, 185, 90, 23);
t1.setBounds(114, 75, 270, 23);
t2.setBounds(114, 103, 270, 23);
t3.setBounds(114, 131, 270, 23);
t4.setBounds(114, 159, 270, 23);
t5.setBounds(114, 185, 270, 23);
b.setBounds(167, 215, 65, 23);
b.addActionListener(this);
setUndecorated(true);
setLocation((Toolkit.getDefaultToolkit().getScreenSize().width / 2) - 200, 50);
start();
}
public LoginScreen(final Home hm) {
setSize(600, 550);
setLayout(null);
this.hm = hm;
name = new Label("Username : "******"Password :"******"login");
login.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
if (isValidUser()) {
hm.removeAll();
hm.userId = nameText.getText();
hm.p2 = new BaseApplet(hm);
hm.p2.setBounds(0, 50, 600, 550);
hm.add(hm.p2);
hm.revalidate();
} else {
JOptionPane.showMessageDialog(
null, "Invalid Credentials", "Alert", JOptionPane.OK_OPTION);
}
} catch (Exception e1) {
System.out.println("Error");
}
}
});
login.setBounds(200, 150, 100, 30);
add(login);
}
public void addBody(Body body)
throws SAXException, WingException, UIException, SQLException, IOException,
AuthorizeException {
// If we are actually editing information of an uploaded file,
// then display that body instead!
if (this.editFile != null) {
editFile.addBody(body);
return;
}
// Get a list of all files in the original bundle
Item item = submission.getItem();
Collection collection = submission.getCollection();
String actionURL =
contextPath + "/handle/" + collection.getHandle() + "/submit/" + knot.getId() + ".continue";
boolean disableFileEditing =
(submissionInfo.isInWorkflow())
&& !ConfigurationManager.getBooleanProperty("workflow", "reviewer.file-edit");
Bundle[] bundles = item.getBundles("ORIGINAL");
Bitstream[] bitstreams = new Bitstream[0];
if (bundles.length > 0) {
bitstreams = bundles[0].getBitstreams();
}
// Part A:
// First ask the user if they would like to upload a new file (may be the first one)
Division div =
body.addInteractiveDivision(
"submit-upload", actionURL, Division.METHOD_MULTIPART, "primary submission");
div.setHead(T_submission_head);
addSubmissionProgressList(div);
List upload = null;
if (!disableFileEditing) {
// Only add the upload capabilities for new item submissions
upload = div.addList("submit-upload-new", List.TYPE_FORM);
upload.setHead(T_head);
addRioxxVersionSection(upload, item);
File file = upload.addItem().addFile("file");
file.setLabel(T_file);
file.setHelp(T_file_help);
file.setRequired();
// if no files found error was thrown by processing class, display it!
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_NO_FILES_ERROR) {
file.addError(T_file_error);
}
// if an upload error was thrown by processing class, display it!
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_UPLOAD_ERROR) {
file.addError(T_upload_error);
}
// if virus checking was attempted and failed in error then let the user know
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_VIRUS_CHECKER_UNAVAILABLE) {
file.addError(T_virus_checker_error);
}
// if virus checking was attempted and a virus found then let the user know
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_CONTAINS_VIRUS) {
file.addError(T_virus_error);
}
Text description = upload.addItem().addText("description");
description.setLabel(T_description);
description.setHelp(T_description_help);
Button uploadSubmit = upload.addItem().addButton("submit_upload");
uploadSubmit.setValue(T_submit_upload);
}
make_sherpaRomeo_submission(item, div);
// Part B:
// If the user has already uploaded files provide a list for the user.
if (bitstreams.length > 0 || disableFileEditing) {
Table summary = div.addTable("submit-upload-summary", (bitstreams.length * 2) + 2, 7);
summary.setHead(T_head2);
Row header = summary.addRow(Row.ROLE_HEADER);
header.addCellContent(T_column0); // primary bitstream
header.addCellContent(T_column1); // select checkbox
header.addCellContent(T_column2); // file name
header.addCellContent(T_column3); // size
header.addCellContent(T_column4); // description
header.addCellContent(T_column5); // format
header.addCellContent(T_column6); // edit button
for (Bitstream bitstream : bitstreams) {
int id = bitstream.getID();
String name = bitstream.getName();
String url = makeBitstreamLink(item, bitstream);
long bytes = bitstream.getSize();
String desc = bitstream.getDescription();
String algorithm = bitstream.getChecksumAlgorithm();
String checksum = bitstream.getChecksum();
Row row = summary.addRow();
// Add radio-button to select this as the primary bitstream
Radio primary = row.addCell().addRadio("primary_bitstream_id");
primary.addOption(String.valueOf(id));
// If this bitstream is already marked as the primary bitstream
// mark it as such.
if (bundles[0].getPrimaryBitstreamID() == id) {
primary.setOptionSelected(String.valueOf(id));
}
if (!disableFileEditing) {
// Workflow users can not remove files.
CheckBox remove = row.addCell().addCheckBox("remove");
remove.setLabel("remove");
remove.addOption(id);
} else {
row.addCell();
}
row.addCell().addXref(url, name);
row.addCellContent(bytes + " bytes");
if (desc == null || desc.length() == 0) {
row.addCellContent(T_unknown_name);
} else {
row.addCellContent(desc);
}
BitstreamFormat format = bitstream.getFormat();
if (format == null) {
row.addCellContent(T_unknown_format);
} else {
int support = format.getSupportLevel();
Cell cell = row.addCell();
cell.addContent(format.getMIMEType());
cell.addContent(" ");
switch (support) {
case 1:
cell.addContent(T_supported);
break;
case 2:
cell.addContent(T_known);
break;
case 3:
cell.addContent(T_unsupported);
break;
}
}
Button edit = row.addCell().addButton("submit_edit_" + id);
edit.setValue(T_submit_edit);
Row checksumRow = summary.addRow();
checksumRow.addCell();
Cell checksumCell = checksumRow.addCell(null, null, 0, 6, null);
checksumCell.addHighlight("bold").addContent(T_checksum);
checksumCell.addContent(" ");
checksumCell.addContent(algorithm + ":" + checksum);
}
if (!disableFileEditing) {
// Workflow users can not remove files.
Row actionRow = summary.addRow();
actionRow.addCell();
Button removeSeleceted =
actionRow.addCell(null, null, 0, 6, null).addButton("submit_remove_selected");
removeSeleceted.setValue(T_submit_remove);
}
upload = div.addList("submit-upload-new-part2", List.TYPE_FORM);
}
// Part C:
// add standard control/paging buttons
addControlButtons(upload);
}
mupdate() {
f = new JFrame("POS");
p = new Panel();
l1 = new Label("Welcome:Admin");
l2 = new Label("POINT OF SALE");
l14 = new Label("Enter Manager_Id");
l3 = new Label("Name");
l4 = new Label("Father's_Name");
l5 = new Label("Manager_Id");
l6 = new Label("Password");
l7 = new Label("Gender");
l9 = new Label("Address");
l8 = new Label("D.O.B.");
l10 = new Label("Contact_No.");
l11 = new Label("E-Mail_Id");
l12 = new Label("Location");
l13 =
new Label(
"_______________________________________________________________________________________________");
l15 =
new Label(
"_______________________________________________________________________________________________________________________");
cbg = new CheckboxGroup();
c1 = new Checkbox("Male", cbg, false);
c2 = new Checkbox("Female", cbg, false);
t11 = new TextField();
t2 = new TextField();
t3 = new TextField();
t4 = new TextField();
t5 = new TextField();
t6 = new TextField();
t7 = new TextField();
t8 = new TextField();
t9 = new TextField();
t10 = new TextField();
try {
t1 = new Choice();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from mprofile");
while (rs.next()) {
String a2 = rs.getString(3);
t1.add(a2);
}
} catch (Exception e) {
System.out.println(e);
}
b1 = new Button("Search");
b2 = new Button("Update");
b3 = new Button("Calendar");
b4 = new Button("Close");
b5 = new Button("Back");
b6 = new Button("Logout");
f1 = new Font("sherif", Font.BOLD | Font.ITALIC, 45);
f2 = new Font("sherif", Font.BOLD | Font.ITALIC, 30);
f3 = new Font("sherif", Font.BOLD | Font.ITALIC, 35);
f4 = new Font("sherif", Font.BOLD, 20);
f5 = new Font("sherif", Font.BOLD | Font.ITALIC, 15);
f6 = new Font("sherif", Font.BOLD | Font.ITALIC, 20);
l1.setFont(f5);
l2.setFont(f1);
l3.setFont(f6);
l4.setFont(f6);
l5.setFont(f6);
l6.setFont(f6);
l7.setFont(f6);
l8.setFont(f6);
l9.setFont(f6);
l10.setFont(f6);
l11.setFont(f6);
l12.setFont(f6);
l13.setFont(f6);
l14.setFont(f6);
b1.setFont(f6);
b2.setFont(f6);
b3.setFont(f6);
b4.setFont(f6);
b5.setFont(f6);
b6.setFont(f6);
}
public void actionPerformed(ActionEvent ae) {
String s1 = ae.getActionCommand();
if (s1.equals("Calendar")) {
// DatePicker dp=new DatePicker(f);
// dp.displayDate();
// f.getContentPane().add(p);
b3.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent ae) {
t6.setText(new DatePicker(f).setPickedDate());
}
});
} else if (s1.equals("LogOut")) {
f.dispose();
start p = new start();
p.method();
} else if (s1.equals("Search")) {
try {
String data = t1.getSelectedItem();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from mprofile where Manager_Id='" + data + "' ");
while (rs.next()) {
String a2 = rs.getString(1);
t2.setText(a2);
String a3 = rs.getString(2);
t3.setText(a3);
String a4 = rs.getString(3);
t4.setText(a4);
String a5 = rs.getString(4);
t5.setText(a5);
String a6 = rs.getString(6);
t6.setText(a6);
String a7 = rs.getString(7);
t7.setText(a7);
String a8 = rs.getString(8);
t8.setText(a8);
String a9 = rs.getString(9);
t9.setText(a9);
String a10 = rs.getString(10);
t10.setText(a10);
p.add(l3);
p.add(t2);
p.add(l4);
p.add(t3);
p.add(l5);
p.add(t4);
p.add(l6);
p.add(t5);
p.add(l7);
p.add(c1);
p.add(c2);
p.add(l8);
p.add(t6);
p.add(l9);
p.add(t7);
p.add(l10);
p.add(t8);
p.add(l11);
p.add(t9);
p.add(l12);
p.add(t10);
p.add(b2);
p.add(b3);
p.add(b4);
}
} catch (Exception e) {
}
} else if (s1.equals("Update")) {
String y2 = t2.getText();
String y3 = t3.getText();
String update_id = t4.getText();
String y4 = t5.getText();
String y6 = t6.getText();
String y7 = t7.getText();
String y8 = t8.getText();
String y9 = t9.getText();
String y10 = t10.getText();
try {
String y = t1.getSelectedItem();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
PreparedStatement ps =
con.prepareStatement(
"update mprofile set Location=? , E_Mail_Id=? ,Contact_No =?, Address=?, D_O_B=?,Gender=?, Password=?, Manager_Id=?,manager_father=?,manager_name=? where Manager_Id='"
+ y
+ "' ");
ps.setString(1, y10);
ps.setString(2, y9);
ps.setString(3, y8);
ps.setString(4, y7);
ps.setString(5, y6);
ps.setString(6, g);
ps.setString(7, y4);
ps.setString(8, update_id);
ps.setString(9, y3);
ps.setString(10, y2);
ps.executeUpdate();
JOptionPane.showMessageDialog(p, "data has been updated");
f.dispose();
project p = new project();
p.method();
} catch (Exception e) {
System.out.println(e);
}
} else if (s1.equals("Close")) {
f.dispose();
} else {
f.dispose();
project p = new project();
p.method();
}
}
void launch() {
f.setSize(800, 800);
p.setLayout(null);
l1.setBounds(600, 10, 150, 36);
l2.setBounds(100, 30, 400, 70);
l13.setBounds(2, 90, 1200, 20);
l14.setBounds(80, 150, 250, 30);
t1.setBounds(330, 150, 150, 30);
b1.setBounds(500, 150, 100, 30);
l15.setBounds(2, 200, 1200, 20);
b6.setBounds(600, 50, 100, 30);
l3.setBounds(100, 250, 100, 30);
t2.setBounds(300, 250, 150, 30);
l4.setBounds(100, 300, 150, 30);
t3.setBounds(300, 300, 150, 30);
l5.setBounds(100, 350, 150, 30);
t4.setBounds(300, 350, 150, 30);
l6.setBounds(100, 400, 100, 30);
t5.setBounds(300, 400, 150, 30);
l7.setBounds(100, 450, 100, 30);
c1.setBounds(300, 450, 60, 30);
c2.setBounds(400, 450, 60, 30);
l8.setBounds(100, 500, 100, 30);
t6.setBounds(300, 500, 150, 30);
l9.setBounds(100, 550, 100, 30);
t7.setBounds(300, 550, 150, 30);
l10.setBounds(100, 600, 120, 30);
t8.setBounds(300, 600, 150, 30);
l11.setBounds(100, 650, 100, 30);
t9.setBounds(300, 650, 150, 30);
l12.setBounds(100, 700, 150, 30);
t10.setBounds(300, 700, 150, 30);
b2.setBounds(500, 400, 100, 30);
b3.setBounds(500, 500, 100, 30);
b4.setBounds(500, 600, 100, 30);
b5.setBounds(650, 150, 100, 30);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
b6.addActionListener(this);
c1.addItemListener(this);
c2.addItemListener(this);
p.add(l1);
p.add(l2);
p.add(l13);
p.add(l14);
p.add(t1);
p.add(b1);
p.add(l15);
p.add(b5);
p.add(b6);
f.add(p);
f.setVisible(true);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void start(Stage primaryStage) throws Exception {
// Connecting to Access DB
connect();
// Declaration of variable window as primaryStage
window = primaryStage;
window.setTitle("Icooköp");
primaryStage.setTitle("Icooköp");
// Calls method closeProgram() also when terminating the program
window.setOnCloseRequest(e -> closeProgram());
// ---------------------SCENE1--------------------------
// Scene 1 Welcome Label
Label labelScene1 = new Label();
labelScene1.setText("Välkommen till Icooköp beta v0.2!");
labelScene1.setFont(Font.font("Verdana", 20));
// Scene 1 left menu with spacing
VBox scene1leftMenu = new VBox(15);
scene1leftMenu.setPadding(new Insets(20, 20, 20, 20));
// Calls closeProgram()
Button s1q1 = new Button("Avsluta");
s1q1.setOnAction(e -> closeProgram());
// Displays all available product types
Button s1b1 = new Button("Visa produkttyper");
s1b1.setOnAction(e -> createStatement());
// TableView object for displaying database data.
tableview = new TableView();
// TextField for user input of a selected product.
Label s1l1 = new Label();
s1l1.setText("Visa märken till produktgrupp");
// Calls preparedStatement with product parameter
choiceBox1 = new ChoiceBox<>();
getProductTypes();
choiceBox1
.getSelectionModel()
.selectedItemProperty()
.addListener((v, oldValue, newValue) -> preparedStatement(newValue));
// Button for switching to scene 2 (insertStamkund)
Button s1b3 = new Button("Lägg till stamkund");
s1b3.setOnAction(e -> window.setScene(scene2));
// Label for drop down menu
Label s1l2 = new Label();
s1l2.setText("Se butiksaldo");
// Creating ChoiceBox (drop down) with all the stores.
// When choosing a store, storeStock() method is called for that store.
choiceBox2 = new ChoiceBox<>();
getStores();
choiceBox2
.getSelectionModel()
.selectedItemProperty()
.addListener((v, oldValue, newValue) -> storeStock(newValue));
// Adding buttons, labels, text fields and choicebox (drop down) to left menu
scene1leftMenu
.getChildren()
.addAll(labelScene1, s1q1, s1b1, s1l1, choiceBox1, s1b3, s1l2, choiceBox2);
// Creating BorderPane object and aligning left and center content
BorderPane Borderpane1 = new BorderPane();
Borderpane1.setLeft(scene1leftMenu);
Borderpane1.setCenter(tableview);
// Setting scene 1 using BorderPane1. Both scenes have identical dimensions.
scene1 = new Scene(Borderpane1, 700, 500);
// ------------------- SCENE2 (insert Stamkund) --------------------
// HBox for scene 2 created and a Label for it.
HBox scene2topMenu = new HBox();
Label labelScene2 = new Label();
labelScene2.setText("Lägg till stamkund");
labelScene2.setFont(Font.font("Verdana", 20));
// Left menu VBox created.
VBox scene2leftMenu = new VBox(15);
// Scene 2 Main manu and Quit Button created
Button s2b1 = new Button("Huvudmeny");
s2b1.setOnAction(e -> window.setScene(scene1));
Button s2q1 = new Button("Avsluta");
s2q1.setOnAction(e -> closeProgram());
// GridPane for scene 2 created with spacing
GridPane s2grid = new GridPane();
s2grid.setPadding(new Insets(10, 10, 10, 10));
s2grid.setVgap(15);
s2grid.setHgap(10);
// Label displaying required input fields
Label oblLabel = new Label("* = Obligatoriskt fält");
GridPane.setConstraints(oblLabel, 0, 0);
// Label for prnParam
Label pnrLabel = new Label("*Personnummer:");
GridPane.setConstraints(pnrLabel, 0, 1);
// pnrParam is forced by regular expression to "6 digits"-"dash"-"4 digits"
FormattedTextField pnrParam = new FormattedTextField("^\\d{6}-\\d{4}$");
pnrParam.setPromptText("XXXXXX-XXXX");
GridPane.setConstraints(pnrParam, 1, 1);
// Label for fnameParam
Label fnameLabel = new Label("*Förnamn:");
GridPane.setConstraints(fnameLabel, 0, 2);
// First name TextField
TextField fnameParam = new TextField();
fnameParam.setPromptText("t.ex. Arne");
GridPane.setConstraints(fnameParam, 1, 2);
// Label for snameParam
Label snameLabel = new Label("*Efternamn:");
GridPane.setConstraints(snameLabel, 0, 3);
// Surname TextField
TextField snameParam = new TextField();
snameParam.setPromptText("t.ex. Andersson");
GridPane.setConstraints(snameParam, 1, 3);
// Label for addrParam
Label addrLabel = new Label("*Adress:");
GridPane.setConstraints(addrLabel, 0, 4);
// Address TextField
TextField addrParam = new TextField();
addrParam.setPromptText("t.ex. Storgatan 1");
GridPane.setConstraints(addrParam, 1, 4);
// Label for mailParam
Label mailLabel = new Label("E-post:");
GridPane.setConstraints(mailLabel, 0, 5);
// Mail TextField
TextField mailParam = new TextField();
mailParam.setPromptText("*****@*****.**");
GridPane.setConstraints(mailParam, 1, 5);
// Label for cellParam
Label cellLabel = new Label("Mobilnummer:");
GridPane.setConstraints(cellLabel, 0, 6);
// cellParam is forced by regular expression to "3 digits"-"dash"-"7 digits"
FormattedTextField cellParam = new FormattedTextField("^\\d{3}-\\d{7}$");
cellParam.setPromptText("XXX-XXXXXXX");
GridPane.setConstraints(cellParam, 1, 6);
// This Label displays user information such as errors and confirmations.
Label executeLabel = new Label();
GridPane.setConstraints(executeLabel, 1, 8);
// Adding Button "Registrera" with a lot of functionality
Button s2b2 = new Button("Registrera");
GridPane.setConstraints(s2b2, 1, 7);
s2b2.setOnAction(
new EventHandler<ActionEvent>() {
@Override
public void handle(ActionEvent event) {
// First if-statement checks for data in required fields.
// Required: pnrParam, fnameParam, lnameParam and addrParam.
if ((pnrParam.getText() != null && !pnrParam.getText().isEmpty())
&& (fnameParam.getText() != null && !fnameParam.getText().isEmpty())
&& (snameParam.getText() != null && !snameParam.getText().isEmpty())
&& (addrParam.getText() != null && !addrParam.getText().isEmpty())) {
// Second if-statement calls checkPnr() to see if pnrParam (Personnummer)
// is unique in database. If unique, checkPnr() returns False.
// If !checkPnr = True, all data is valid and we run insertStamkund
if (!checkPnr(pnrParam.getText())) {
// Calls insertStamkund() with data from all TextFields.
// Saves card number to integer cardParam.
int cardParam =
insertStamkund(
pnrParam.getText(),
fnameParam.getText(),
snameParam.getText(),
addrParam.getText(),
mailParam.getText(),
cellParam.getText());
// Converts cardParam value to String c.
// Prints a welcoming and customer card number.
String c = String.valueOf(cardParam);
executeLabel.setText(
"Välkommen som stamkund hos Icooköp!\n" + "Ditt kortnummer är: " + c);
// Clear TextFields
pnrParam.clear();
fnameParam.clear();
snameParam.clear();
addrParam.clear();
mailParam.clear();
cellParam.clear();
}
// If !checkPnr = False, pnrParam is already in database and user is notified.
else {
executeLabel.setText(
"Personnumret finns redan registrerat!\n" + "Välj ett annat tack.");
}
}
// If any required fields are empty, user is notified.
else {
executeLabel.setText("Fyll i alla obligatoriska fält!");
}
}
});
// Button for clearing data in all TextFields and executeLabel
Button s2b3 = new Button("Rensa fält");
GridPane.setConstraints(s2b3, 0, 7);
s2b3.setOnAction(
new EventHandler<ActionEvent>() {
@Override
public void handle(ActionEvent event) {
pnrParam.clear();
fnameParam.clear();
snameParam.clear();
addrParam.clear();
mailParam.clear();
cellParam.clear();
executeLabel.setText(null);
}
});
// Adding buttons to left and top menus
scene2leftMenu.getChildren().addAll(s2b1, s2q1);
scene2topMenu.getChildren().add(labelScene2);
// Adding Labels and TextFields to scene 2 center grid
s2grid
.getChildren()
.addAll(
oblLabel,
pnrLabel,
pnrParam,
fnameLabel,
fnameParam,
snameLabel,
snameParam,
addrLabel,
addrParam,
mailLabel,
mailParam,
cellLabel,
cellParam,
s2b2,
s2b3,
executeLabel);
// Creating BorderPane object and aligning left, top and center content
BorderPane Borderpane2 = new BorderPane();
Borderpane2.setLeft(scene2leftMenu);
Borderpane2.setTop(scene2topMenu);
Borderpane2.setCenter(s2grid);
// Setting scene 2 using BorderPane2. Both scenes have identical dimensions.
scene2 = new Scene(Borderpane2, 700, 500);
// Setting primary scene and display window
window.setScene(scene1);
window.show();
}
/**
* Handles when aides cover each other. They must tell
* us who they're covering so that that poor person
* doesn't get a missed shift. This of course means i
* have to work on MyHours some more... If they select
* a valid userid to cover for makes the appropriate
* entry in AIDELOG.
*
* @param An SaoWorker who is covering someone else
*/
public void WhoRUCovering(final SaoWorker w)
{
int i = 0;
int h = bd.getHours();
int m = bd.getMinutes();
if (((m >= 20) && (m < 30)) || ((m >= 50) && (m < 60)))
{
if (m < 30) { m = m + 10; }
else { m = m + 10 - 60; h = h + 1; }
}
int dopp = bd.getDoPP();
if (dopp > 7) { dopp = dopp - 7; }
String slotid = bd.getSlot(h, m, dopp);
String q = "select * from AIDESCHED where " + slotid + "=1";
final String[] userids = {"", "", "", "", "", "", "", "", "", ""};
final BatSQL bSQL = new BatSQL();
ResultSet rs = bSQL.query(q);
try
{
boolean more = rs.next();
if (more) //because there might be only one person for this slot
{
while (more)
{
userids[i] = rs.getString(1);
i++;
more = rs.next();
}
} //end of if more
} //end of try
catch (SQLException ex)
{
System.out.println("!*******SQLException caught*******!");
System.out.println("WhoRUCovering");
while (ex != null)
{
System.out.println ("SQLState: " + ex.getSQLState ());
System.out.println ("Message: " + ex.getMessage ());
System.out.println ("Vendor: " + ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
System.exit(0);
} //end catching SQLExceptions
catch (java.lang.Exception ex)
{
System.out.println("!*******Exception caught*******!");
System.out.println("WhoRUCovering");
System.exit(0);
} //end catching other Exceptions
final Frame coverF = new Frame("Covering?");
final Panel p = new Panel();
final Panel btnP = new Panel();
final List coverL = new List();
Button ok = new Button("Cover");
Button nok = new Button("Cancel");
final int i2 = i;
ok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e)
{
String id = coverL.getSelectedItem();
BatSQL bS = new BatSQL();
String a = "insert into aidelog values ('C', \"" + id + "\", \"" + bd.getDate() + "\", " + bd.getStringHours() + bd.getStringMinutes() + ", 'I')";
bS.update(a);
a = "update AIDEDIN set COVERING='" + id + "' where USERID='" + w.getUserID() + "'";
bS.update(a);
bS.disconnect();
coverF.dispose();
}
});
nok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e)
{
coverF.dispose();
}
});
btnP.setLayout(new FlowLayout());
btnP.add(ok);
btnP.add(nok);
p.setLayout(new BorderLayout());
p.add(new Label("Who are you covering for?"), BorderLayout.NORTH);
int j;
for (j = 0; j <= i; j++)
{
coverL.add(userids[j]);
}
p.add(coverL, BorderLayout.CENTER);
p.add(btnP, BorderLayout.SOUTH);
coverL.select(0);
coverF.setLayout(new FlowLayout());
coverF.add(p);
coverF.pack();
coverF.setLocation(200, 200);
coverF.show();
} //end of WhoRUCovering