API tools faq
paste
Advertisement
shamiul93

Untitled

shamiul93
Jan 15th, 2018
223
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.24 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package tele.communication.system.application;
  7.  
  8. import java.sql.CallableStatement;
  9. import java.sql.Connection;
  10. import java.sql.PreparedStatement;
  11. import java.sql.ResultSet;
  12. import java.sql.SQLException;
  13. import java.text.ParseException;
  14. import java.text.SimpleDateFormat;
  15. import java.util.Date;
  16. import java.util.logging.Level;
  17. import java.util.logging.Logger;
  18. import javafx.application.Application;
  19. import javafx.beans.value.ChangeListener;
  20. import javafx.beans.value.ObservableValue;
  21. import javafx.collections.FXCollections;
  22. import javafx.collections.ObservableList;
  23. import javafx.event.ActionEvent;
  24. import javafx.scene.Group;
  25. import javafx.scene.Scene;
  26. import javafx.scene.control.Button;
  27. import javafx.scene.control.PasswordField;
  28. import javafx.scene.control.RadioButton;
  29. import javafx.scene.control.TableColumn;
  30. import javafx.scene.control.TableView;
  31. import javafx.scene.control.TextField;
  32. import javafx.scene.control.Toggle;
  33. import javafx.scene.control.ToggleGroup;
  34. import javafx.scene.control.cell.PropertyValueFactory;
  35. import javafx.scene.image.Image;
  36. import javafx.scene.image.ImageView;
  37. import javafx.scene.input.KeyEvent;
  38. import javafx.scene.input.MouseEvent;
  39. import javafx.scene.layout.HBox;
  40. import javafx.scene.layout.VBox;
  41. import javafx.scene.paint.Color;
  42. import javafx.scene.shape.Rectangle;
  43. import javafx.scene.text.Font;
  44. import javafx.scene.text.Text;
  45. import javafx.stage.Modality;
  46. import javafx.stage.Stage;
  47. import javafx.util.Duration;
  48. import org.controlsfx.control.Notifications;
  49.  
  50. /**
  51. *
  52. * @author HEISENBERG
  53. */
  54. public class User_UI extends Application {
  55.  
  56. public static Stage stage;
  57. public static Stage stage2;
  58. public static Group root;
  59. public static Scene scene;
  60. public static String name;// user name
  61. public static String passcode;//nid
  62. public static String phoneno;//sim no
  63. public static String pass;
  64. public static String givenpass;
  65. String SIM_Type;
  66. String SIMtypeID;
  67.  
  68. @Override
  69. public void start(Stage primaryStage) throws Exception {
  70. stage = primaryStage;
  71. stage.initModality(Modality.APPLICATION_MODAL);
  72. LoginScene();
  73. }
  74.  
  75. public static void BackSceneOnly() {
  76. root = new Group();
  77. //Rectangle2D screenBounds = Screen.getPrimary().getVisualBounds();
  78. scene = new Scene(root, 1800, 900);
  79. scene.setFill(Color.rgb(255, 255, 255));//rgb(red, green, blue)
  80. ImageView back = new ImageView("file:userback.jpg");
  81. root.getChildren().add(back);
  82. }
  83.  
  84. public void go() throws Exception {
  85. stage2 = new Stage();
  86. start(stage2);
  87. }
  88.  
  89. public static void StageShow() {
  90. stage.setTitle("USER UI");
  91. stage.setScene(scene);
  92. Image logo = new Image("file:comlogo.png");
  93. stage.getIcons().add(logo);
  94. stage.show();
  95. }
  96.  
  97. private void SignUPScene() {
  98.  
  99. int posX = 300, posY = 250;
  100. int textFieldPosX = posX + 320, textFieldPosY = posY - 20;
  101. int buttonPosX = textFieldPosX + 300, buttonPosY = 250, fonts = 20;
  102.  
  103. BackSceneOnly();
  104. name = new String();
  105. passcode = new String();
  106.  
  107. Text Name = new Text("USER NAME : ");
  108. Name.setX(posX);
  109. Name.setY(posY);
  110. Name.setFill(Color.rgb(0, 0, 0));
  111. Name.setFont(Font.font(fonts));
  112.  
  113. Text nid = new Text("NID NO : ");
  114. nid.setX(posX);
  115. nid.setY(posY + 50);
  116. nid.setFill(Color.rgb(0, 0, 0));
  117. nid.setFont(Font.font(fonts));
  118.  
  119. Text db = new Text("DATE OF BIRTH (MMM DD, YYYY) : ");
  120. db.setX(posX);
  121. db.setY(posY + 100);
  122. db.setFill(Color.rgb(0, 0, 0));
  123. db.setFont(Font.font(fonts));
  124.  
  125. Text fn = new Text("FATHER'S NAME : ");
  126. fn.setX(posX);
  127. fn.setY(posY + 150);
  128. fn.setFill(Color.rgb(0, 0, 0));
  129. fn.setFont(Font.font(fonts));
  130.  
  131. Text mn = new Text("MOTHER'S NAME : ");
  132. mn.setX(posX);
  133. mn.setY(posY + 200);
  134. mn.setFill(Color.rgb(0, 0, 0));
  135. mn.setFont(Font.font(fonts));
  136.  
  137. Text add = new Text("ADRESS : ");
  138. add.setX(posX);
  139. add.setY(posY + 250);
  140. add.setFill(Color.rgb(0, 0, 0));
  141. add.setFont(Font.font(fonts));
  142.  
  143. Text ct = new Text("CITY : ");
  144. ct.setX(posX);
  145. ct.setY(posY + 300);
  146. ct.setFill(Color.rgb(0, 0, 0));
  147. ct.setFont(Font.font(fonts));
  148.  
  149. Text mail = new Text("E-MAIL ID : ");
  150. mail.setX(posX);
  151. mail.setY(posY + 350);
  152. mail.setFill(Color.rgb(0, 0, 0));
  153. mail.setFont(Font.font(fonts));
  154.  
  155. Text tn = new Text("SIM TYPE : ");
  156. tn.setX(posX);
  157. tn.setY(posY + 400);
  158. tn.setFill(Color.rgb(0, 0, 0));
  159. tn.setFont(Font.font(fonts));
  160.  
  161. TextField userName = new TextField();
  162. userName.setLayoutX(textFieldPosX);
  163. userName.setLayoutY(textFieldPosY);
  164. root.getChildren().add(userName);
  165.  
  166. TextField NID = new TextField();
  167. NID.setLayoutX(textFieldPosX);
  168. NID.setLayoutY(textFieldPosY + 50);
  169. root.getChildren().add(NID);
  170.  
  171. TextField bDay = new TextField();
  172. bDay.setLayoutX(textFieldPosX);
  173. bDay.setLayoutY(textFieldPosY + 100);
  174. root.getChildren().add(bDay);
  175.  
  176. TextField Father = new TextField();
  177. Father.setLayoutX(textFieldPosX);
  178. Father.setLayoutY(textFieldPosY + 150);
  179. root.getChildren().add(Father);
  180.  
  181. TextField Mother = new TextField();
  182. Mother.setLayoutX(textFieldPosX);
  183. Mother.setLayoutY(textFieldPosY + 200);
  184. root.getChildren().add(Mother);
  185.  
  186. TextField Address = new TextField();
  187. Address.setLayoutX(textFieldPosX);
  188. Address.setLayoutY(textFieldPosY + 250);
  189. root.getChildren().add(Address);
  190.  
  191. TextField City = new TextField();
  192. City.setLayoutX(textFieldPosX);
  193. City.setLayoutY(textFieldPosY + 300);
  194. root.getChildren().add(City);
  195.  
  196. TextField Mailf = new TextField();
  197. Mailf.setLayoutX(textFieldPosX);
  198. Mailf.setLayoutY(textFieldPosY + 350);
  199. root.getChildren().add(Mailf);
  200.  
  201. final ToggleGroup group = new ToggleGroup();
  202.  
  203. RadioButton rb1 = new RadioButton("Pre-Paid SIM");
  204. rb1.setToggleGroup(group);
  205. rb1.setUserData("1");
  206. rb1.setLayoutX(textFieldPosX);
  207. rb1.setLayoutY(textFieldPosY + 400);
  208.  
  209. RadioButton rb2 = new RadioButton("Post-Paid SIM");
  210. rb2.setToggleGroup(group);
  211. rb2.setUserData("2");
  212. rb2.setLayoutX(textFieldPosX);
  213. rb2.setLayoutY(textFieldPosY + 450);
  214.  
  215. group.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
  216. public void changed(ObservableValue<? extends Toggle> ov,
  217. Toggle old_toggle, Toggle new_toggle) {
  218. if (group.getSelectedToggle() != null) {
  219. SIMtypeID = group.getSelectedToggle().getUserData().toString();
  220. System.out.println(SIMtypeID);
  221. }
  222. }
  223. });
  224.  
  225. root.getChildren().add(rb1);
  226. root.getChildren().add(rb2);
  227.  
  228. Button signUpBtn = new Button("Apply For New SIM");
  229. signUpBtn.setLayoutX(buttonPosX);
  230. signUpBtn.setLayoutY(buttonPosY);
  231. root.getChildren().add(signUpBtn);
  232.  
  233. Button backToHomeBtn = new Button("Back");
  234. backToHomeBtn.setLayoutX(buttonPosX);
  235. backToHomeBtn.setLayoutY(buttonPosY + 100);
  236. root.getChildren().add(backToHomeBtn);
  237.  
  238. backToHomeBtn.setOnAction(e -> LoginScene());
  239.  
  240. signUpBtn.setOnAction((ActionEvent e) -> {
  241. String s1 = userName.getText();
  242. String s2 = NID.getText();
  243. String s3 = bDay.getText();
  244. String s4 = Father.getText();
  245. String s5 = Mother.getText();
  246. String s6 = Address.getText();
  247. String s7 = City.getText();
  248. String s8 = Mailf.getText();
  249.  
  250. boolean success = true;
  251.  
  252. try {
  253.  
  254. Connection con;
  255. con = new DataBase("TELECOM", "hr").getConnection();
  256. String sql = "INSERT INTO PENDING_SIM_REQ (USER_NAME,NID_NO,DATE_OF_BIRTH,NAME_OF_FATHER,NAME_OF_MOTHER,EMAIL,STREET_ADDRESS,CITY, IS_EMPLOYEE, SIM_TYPE_ID) VALUES (?,?,?,?,?,?,?,?,?,?)";
  257. PreparedStatement pst = con.prepareStatement(sql);
  258. pst.setString(1, s1);
  259. pst.setString(2, s2);
  260. pst.setString(3, s3);
  261. pst.setString(4, s4);
  262. pst.setString(5, s5);
  263. pst.setString(6, s8);
  264. pst.setString(7, s6);
  265. pst.setString(8, s7);
  266. pst.setString(9, "NO");
  267. pst.setString(10, SIMtypeID);
  268.  
  269. pst.executeQuery();
  270.  
  271. SuccessMsg("Success", "Your Application Has Been Successfully Received.\nYou Will Receive A Confirmation Email.\nThank You.");
  272.  
  273. pst.close();
  274. con.close();
  275.  
  276. } catch (Exception ex) {
  277. System.out.println("Data insert doesn't work");
  278. }
  279.  
  280. });
  281.  
  282. root.getChildren().add(Name);
  283. root.getChildren().add(nid);
  284. root.getChildren().add(db);
  285. root.getChildren().add(fn);
  286. root.getChildren().add(mn);
  287. root.getChildren().add(add);
  288. root.getChildren().add(ct);
  289. root.getChildren().add(tn);
  290. root.getChildren().add(mail);
  291.  
  292. StageShow();
  293. }
  294.  
  295. private void LoginScene() {
  296. int posX = 350, posY = 300;
  297. int textFieldPosX = posX + 455, textFieldPosY = posY - 20;
  298. BackSceneOnly();
  299. ImageView toppart = new ImageView("file:tbdgreen.png");
  300. ImageView tbdlogin = new ImageView("file:userlogin.jpg");
  301. name = new String();
  302. passcode = new String();
  303. TextField username = new TextField();
  304. username.setLayoutX(textFieldPosX);
  305. username.setLayoutY(textFieldPosY);
  306. username.setScaleX(2.65);
  307. username.setScaleY(2);
  308. PasswordField password = new PasswordField();
  309. password.setLayoutX(textFieldPosX);
  310. password.setLayoutY(textFieldPosY + 100);
  311. password.setScaleX(2.65);
  312. password.setScaleY(2);
  313. Rectangle loginBox = new Rectangle(480, 45);
  314. loginBox.setFill(Color.rgb(32, 155, 146));
  315. loginBox.setX(660);
  316. loginBox.setY(482);
  317. Rectangle applyBox = new Rectangle(680, 75);
  318. applyBox.setX(560);
  319. applyBox.setY(582);
  320. applyBox.setFill(Color.rgb(32, 155, 146));
  321. Text applytext = new Text(750, 635, "APPLY FOR A SIM");
  322. applytext.setFont(Font.font(40));
  323. applytext.setFill(Color.WHITE);
  324. applyBox.addEventHandler(MouseEvent.MOUSE_ENTERED, e -> {
  325. applyBox.setFill(Color.rgb(17, 119, 112));
  326. });
  327. applytext.addEventHandler(MouseEvent.MOUSE_ENTERED, e -> {
  328. applyBox.setFill(Color.rgb(17, 119, 112));
  329. });
  330. applytext.addEventHandler(MouseEvent.MOUSE_EXITED, e -> {
  331. applyBox.setFill(Color.rgb(32, 155, 146));
  332. });
  333. applyBox.addEventHandler(MouseEvent.MOUSE_EXITED, e -> {
  334. applyBox.setFill(Color.rgb(32, 155, 146));
  335. });
  336. applyBox.addEventHandler(MouseEvent.MOUSE_CLICKED, e -> {
  337. SignUPScene();
  338. });
  339. Text login = new Text(850, 515, "LOG IN");
  340. login.setFont(Font.font(30));
  341. login.setFill(Color.WHITE);
  342. loginBox.addEventHandler(MouseEvent.MOUSE_ENTERED, e -> {
  343. loginBox.setFill(Color.rgb(17, 119, 112));
  344. });
  345. login.addEventHandler(MouseEvent.MOUSE_ENTERED, e -> {
  346. loginBox.setFill(Color.rgb(17, 119, 112));
  347. });
  348. loginBox.addEventHandler(MouseEvent.MOUSE_EXITED, e -> {
  349. loginBox.setFill(Color.rgb(32, 155, 146));
  350. });
  351. loginBox.addEventHandler(MouseEvent.MOUSE_CLICKED, e -> {
  352. continueLogIn(username, password);
  353. });
  354. scene.setOnKeyPressed((KeyEvent event) -> {
  355. switch (event.getCode()) {
  356. case ENTER:
  357. continueLogIn(username, password);
  358. break;
  359. }
  360. });
  361. root.getChildren().add(tbdlogin);
  362. root.getChildren().add(toppart);
  363. root.getChildren().add(loginBox);
  364. root.getChildren().add(username);
  365. root.getChildren().add(password);
  366. root.getChildren().add(login);
  367. root.getChildren().add(applyBox);
  368. root.getChildren().add(applytext);
  369. StageShow();
  370. }
  371.  
  372. public void LogIn(String User_Name, String NID_No) {
  373. BackSceneOnly();
  374.  
  375. int posX = 300, posY = 170;
  376. int textFieldPosX = posX + 200, textFieldPosY = posY - 15;
  377. int buttonPosX = textFieldPosX + 300, buttonPosY = 50;
  378.  
  379. Profile(User_Name, NID_No); // HomePage of User = User Profile
  380.  
  381. Button profileBtn = new Button("Profile");
  382. SetThisButton(profileBtn, buttonPosX, buttonPosY + 50);
  383. profileBtn.setOnAction(e -> Profile(User_Name, NID_No));
  384.  
  385. Button dialListBtn = new Button("Dialled Call List");
  386. SetThisButton(dialListBtn, buttonPosX, buttonPosY + 100);
  387.  
  388. dialListBtn.setOnAction(e -> {
  389. ShowDialledCallList(NID_No);
  390. });
  391.  
  392. Button receiveListBtn = new Button("Received Call List");
  393. SetThisButton(receiveListBtn, buttonPosX, buttonPosY + 150);
  394.  
  395. receiveListBtn.setOnAction(e -> {
  396. ShowReceivedCallList(NID_No);
  397. });
  398.  
  399. Button SMSListBtn = new Button("SMS List");
  400. SetThisButton(SMSListBtn, buttonPosX, buttonPosY + 200);
  401.  
  402. SMSListBtn.setOnAction(e -> {
  403. ShowSMSList(NID_No);
  404. });
  405.  
  406. Button netDataBtn = new Button("Net Usage");
  407. SetThisButton(netDataBtn, buttonPosX, buttonPosY + 250);
  408.  
  409. Button makeCallBtn = new Button("Make A Call");
  410. SetThisButton(makeCallBtn, buttonPosX, buttonPosY + 300);
  411.  
  412. makeCallBtn.setOnAction(e -> {
  413. makeACall();
  414. });
  415.  
  416. Button sendSMSBtn = new Button("Send An SMS");
  417. SetThisButton(sendSMSBtn, buttonPosX, buttonPosY + 350);
  418.  
  419. sendSMSBtn.setOnAction(e -> {
  420. sendSMS();
  421. });
  422.  
  423. Button useNetBtn = new Button("Use Internet");
  424. SetThisButton(useNetBtn, buttonPosX, buttonPosY + 400);
  425.  
  426. useNetBtn.setOnAction(e -> {
  427. useNet();
  428. });
  429.  
  430. Button BalanceBtn = new Button("Check Balance");
  431. SetThisButton(BalanceBtn, buttonPosX, buttonPosY + 450);
  432.  
  433. BalanceBtn.setOnAction(e->checkBalance());
  434.  
  435. Button rechargeBtn = new Button("Recharge");
  436. rechargeBtn.setLayoutX(buttonPosX);
  437. rechargeBtn.setLayoutY(buttonPosY + 500);
  438. if (SIM_Type.equals("1")) {
  439. root.getChildren().add(rechargeBtn);
  440. }
  441.  
  442. rechargeBtn.setOnAction(e -> recharge());
  443.  
  444. Button backToHomeBtn = new Button("Log Out");
  445. SetThisButton(backToHomeBtn, buttonPosX + 50, buttonPosY + 550);
  446. backToHomeBtn.setOnAction(e -> LogOut());
  447.  
  448. StageShow();
  449. }
  450.  
  451. double balance;
  452.  
  453. public void checkBalance() {
  454. BackSceneOnly();
  455.  
  456. try {
  457. String sql = "SELECT BALANCE FROM PREPAID_SIM "
  458. + "WHERE SIM_NO = ?";
  459.  
  460. Connection con = new DataBase("TELECOM", "hr").getConnection();
  461.  
  462. PreparedStatement pst = con.prepareStatement(sql);
  463.  
  464. pst.setString(1, phoneno);
  465.  
  466. ResultSet rs = pst.executeQuery();
  467.  
  468. System.out.println("muri kha");
  469. rs.next();
  470.  
  471. balance = Double.parseDouble(rs.getString(1));
  472.  
  473. pst.close();
  474. con.close();
  475. SuccessMsg("Success", "Your Balance Was retrieved");
  476. } catch (Exception e) {
  477.  
  478. System.out.println(balance);
  479. InvalidLogInMsg("failed", "Can't check Balance");
  480. }
  481.  
  482. double posX = 300, posY = 200;
  483.  
  484. Text strtTime = new Text("USER NO : " + phoneno);
  485. strtTime.setX(posX);
  486. strtTime.setY(posY);
  487. strtTime.setFill(Color.rgb(0, 0, 0));
  488.  
  489. Text duration = new Text("Balance : " + balance + " Taka");
  490. duration.setX(posX);
  491. duration.setY(posY + 100);
  492. duration.setFill(Color.rgb(0, 0, 0));
  493.  
  494. goToProfileButton(300 + 200, 600);
  495.  
  496. StageShow();
  497.  
  498.  
  499. // VBox vb = new VBox();
  500. root.getChildren().addAll(strtTime);
  501. root.getChildren().addAll(duration);
  502.  
  503. // Scene sc = new Scene(vb);
  504. // Stage window = new Stage();
  505. // window.setTitle("Balance");
  506. // window.setScene(sc);
  507. // window.show();
  508.  
  509. StageShow();
  510. }
  511.  
  512. int rechargeCost;
  513.  
  514. public void recharge() {
  515. BackSceneOnly();
  516.  
  517. int textFieldPosX = 600, textFieldPosY = 350;
  518. int buttonPosX = textFieldPosX - 55, buttonPosY = textFieldPosY + 50;
  519.  
  520. TextField cardNo = new TextField();
  521. setThisTextField(cardNo, textFieldPosX, textFieldPosY);
  522.  
  523. Button applyButton = new Button("Recharge");
  524. SetThisButton(applyButton, buttonPosX, buttonPosY);
  525.  
  526. Button backToHomeBtn = new Button("Back To Profile");
  527. SetThisButton(backToHomeBtn, buttonPosX + 200, buttonPosY);
  528.  
  529. backToHomeBtn.setOnAction(e -> LogIn(name, passcode));
  530.  
  531. applyButton.setOnAction(e -> {
  532. try {
  533.  
  534. String sql = "SELECT COST FROM AVAILABLE_RECHARGE_CARDS \n"
  535. + "WHERE CARD_NUMBER = ?";
  536.  
  537. Connection con = new DataBase("TELECOM", "hr").getConnection();
  538.  
  539. PreparedStatement pst = con.prepareStatement(sql);
  540.  
  541. pst.setInt(1, Integer.parseInt(cardNo.getText()));
  542.  
  543. ResultSet rs = pst.executeQuery();
  544.  
  545. rs.next();
  546.  
  547. rechargeCost = Integer.parseInt(rs.getString(1));
  548.  
  549. System.out.println(rechargeCost);
  550.  
  551. pst.close();
  552. con.close();
  553.  
  554. Class.forName("oracle.jdbc.driver.OracleDriver");
  555. Connection con2 = new DataBase("TELECOM", "hr").getConnection();
  556.  
  557. CallableStatement stmt = con2.prepareCall("{call RECHARGE_PROCEDURE(?,?)}");
  558.  
  559. stmt.setString(1, cardNo.getText());
  560. stmt.setString(2, phoneno);
  561.  
  562. stmt.executeUpdate();
  563.  
  564. stmt.close();
  565. con2.close();
  566.  
  567. SuccessMsg("Success", "Your SIM Was Successfully Recharged With Tk. " + rechargeCost);
  568.  
  569. } catch (ClassNotFoundException ex) {
  570. Logger.getLogger(User_UI.class.getName()).log(Level.SEVERE, null, ex);
  571. } catch (SQLException ex) {
  572. Logger.getLogger(User_UI.class.getName()).log(Level.SEVERE, null, ex);
  573. }
  574.  
  575. double posX = 300, posY = 200;
  576. Text strtTime = new Text("USER NO : " + phoneno);
  577. strtTime.setX(posX);
  578. strtTime.setY(posY);
  579. strtTime.setFill(Color.rgb(0, 0, 0));
  580. Text duration = new Text("Amount : " + rechargeCost + " Taka");
  581. duration.setX(posX);
  582. duration.setY(posY + 100);
  583. duration.setFill(Color.rgb(0, 0, 0));
  584. BackSceneOnly();
  585.  
  586. root.getChildren().add(strtTime);
  587. root.getChildren().add(duration);
  588.  
  589. goToProfileButton(buttonPosX + 200, buttonPosY);
  590.  
  591. StageShow();
  592. });
  593. StageShow();
  594. }
  595.  
  596. String startTime, endTime, recno;
  597. String STRT2, END2;
  598.  
  599. public void sendSMS() {
  600. BackSceneOnly();
  601.  
  602. SimpleDateFormat sdfTime = new SimpleDateFormat("YYYY/MM/dd HH:mm:ss");
  603. SimpleDateFormat sdf2 = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
  604.  
  605. int textFieldPosX = 600, textFieldPosY = 350;
  606. int buttonPosX = textFieldPosX - 55, buttonPosY = textFieldPosY + 50;
  607.  
  608. TextField receiverNo = new TextField();
  609. setThisTextField(receiverNo, textFieldPosX, textFieldPosY);
  610.  
  611. Button sendButton = new Button("Send An SMS");
  612. SetThisButton(sendButton, buttonPosX, buttonPosY);
  613.  
  614. Button backToHomeBtn = new Button("Back To Profile");
  615. SetThisButton(backToHomeBtn, buttonPosX + 200, buttonPosY);
  616.  
  617. backToHomeBtn.setOnAction(e -> LogIn(name, passcode));
  618.  
  619. sendButton.setOnAction(e -> {
  620. Date now = new Date();
  621. startTime = sdf2.format(now);
  622.  
  623. try {
  624. Class.forName("oracle.jdbc.driver.OracleDriver");
  625. Connection con2 = new DataBase("TELECOM", "hr").getConnection();
  626.  
  627. CallableStatement stmt = con2.prepareCall("{call SEND_AN_SMS(?,?,?)}");
  628.  
  629. recno = receiverNo.getText();
  630. stmt.setString(1, phoneno);
  631. stmt.setString(2, recno);
  632. stmt.setString(3, startTime);
  633.  
  634. stmt.executeUpdate();
  635.  
  636. stmt.close();
  637. con2.close();
  638.  
  639. SuccessMsg("Success", "The SMS Was Successfully Sent." + passcode);
  640. } catch (SQLException ex2) {
  641. System.out.println("doesn't work");
  642. InvalidLogInMsg("Approve Failed", "Didn't Work");
  643. } catch (ClassNotFoundException ex) {
  644. System.out.println("calling e problem hocche");
  645. }
  646.  
  647. double posX = 300, posY = 200;
  648. Text strtTime = new Text("SENDER NO : " + phoneno);
  649. strtTime.setX(posX);
  650. strtTime.setY(posY);
  651. strtTime.setFill(Color.rgb(0, 0, 0));
  652.  
  653. Text recNotxt = new Text("RECEIVER NO : " + recno);
  654. recNotxt.setX(posX);
  655. recNotxt.setY(posY + 40);
  656. recNotxt.setFill(Color.rgb(0, 0, 0));
  657.  
  658. Text sendTime = new Text("Sending Time : " + startTime);
  659. sendTime.setX(posX);
  660. sendTime.setY(posY + 80);
  661. sendTime.setFill(Color.rgb(0, 0, 0));
  662.  
  663. // Text duration = new Text("COST : " + CallDurationSecond + " second(s)");
  664. // duration.setX(posX);
  665. // duration.setY(posY + 100);
  666. // duration.setFill(Color.rgb(0, 0, 0));
  667. BackSceneOnly();
  668.  
  669. root.getChildren().add(strtTime);
  670. root.getChildren().add(sendTime);
  671. root.getChildren().add(recNotxt);
  672. // root.getChildren().add(cost);
  673.  
  674. goToProfileButton(buttonPosX + 200, buttonPosY);
  675.  
  676. StageShow();
  677. });
  678.  
  679. StageShow();
  680. }
  681.  
  682. public void useNet() {
  683. BackSceneOnly();
  684.  
  685. SimpleDateFormat sdfTime = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
  686.  
  687. int textFieldPosX = 600, textFieldPosY = 350;
  688. int buttonPosX = textFieldPosX - 55, buttonPosY = textFieldPosY + 50;
  689.  
  690. TextField USEkb = new TextField();
  691. setThisTextField(USEkb, textFieldPosX, textFieldPosY);
  692.  
  693. Button startButton = new Button("Use Net");
  694. SetThisButton(startButton, buttonPosX, buttonPosY);
  695.  
  696. Button backToHomeBtn = new Button("Back To Profile");
  697. SetThisButton(backToHomeBtn, buttonPosX + 200, buttonPosY);
  698.  
  699. backToHomeBtn.setOnAction(e -> LogIn(name, passcode));
  700.  
  701. startButton.setOnAction(e -> {
  702. Date now = new Date();
  703. startTime = sdfTime.format(now);
  704.  
  705. root.getChildren().remove(USEkb);
  706. Date now1 = new Date();
  707.  
  708. try {
  709. Class.forName("oracle.jdbc.driver.OracleDriver");
  710. Connection con2 = new DataBase("TELECOM", "hr").getConnection();
  711.  
  712. CallableStatement stmt = con2.prepareCall("{call USE_NET(?,?,?)}");
  713.  
  714. stmt.setString(1, phoneno);
  715. stmt.setString(2, startTime);
  716. stmt.setString(3, USEkb.getText());
  717.  
  718. stmt.executeUpdate();
  719.  
  720. stmt.close();
  721. con2.close();
  722.  
  723. SuccessMsg("Approved", USEkb.getText() + "KB Net Was Used By This Sim" + passcode);
  724. } catch (SQLException ex2) {
  725. System.out.println("doesn't work");
  726. InvalidLogInMsg("Approve Failed", "Didn't Work");
  727. } catch (ClassNotFoundException ex) {
  728. System.out.println("calling e problem hocche");
  729. }
  730.  
  731. double posX = 300, posY = 200;
  732.  
  733. Text userno = new Text("User SIM No: " + phoneno);
  734. userno.setX(posX);
  735. userno.setY(posY);
  736. userno.setFill(Color.rgb(0, 0, 0));
  737.  
  738. Text strtTime = new Text("Session Starting Time : " + startTime);
  739. strtTime.setX(posX);
  740. strtTime.setY(posY + 50);
  741. strtTime.setFill(Color.rgb(0, 0, 0));
  742.  
  743. Text duration = new Text("Net Used : " + USEkb.getText() + " KB");
  744. duration.setX(posX);
  745. duration.setY(posY + 100);
  746. duration.setFill(Color.rgb(0, 0, 0));
  747.  
  748. BackSceneOnly();
  749.  
  750. root.getChildren().add(strtTime);
  751. root.getChildren().add(userno);
  752. root.getChildren().add(duration);
  753.  
  754. goToProfileButton(buttonPosX + 200, buttonPosY);
  755. StageShow();
  756. });
  757.  
  758. StageShow();
  759. }
  760.  
  761. public void makeACall() {
  762. BackSceneOnly();
  763.  
  764. SimpleDateFormat sdfTime = new SimpleDateFormat("YYYY/MM/dd HH:mm:ss");
  765. SimpleDateFormat sdf2 = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
  766.  
  767. int textFieldPosX = 600, textFieldPosY = 350;
  768. int buttonPosX = textFieldPosX - 55, buttonPosY = textFieldPosY + 50;
  769.  
  770. TextField receiverNo = new TextField();
  771. setThisTextField(receiverNo, textFieldPosX, textFieldPosY);
  772.  
  773. Button startButton = new Button("Start Call");
  774. SetThisButton(startButton, buttonPosX, buttonPosY);
  775.  
  776. Button backToHomeBtn = new Button("Back To Profile");
  777. SetThisButton(backToHomeBtn, buttonPosX + 200, buttonPosY);
  778.  
  779. backToHomeBtn.setOnAction(e -> LogIn(name, passcode));
  780.  
  781. startButton.setOnAction(e -> {
  782. Date now = new Date();
  783. startTime = sdfTime.format(now);
  784. STRT2 = sdf2.format(now);
  785.  
  786. root.getChildren().remove(startButton);
  787. root.getChildren().remove(backToHomeBtn);
  788.  
  789. Button endButton = new Button("End Call");
  790. SetThisButton(endButton, buttonPosX, buttonPosY);
  791.  
  792. endButton.setOnAction(e1 -> {
  793. root.getChildren().remove(receiverNo);
  794. Date now1 = new Date();
  795. endTime = sdfTime.format(now1);
  796. END2 = sdf2.format(now1);
  797.  
  798. Date strt = null, end = null;
  799.  
  800. try {
  801. strt = sdfTime.parse(startTime);
  802. end = sdfTime.parse(endTime);
  803. } catch (ParseException exc) {
  804. exc.printStackTrace();
  805. }
  806.  
  807. long diff = end.getTime() - strt.getTime();
  808. double CallDurationSecond = diff / 1000.0;
  809.  
  810. try {
  811. Class.forName("oracle.jdbc.driver.OracleDriver");
  812. Connection con2 = new DataBase("TELECOM", "hr").getConnection();
  813.  
  814. CallableStatement stmt = con2.prepareCall("{call MAKE_A_CALL(?,?,?,?)}");
  815.  
  816. stmt.setString(1, phoneno);
  817. stmt.setString(2, receiverNo.getText());
  818. stmt.setString(3, STRT2);
  819. stmt.setString(4, END2);
  820.  
  821. stmt.executeUpdate();
  822.  
  823. stmt.close();
  824. con2.close();
  825.  
  826. SuccessMsg("Approved", "This SIM Was Issued By Employee No." + passcode);
  827. } catch (SQLException ex2) {
  828. System.out.println("doesn't work");
  829. InvalidLogInMsg("Approve Failed", "Didn't Work");
  830. } catch (ClassNotFoundException ex) {
  831. System.out.println("calling e problem hocche");
  832. }
  833.  
  834. System.out.println("hi:" + STRT2 + " " + END2);
  835.  
  836. double posX = 300, posY = 200;
  837. Text strtTime = new Text("Starting Time : " + startTime);
  838. strtTime.setX(posX);
  839. strtTime.setY(posY);
  840. strtTime.setFill(Color.rgb(0, 0, 0));
  841.  
  842. Text EndingTime = new Text("Ending Time : " + endTime);
  843. EndingTime.setX(posX);
  844. EndingTime.setY(posY + 50);
  845. EndingTime.setFill(Color.rgb(0, 0, 0));
  846.  
  847. Text duration = new Text("Duration (Second) : " + CallDurationSecond + " second(s)");
  848. duration.setX(posX);
  849. duration.setY(posY + 100);
  850. duration.setFill(Color.rgb(0, 0, 0));
  851.  
  852. BackSceneOnly();
  853.  
  854. root.getChildren().add(strtTime);
  855. root.getChildren().add(EndingTime);
  856. root.getChildren().add(duration);
  857.  
  858. goToProfileButton(buttonPosX + 200, buttonPosY);
  859. StageShow();
  860. });
  861.  
  862. StageShow();
  863. });
  864.  
  865. StageShow();
  866. }
  867.  
  868. public void goToProfileButton(int buttonPosX, int buttonPosY) {
  869. Button backToHomeBtn = new Button("Back To Profile");
  870. SetThisButton(backToHomeBtn, buttonPosX, buttonPosY);
  871. backToHomeBtn.setOnAction(e -> LogIn(name, passcode));
  872. }
  873.  
  874. void LogOut() {
  875. LoginScene();
  876. SuccessMsg("Success", "Log Out Successful");
  877. }
  878.  
  879. public void SetThisButton(Button b, double x, double y) {
  880. b.setLayoutX(x);
  881. b.setLayoutY(y);
  882. root.getChildren().add(b);
  883. }
  884.  
  885. public void setThisTextField(TextField tf, double PosX, double PosY) {
  886. tf.setLayoutX(PosX);
  887. tf.setLayoutY(PosY);
  888. root.getChildren().add(tf);
  889. }
  890.  
  891. public void ShowSMSList(String NID_No) {
  892. try {
  893. String sql = "SELECT C.SMS_ID , C.SENDER_NO , C.RECEIVER_NO , C.SENDING_TIME , T.TYPE_NAME\n"
  894. + "FROM USER_DATA U \n"
  895. + "JOIN SIM S\n"
  896. + "ON(U.NID_NO = ? AND U.NID_NO = S.NID_NO)\n"
  897. + "JOIN SMS_DATABASE C\n"
  898. + "ON(S.PHONE_NO = C.SENDER_NO)\n"
  899. + "JOIN SIM_TYPE T \n"
  900. + "ON(S.TYPE_ID = T.TYPE_ID)";
  901.  
  902. Connection con = new DataBase("TELECOM", "hr").getConnection();
  903.  
  904. PreparedStatement pst = con.prepareStatement(sql);
  905.  
  906. pst.setString(1, NID_No);
  907. ResultSet rs = pst.executeQuery();
  908.  
  909. ObservableList<SMSData> dialList = FXCollections.observableArrayList();
  910. while (rs.next()) {
  911. dialList.add(new SMSData(rs.getString(1), rs.getString(2),
  912. rs.getString(3), rs.getString(4), rs.getString(5)));
  913.  
  914. }
  915.  
  916. TableColumn<SMSData, String> CallerNoColm = new TableColumn<>("SMS ID");
  917. CallerNoColm.setMinWidth(200);
  918. CallerNoColm.setCellValueFactory(new PropertyValueFactory<>("SMS_ID"));
  919.  
  920. TableColumn<SMSData, String> ReceiverNoColm = new TableColumn<>("Sender No");
  921. ReceiverNoColm.setMinWidth(200);
  922. ReceiverNoColm.setCellValueFactory(new PropertyValueFactory<>("SenderNo"));
  923.  
  924. TableColumn<SMSData, String> StartingTimeColm = new TableColumn<>("Receiver No");
  925. StartingTimeColm.setMinWidth(200);
  926. StartingTimeColm.setCellValueFactory(new PropertyValueFactory<>("ReceiverNo"));
  927.  
  928. TableColumn<SMSData, String> EndingTimeColm = new TableColumn<>("Sending Time");
  929. EndingTimeColm.setMinWidth(200);
  930. EndingTimeColm.setCellValueFactory(new PropertyValueFactory<>("SendingTime"));
  931.  
  932. TableColumn<SMSData, String> typenameColm = new TableColumn<>("SIM Type");
  933. typenameColm.setMinWidth(200);
  934. typenameColm.setCellValueFactory(new PropertyValueFactory<>("typeName"));
  935.  
  936. TableView<SMSData> DialTable;
  937. DialTable = new TableView<>();
  938. DialTable.getColumns().addAll(CallerNoColm, ReceiverNoColm, StartingTimeColm, EndingTimeColm, typenameColm);
  939.  
  940. DialTable.setItems(dialList);
  941.  
  942. VBox vb = new VBox();
  943. vb.getChildren().addAll(DialTable);
  944.  
  945. Scene sc = new Scene(vb);
  946. Stage window = new Stage();
  947. window.setTitle("SMS List");
  948. window.setScene(sc);
  949. window.show();
  950.  
  951. pst.close();
  952. con.close();
  953.  
  954. } catch (Exception ex) {
  955. System.out.println("SMS list show error!!!");
  956. }
  957. }
  958.  
  959. public void ShowDialledCallList(String NID_No) {
  960. try {
  961. String sql = "SELECT C.CALLER_NO , C.RECEIVER_NO, C.STARTING_TIME , "
  962. + "C.ENDING_TIME , TO_CHAR(C.ENDING_TIME-C.STARTING_TIME),"
  963. + "T.TYPE_NAME FROM USER_DATA U "
  964. + "JOIN SIM S ON(U.NID_NO = ? AND "
  965. + "U.NID_NO = S.NID_NO) JOIN CALL_DATABASE C "
  966. + "ON(S.PHONE_NO = C.CALLER_NO) "
  967. + "JOIN SIM_TYPE T ON(S.TYPE_ID = T.TYPE_ID)";
  968.  
  969. Connection con = new DataBase("TELECOM", "hr").getConnection();
  970.  
  971. PreparedStatement pst = con.prepareStatement(sql);
  972.  
  973. pst.setString(1, NID_No);
  974. ResultSet rs = pst.executeQuery();
  975.  
  976. ObservableList<DialledListData> dialList = FXCollections.observableArrayList();
  977. while (rs.next()) {
  978. System.out.println(rs.getString(3) + " " + rs.getString(4) + " " + rs.getString(5) + " " + rs.getString(6));
  979.  
  980. dialList.add(new DialledListData(rs.getString(1), rs.getString(2),
  981. rs.getString(3), rs.getString(4), rs.getString(5),
  982. rs.getString(6)));
  983.  
  984. }
  985.  
  986. TableColumn<DialledListData, String> CallerNoColm = new TableColumn<>("Caller SIM No");
  987. CallerNoColm.setMinWidth(200);
  988. CallerNoColm.setCellValueFactory(new PropertyValueFactory<>("callerNo"));
  989.  
  990. TableColumn<DialledListData, String> ReceiverNoColm = new TableColumn<>("Receiver SIM No");
  991. ReceiverNoColm.setMinWidth(200);
  992. ReceiverNoColm.setCellValueFactory(new PropertyValueFactory<>("receiverNo"));
  993.  
  994. TableColumn<DialledListData, String> StartingTimeColm = new TableColumn<>("Starting Time");
  995. StartingTimeColm.setMinWidth(200);
  996. StartingTimeColm.setCellValueFactory(new PropertyValueFactory<>("startingTime"));
  997.  
  998. TableColumn<DialledListData, String> EndingTimeColm = new TableColumn<>("Ending Time");
  999. EndingTimeColm.setMinWidth(200);
  1000. EndingTimeColm.setCellValueFactory(new PropertyValueFactory<>("endingTime"));
  1001.  
  1002. TableColumn<DialledListData, String> DurationColm = new TableColumn<>("Call Duration");
  1003. DurationColm.setMinWidth(200);
  1004. DurationColm.setCellValueFactory(new PropertyValueFactory<>("callDuration"));
  1005.  
  1006. TableColumn<DialledListData, String> typenameColm = new TableColumn<>("SIM Type");
  1007. typenameColm.setMinWidth(200);
  1008. typenameColm.setCellValueFactory(new PropertyValueFactory<>("typeName"));
  1009.  
  1010. TableView<DialledListData> DialTable;
  1011. DialTable = new TableView<>();
  1012. DialTable.getColumns().addAll(CallerNoColm, ReceiverNoColm, StartingTimeColm, EndingTimeColm, DurationColm, typenameColm);
  1013.  
  1014. DialTable.setItems(dialList);
  1015.  
  1016. VBox vb = new VBox();
  1017. vb.getChildren().addAll(DialTable);
  1018.  
  1019. Scene sc = new Scene(vb);
  1020. Stage window = new Stage();
  1021. window.setTitle("Dialled Call List");
  1022. window.setScene(sc);
  1023. window.show();
  1024.  
  1025. pst.close();
  1026. con.close();
  1027.  
  1028. } catch (Exception ex) {
  1029. System.out.println("Diall Call list show error!!!");
  1030. }
  1031. }
  1032.  
  1033. public void ShowReceivedCallList(String NID_No) {
  1034. try {
  1035. String sql = "SELECT C.RECEIVER_NO, C.CALLER_NO , C.STARTING_TIME , "
  1036. + "C.ENDING_TIME , TO_CHAR(C.ENDING_TIME-C.STARTING_TIME),T.TYPE_NAME\n"
  1037. + "FROM USER_DATA U \n"
  1038. + "JOIN SIM S\n"
  1039. + "ON(U.NID_NO = ? AND U.NID_NO = S.NID_NO)\n"
  1040. + "JOIN CALL_DATABASE C\n"
  1041. + "ON(S.PHONE_NO = C.RECEIVER_NO)\n"
  1042. + "JOIN SIM_TYPE T\n"
  1043. + "ON(S.TYPE_ID = T.TYPE_ID)";
  1044.  
  1045. Connection con = new DataBase("TELECOM", "hr").getConnection();
  1046.  
  1047. PreparedStatement pst = con.prepareStatement(sql);
  1048.  
  1049. pst.setString(1, NID_No);
  1050. ResultSet rs = pst.executeQuery();
  1051.  
  1052. ObservableList<ReceivedListData> receiveList = FXCollections.observableArrayList();
  1053. while (rs.next()) {
  1054. // System.out.println(rs.getString(3) + " " + rs.getString(4) + " " + rs.getString(5) + " " + rs.getString(6));
  1055.  
  1056. receiveList.add(new ReceivedListData(rs.getString(1), rs.getString(2),
  1057. rs.getString(3), rs.getString(4), rs.getString(5),
  1058. rs.getString(6)));
  1059.  
  1060. }
  1061.  
  1062. TableColumn<ReceivedListData, String> ReceiverNoColm = new TableColumn<>("Receiver SIM No");
  1063. ReceiverNoColm.setMinWidth(200);
  1064. ReceiverNoColm.setCellValueFactory(new PropertyValueFactory<>("receiverNo"));
  1065.  
  1066. TableColumn<ReceivedListData, String> CallerNoColm = new TableColumn<>("Caller SIM No");
  1067. CallerNoColm.setMinWidth(200);
  1068. CallerNoColm.setCellValueFactory(new PropertyValueFactory<>("callerNo"));
  1069.  
  1070. TableColumn<ReceivedListData, String> StartingTimeColm = new TableColumn<>("Starting Time");
  1071. StartingTimeColm.setMinWidth(200);
  1072. StartingTimeColm.setCellValueFactory(new PropertyValueFactory<>("startingTime"));
  1073.  
  1074. TableColumn<ReceivedListData, String> EndingTimeColm = new TableColumn<>("Ending Time");
  1075. EndingTimeColm.setMinWidth(200);
  1076. EndingTimeColm.setCellValueFactory(new PropertyValueFactory<>("endingTime"));
  1077.  
  1078. TableColumn<ReceivedListData, String> DurationColm = new TableColumn<>("Call Duration");
  1079. DurationColm.setMinWidth(200);
  1080. DurationColm.setCellValueFactory(new PropertyValueFactory<>("callDuration"));
  1081.  
  1082. TableColumn<ReceivedListData, String> typenameColm = new TableColumn<>("SIM Type");
  1083. typenameColm.setMinWidth(200);
  1084. typenameColm.setCellValueFactory(new PropertyValueFactory<>("typeName"));
  1085.  
  1086. TableView<ReceivedListData> receiveTable;
  1087. receiveTable = new TableView<>();
  1088. receiveTable.getColumns().addAll(ReceiverNoColm, CallerNoColm, StartingTimeColm, EndingTimeColm, DurationColm, typenameColm);
  1089.  
  1090. receiveTable.setItems(receiveList);
  1091.  
  1092. VBox vb = new VBox();
  1093.  
  1094. vb.getChildren().addAll(receiveTable);
  1095.  
  1096. Scene sc = new Scene(vb);
  1097. Stage window = new Stage();
  1098. window.setTitle("Received Call List");
  1099. window.setScene(sc);
  1100. window.show();
  1101.  
  1102. pst.close();
  1103. con.close();
  1104.  
  1105. } catch (Exception ex) {
  1106. System.out.println("Received Call list show error!!!");
  1107. }
  1108. }
  1109.  
  1110. public void Profile(String User_Name, String NID_No) {
  1111. try {
  1112. String sql = "SELECT * FROM USER_DATA WHERE USER_NAME = ? AND NID_NO = ?";
  1113.  
  1114. int posX = 300, posY = 170;
  1115. int textFieldPosX = posX + 200, textFieldPosY = posY - 15;
  1116. int buttonPosX = textFieldPosX + 300, buttonPosY = 50;
  1117.  
  1118. Connection con = new DataBase("TELECOM", "hr").getConnection();
  1119. PreparedStatement pst = con.prepareStatement(sql);
  1120. pst.setString(1, User_Name);
  1121. pst.setString(2, NID_No);
  1122. ResultSet rs = pst.executeQuery();
  1123.  
  1124. // System.out.println("agdfkasbhkc");
  1125. rs.next();
  1126.  
  1127. Text Name = new Text("USER NAME : " + rs.getString(1));
  1128. Name.setX(posX);
  1129. Name.setY(posY);
  1130. Name.setFill(Color.rgb(0, 0, 0));
  1131.  
  1132. Text nid = new Text("NID NO : " + rs.getString(2));
  1133. nid.setX(posX);
  1134. nid.setY(posY + 50);
  1135. nid.setFill(Color.rgb(0, 0, 0));
  1136.  
  1137. Text db = new Text("DATE OF BIRTH (MMM DD, YYYY) : " + rs.getString(3));
  1138.  
  1139. db.setX(posX);
  1140. db.setY(posY + 100);
  1141. db.setFill(Color.rgb(0, 0, 0));
  1142.  
  1143. Text fn = new Text("FATHER'S NAME : " + rs.getString(4));
  1144. fn.setX(posX);
  1145. fn.setY(posY + 150);
  1146. fn.setFill(Color.rgb(0, 0, 0));
  1147.  
  1148. Text mn = new Text("MOTHER'S NAME : " + rs.getString(5));
  1149. mn.setX(posX);
  1150. mn.setY(posY + 200);
  1151. mn.setFill(Color.rgb(0, 0, 0));
  1152.  
  1153. Text add = new Text("ADRESS : " + rs.getString(6));
  1154. add.setX(posX);
  1155. add.setY(posY + 250);
  1156. add.setFill(Color.rgb(0, 0, 0));
  1157.  
  1158. Text ct = new Text("CITY : " + rs.getString(7));
  1159. ct.setX(posX);
  1160. ct.setY(posY + 300);
  1161. ct.setFill(Color.rgb(0, 0, 0));
  1162.  
  1163. Text type = new Text("hi");
  1164.  
  1165. if (rs.getString(8).equals("NO")) {
  1166. type = new Text("User Type: " + "Not Employee");
  1167. } else {
  1168. type = new Text("User Type: " + "Employee");
  1169. }
  1170.  
  1171. type.setX(posX);
  1172. type.setY(posY + 350);
  1173. type.setFill(Color.rgb(0, 0, 0));
  1174.  
  1175. root.getChildren().add(Name);
  1176. root.getChildren().add(nid);
  1177. root.getChildren().add(db);
  1178. root.getChildren().add(fn);
  1179. root.getChildren().add(mn);
  1180. root.getChildren().add(add);
  1181. root.getChildren().add(ct);
  1182. root.getChildren().add(type);
  1183.  
  1184. pst.close();
  1185. con.close();
  1186. } catch (Exception ex) {
  1187. System.out.println("Log In Error!!");
  1188. }
  1189. }
  1190.  
  1191. public static void SuccessMsg(String title, String msg) {
  1192. ImageView img = new ImageView("file:Success.png");
  1193. Notifications not = Notifications.create()
  1194. .title(title)
  1195. .text(msg)
  1196. .graphic(img)
  1197. .hideAfter(Duration.seconds(3));
  1198. not.darkStyle();
  1199. not.show();
  1200. }
  1201.  
  1202. public static void InvalidLogInMsg(String title, String msg) {
  1203. Notifications not = Notifications.create()
  1204. .title(title)
  1205. .text(msg)
  1206. .hideAfter(Duration.seconds(3));
  1207. not.darkStyle();
  1208. not.showError();
  1209. }
  1210.  
  1211. private void continueLogIn(TextField username, PasswordField password) {
  1212. phoneno = username.getText();
  1213. pass = password.getText();
  1214. String sql = "SELECT NID_NO , TYPE_ID FROM SIM WHERE PHONE_NO = ?";
  1215. try {
  1216. Connection con = new DataBase("TELECOM", "hr").getConnection();
  1217. PreparedStatement pst = con.prepareStatement(sql);
  1218. pst.setString(1, phoneno);
  1219. ResultSet rs = pst.executeQuery();
  1220. if (rs.next()) {
  1221. System.out.println("success");
  1222. passcode = rs.getString(1);
  1223. SIM_Type = rs.getString(2);
  1224. //SuccessMsg("Success", "LogIn Successful");
  1225. pst.close();
  1226. con.close();
  1227. //LogIn(name, passcode);
  1228. } else {
  1229. InvalidLogInMsg("Failed", "No Such Phone no.");
  1230. }
  1231. } catch (SQLException ex) {
  1232. System.out.println("doesn,t work");
  1233. }
  1234. String sql2 = "SELECT USER_PASSWORD,USER_NAME FROM USER_DATA WHERE NID_NO = ?";
  1235. try {
  1236. Connection con = new DataBase("TELECOM", "hr").getConnection();
  1237. PreparedStatement pst = con.prepareStatement(sql2);
  1238. pst.setString(1, passcode);
  1239. ResultSet rs = pst.executeQuery();
  1240. if (rs.next()) {
  1241. System.out.println("success");
  1242. givenpass = rs.getString(1);
  1243. name = rs.getString(2);
  1244. pst.close();
  1245. con.close();
  1246. } else {
  1247. InvalidLogInMsg("Failed", "Invalid Log In");
  1248. }
  1249. } catch (SQLException ex) {
  1250. System.out.println("doesn,t work");
  1251. }
  1252. if (pass.equals(givenpass)) {
  1253. LogIn(name, passcode);
  1254. SuccessMsg("Success", "LogIn Successful");
  1255. } else {
  1256. InvalidLogInMsg("Failed", "Invalid Log In");
  1257. }
  1258. }
  1259.  
  1260. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!