controler

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package programkasirgrosiraninc.Storage;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import static programkasirgrosiraninc.Storage.Database.objResult;
import programkasirgrosiraninc.Model.ModelBarang;
import programkasirgrosiraninc.Model.Kasir;
import programkasirgrosiraninc.Model.ModelPickedItem;
import programkasirgrosiraninc.Model.ModelUser;

/**
 *
 * @author King Aldemar I
 */
public class BarangStorage {
    private static List<ModelBarang> ListBarang;
    private static List<ModelPickedItem> ListPickedItem;

    public static List<ModelBarang> getListBarang() {
        return ListBarang;
    }

    public static List<ModelPickedItem> getListPickedItem() {
        return ListPickedItem;
    }

    public static void InitPickedItem()
    {
        ListPickedItem = new ArrayList<>();
    }

    public static void ClearPickedItem()
    {
        ListPickedItem.clear();
    }

    public static void ReloadBarang()
    {
        //Database.ExecuteSQL("select * from user_table order by type");
        GlobalVariables.getLoadingScreen().show();
        ListPickedItem = new ArrayList<>();
        ListBarang = new ArrayList<>();
        try
        {
            objResult = Database.objStatement.executeQuery("select * from barang_tabel");
            while(Database.objResult.next())
            {
                boolean avail;
                avail = !"Y".equals(Database.objResult.getString("Deleted"));
                System.out.println(avail);
                System.out.println(Database.objResult.getString("Deleted"));
                //JOptionPane.showMessageDialog(null, Database.objResult.getString("Barcode"), "Note", JOptionPane.WARNING_MESSAGE);
                ListBarang.add(new ModelBarang(Database.objResult.getString("Barcode"),
                        Database.objResult.getString("Nama"),
                        Float.parseFloat(Database.objResult.getString("Harga")),
                        Integer.parseInt(Database.objResult.getString("Stock")),
                        avail
                ));

            }
            objResult.close();
            GlobalVariables.getLoadingScreen().hide();
        }
        catch (SQLException ex)
        {
            JOptionPane.showMessageDialog(null, ex, "SQL Error", JOptionPane.WARNING_MESSAGE);
            GlobalVariables.getLoadingScreen().hide();
        }
        GlobalVariables.getLoadingScreen().hide();
    }

    public static boolean AddBarang(ModelBarang barang)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("INSERT INTO BARANG_TABEL (BARCODE, NAMA, HARGA, STOCK, DELETED) VALUES (?, ?, ?, ?, ?)");
            Database.objPreparedStatement.setString(1, barang.getBarcodeId());
            Database.objPreparedStatement.setString(2, barang.getName());
            Database.objPreparedStatement.setDouble(3, barang.getPrice());
            Database.objPreparedStatement.setInt(4, barang.getQty());
            String deleted;
            if(barang.isAvail()) deleted = "N"; else deleted = "Y";
            Database.objPreparedStatement.setString(5, deleted);
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            ListBarang.add(barang);
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(SQLException e)
        {
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }

    public static boolean EditBarang(ModelBarang barangOld, ModelBarang barangNew)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE BARANG_TABEL SET BARCODE = ?, NAMA = ?, HARGA = ?, STOCK = ?, DELETED = ? WHERE Barcode = ?");
            Database.objPreparedStatement.setString(1, barangNew.getBarcodeId());
            Database.objPreparedStatement.setString(2, barangNew.getName());
            Database.objPreparedStatement.setDouble(3, barangNew.getPrice());
            Database.objPreparedStatement.setInt(4, barangNew.getQty());
            Database.objPreparedStatement.setString(6, barangOld.getBarcodeId());
            String deleted;
            if(barangNew.isAvail()) deleted = "N"; else deleted = "Y";
            Database.objPreparedStatement.setString(5, deleted);
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            ListBarang.set(findIndeksBarang(barangOld.getBarcodeId()), barangNew);
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }


    public static int findIndeksBarang(String Barcode)
    {
        int i = 0;
        for(ModelBarang barang : ListBarang)
        {
            if(barang.getBarcodeId().equals(Barcode)) return i;
            i++;
        }
        return -1;
    }

    public static ModelBarang findBarang(String Barcode)
    {
        int i = 0;
        for(ModelBarang barang : ListBarang)
        {
            if(barang.getBarcodeId().equals(Barcode)) return barang;
            i++;
        }
        return null;
    }

    public static ModelPickedItem findPicked(String Barcode)
    {
        int i = 0;
        for(ModelPickedItem barang : ListPickedItem)
        {
            if(barang.getObjBarang().getBarcodeId().equals(Barcode)) return barang;
            i++;
        }
        return null;
    }

     public static int findIndeksPicked(String Barcode)
    {
        int i = 0;
        for(ModelPickedItem barang : ListPickedItem)
        {
            if(barang.getObjBarang().getBarcodeId().equals(Barcode)) return i;
            i++;
        }
        return -1;
    }

    public static boolean DeleteBarang(ModelBarang barang)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE BARANG_TABEL SET DELETED = ? WHERE Barcode = ?");
            Database.objPreparedStatement.setString(1, "Y");
            Database.objPreparedStatement.setString(2, barang.getBarcodeId());
            barang.setAvail(false);
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            ListBarang.set(findIndeksBarang(barang.getBarcodeId()), barang);
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(SQLException e)
        {
            GlobalVariables.getLoadingScreen().hide();
            System.out.println(e);
            return false;
        }
    }

    public static boolean DeleteBarangPermanen(ModelBarang barang)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("DELETE FROM BARANG_TABEL WHERE Barcode = ?");
            Database.objPreparedStatement.setString(1, barang.getBarcodeId());
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            ListBarang.remove(barang);
            return true;
        }
        catch(SQLException e)
        {
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }

    public static void PrintToTable(JTable tabel, boolean printavailyesno)
    {
        DefaultTableModel mtabel = (DefaultTableModel) tabel.getModel();
        while(tabel.getRowCount()>0)
            mtabel.removeRow(0);
        int i=0;
        if(printavailyesno)
        {
            for(ModelBarang barang : ListBarang)
            {
                System.out.println(barang.isAvail());
                if(barang.isAvail())
                {
                    Object kolom[] = new Object[4];
                    kolom[0] = barang.getBarcodeId();
                    kolom[1] = barang.getName();
                    kolom[2] = barang.getQty();
                    kolom[3] = barang.getPrice();
                    mtabel.insertRow(i++, kolom);
                }

            }
        }
        else
        {
            for(ModelBarang barang : ListBarang)
            {
                System.out.println(barang.getBarcodeId());
                if(!barang.isAvail())
                {
                    Object kolom[] = new Object[4];
                    kolom[0] = barang.getBarcodeId();
                    kolom[1] = barang.getName();
                    kolom[2] = barang.getQty();
                    kolom[3] = barang.getPrice();
                    mtabel.insertRow(i++, kolom);
                }

            }
        }

    }

    public static void PrintAndSearchBy(JTable tabel, String input, boolean mode)
    {
        if(input == null) return;
        DefaultTableModel mtabel = (DefaultTableModel) tabel.getModel();
        while(tabel.getRowCount()>0)
            mtabel.removeRow(0);
        int i=0;
        for(ModelBarang barang : ListBarang)
        {
            if(barang.isAvail())
            {
                if(!mode)
                {
                    if((barang.getName()).toLowerCase().contains(input.toLowerCase()))
                    {
                        Object kolom[] = new Object[4];
                        kolom[0] = barang.getBarcodeId();
                        kolom[1] = barang.getName();
                        kolom[2] = barang.getQty();
                        kolom[3] = barang.getPrice();
                        mtabel.insertRow(i++, kolom);
                    }
                } else
                {
                    if((barang.getBarcodeId()).toLowerCase().contains(input.toLowerCase()))
                    {
                        Object kolom[] = new Object[4];
                        kolom[0] = barang.getBarcodeId();
                        kolom[1] = barang.getName();
                        kolom[2] = barang.getQty();
                        kolom[3] = barang.getPrice();
                        mtabel.insertRow(i++, kolom);
                    }
                }

            }
        }

    }

     public static void PrintToBasketTable(JTable tabel)
    {
        DefaultTableModel mtabel = (DefaultTableModel) tabel.getModel();
        while(tabel.getRowCount()>0)
            mtabel.removeRow(0);
        int i=0;
        for(ModelPickedItem pairedbarang : ListPickedItem)
            {
                ModelBarang barang = pairedbarang.getObjBarang();
                if(barang.isAvail())
                {
                    Object kolom[] = new Object[5];
                    kolom[0] = barang.getBarcodeId();
                    kolom[1] = barang.getName();
                    kolom[2] = pairedbarang.getQty();
                    kolom[3] = barang.getPrice();
                    kolom[4] = barang.getPrice() * pairedbarang.getQty();
                    mtabel.insertRow(i++, kolom);
                }

            }
        }

     public static void AddToPicked(ModelBarang barang)
     {
         int index = findIndeksPicked(barang.getBarcodeId());
         if(ListPickedItem.isEmpty())
             ListPickedItem.add(new ModelPickedItem(barang, 1));
         else if(index == -1)
             ListPickedItem.add(new ModelPickedItem(barang, 1));
         else
         {
             ListPickedItem.get(index).setQty(ListPickedItem.get(index).getQty()+1);
         }

     }

     public static void SetPickedQty(String barcode, int qty)
     {
         int index = findIndeksPicked(barcode);
         ListPickedItem.get(index).setQty(qty);

     }

     public static void DeletePicked(String barcode)
     {
         int index = findIndeksPicked(barcode);
         System.out.println(index + "--" + barcode);
         ListPickedItem.remove(index);

     }

     public static int CountBarang()
     {
         return 0;
        // objResult = Database.statement.
     }


}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package programkasirgrosiraninc.Storage;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import programkasirgrosiraninc.Form.Dialogs.DlgaPengaturan;

/**
 *
 * @author King Aldemar I
 */
public class Database {
    static Connection objConnection;
    static Statement objStatement;
    static ResultSet objResult;
    static PreparedStatement objPreparedStatement;
    public static void StartDatabase()
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Class.forName("oracle.jdbc.driver.OracleDriver");
            objConnection = DriverManager.getConnection("jdbc:oracle:thin:@"+
                    GlobalVariables.getHostname()+":"+
                    GlobalVariables.getPortNo()+":xe",
                    GlobalVariables.getUserDB(), GlobalVariables.getPasswordDB());
            objStatement = objConnection.createStatement();
        }
        catch(Exception e)
        {
           GlobalVariables.getLoadingScreen().hide();
           JOptionPane.showMessageDialog(null, e, "PANICKD", JOptionPane.ERROR_MESSAGE);
        }
        GlobalVariables.getLoadingScreen().hide();
    }

    public static void StopDatabase()
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            objStatement = objConnection.createStatement();
            objConnection.close();
            objStatement.close();
        }
        catch(Exception e)
        {
           JOptionPane.showMessageDialog(null, e, "PANICKD", JOptionPane.ERROR_MESSAGE);
        }
        GlobalVariables.getLoadingScreen().hide();
    }

    public static void ExecuteSQL(String Commands)
    {
        try
        {
            objResult.close();
            objResult = objStatement.executeQuery(Commands);
            while(objResult.next()) System.out.println(objResult.getInt(1)+" "+objResult.getString(2)+" "+objResult.getString(3));
            objResult.close();
        }
        catch(Exception e)
        {
             JOptionPane.showMessageDialog(null, e, "SQL Error", JOptionPane.WARNING_MESSAGE);
        }
    }

    public static String TestConnection()
    {
        try
        {
            StartDatabase();
            StopDatabase();
            return "Sukses.";
        }catch(Exception e)
        {
            return e.toString();
        }
    }

    public static long Ping()
    {
        try
        {
            long startTime = System.currentTimeMillis();
            objResult = objStatement.executeQuery("select 1 from dual");
            objResult.close();
            long endTime = (System.currentTimeMillis()) ;
            long duration =(endTime - startTime);
            return duration;
        }catch(SQLException e)
        {
            return -1;
        }
    }

}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package programkasirgrosiraninc.Storage;

import java.util.prefs.Preferences;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.UIManager;
import programkasirgrosiraninc.Form.Dialogs.DlgaLoading;
import programkasirgrosiraninc.Model.ModelUser;

/**
 *
 * @author King Aldemar I
 */
public class GlobalVariables {
    private static ModelUser user;
    private static boolean transactionOK;
    private static JDialog LoadingScreen;
    private static String hostname;
    private static int portNo;
    private static Preferences userpref ;
    private static boolean firstRun;
    private static String userDB, passwordDB;
    private static boolean Started = false;

    public static boolean isStarted() {
        return Started;
    }

    public static void setStarted(boolean Started) {
        GlobalVariables.Started = Started;
    }


    public static String getHostname() {
        return hostname;
    }

    public static void setHostname(String hostname) {
        if(hostname == "") hostname = "localhost";
        GlobalVariables.hostname = hostname;
    }

    public static int getPortNo() {
        return portNo;
    }

    public static void setPortNo(int portNo) {
        GlobalVariables.portNo = portNo;
    }

    public static String getUserDB() {
        return userDB;
    }

    public static void setUserDB(String userDB) {
        if(hostname == "") hostname = "test";
        GlobalVariables.userDB = userDB;
    }

    public static String getPasswordDB() {
        return passwordDB;
    }

    public static void setPasswordDB(String passwordDB) {
        if(hostname == "") hostname = "test";
        GlobalVariables.passwordDB = passwordDB;
    }

    public static void  initGlobalVariables()
    {
        LoadingScreen = new DlgaLoading();
        userpref = Preferences.userNodeForPackage(GlobalVariables.class);
        Load();
        UIManager.put("OptionPane.okButtonText", "[Enter] Accept");
        UIManager.put("OptionPane.cancelButtonText", "[Esc] Back");
        Database.StartDatabase();
        UserStorage.ReloadUser();
        BarangStorage.ReloadBarang();
        TransactionStorage.ReloadTransaction();
        LoadingScreen.hide();
    }

    public static boolean isFirstRun() {
        return firstRun;
    }

    public static JDialog getLoadingScreen() {
        return LoadingScreen;
    }


    public static boolean isTransactionOK() {
        return transactionOK;
    }

    public static void setTransactionOK(boolean transactionOK) {
        System.out.println("ok: "+transactionOK);
        GlobalVariables.transactionOK = transactionOK;
    }


    public static ModelUser getUser() {
        return user;
    }

    public static String GetUserType()
    {
        return user.getClass().getSimpleName();
    }

    public static void setUser(ModelUser user) {
        GlobalVariables.user = user;
    }

    public static void Save()
    {
        userpref.put("hostname", hostname);
        userpref.putInt("port", portNo);
        userpref.put("user", userDB);
        userpref.put("password", passwordDB);
    }

    public static void Reset()
    {
        userpref.put("user", "test");
        userpref.put("password", "test");
        userpref.putInt("port", 1521);
        userpref.put("hostname", "localhost");
        userpref.putBoolean("firstrun", true);
    }

    public static void Load()
    {
        userDB = userpref.get("user", "test");
        passwordDB = userpref.get("password", "test");
        portNo = userpref.getInt("port", 1521);
        hostname = userpref.get("hostname", "localhost");
        firstRun = userpref.getBoolean("firstrun", true);
    }

}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package programkasirgrosiraninc.Storage;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import static programkasirgrosiraninc.Storage.Database.objResult;
import programkasirgrosiraninc.Model.Kasir;
import programkasirgrosiraninc.Model.Kurir;
import programkasirgrosiraninc.Model.ModelPickedItem;
import programkasirgrosiraninc.Model.ModelTransaction;
import programkasirgrosiraninc.Model.ModelUser;
import static programkasirgrosiraninc.Storage.BarangStorage.findIndeksBarang;

/**
 *
 * @author King Aldemar I
 */
public class UserStorage {
    private static List<Kasir> ListKasirUsers;
    private static List<Kurir> ListKurirUsers;

    public static List<Kasir> getListKasirUsers() {
        return ListKasirUsers;
    }

    public static List<Kurir> getListKurirUsers() {
        return ListKurirUsers;
    }



    public static void ReloadUser()
    {
        //Database.ExecuteSQL("select * from user_table order by type");
        ListKasirUsers = new ArrayList<>();
        ListKurirUsers = new ArrayList<>();
        try
        {
            GlobalVariables.getLoadingScreen().show();
            //reload Parent user class
            objResult = Database.objStatement.executeQuery("select * from user_table join kasir_tabel using (userid)");
            System.out.println("Kasir");
            while(Database.objResult.next())
            {
                Kasir kasir = new Kasir(Database.objResult.getString("USERID"),
                Database.objResult.getString("USERNAME"),
                Database.objResult.getString("PASSWORD"));
                kasir.setPrivilage(Integer.parseInt(Database.objResult.getString("PRIVILAGE")));
                if("Y".equals(Database.objResult.getString("ACTIVE")))
                    kasir.Enable();
                else kasir.Disband();
                ListKasirUsers.add(kasir);
                System.out.println("|-"+ " K "  + Database.objResult.getString("USERID") + " " + Database.objResult.getString("Username"));
            }

            objResult.close();

            objResult = Database.objStatement.executeQuery("select * from user_table join kurir_tabel using (userid)");
            System.out.println("Kurir");
            while(Database.objResult.next())
            {
                Kurir kurir = new Kurir(Database.objResult.getString("USERID"),
                Database.objResult.getString("USERNAME"),
                Database.objResult.getString("PASSWORD"));
                kurir.setUnitNo(Integer.parseInt(Database.objResult.getString("UNITNO")));
                if("Y".equals(Database.objResult.getString("ACTIVE")))
                    kurir.Enable();
                else kurir.Disband();
                ListKurirUsers.add(kurir);
                System.out.println("|-"+ " U "  + Database.objResult.getString("USERID") + " " + Database.objResult.getString("Username"));
            }

            objResult.close();



        } catch (SQLException ex)
        {
            GlobalVariables.getLoadingScreen().hide();
            JOptionPane.showMessageDialog(null, ex, "SQL Error", JOptionPane.WARNING_MESSAGE);

        }
        GlobalVariables.getLoadingScreen().hide();
    }

    public static boolean AddUserKasir(Kasir User)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("INSERT INTO USER_TABLE "
                    + "(USERID, USERNAME, PASSWORD, ACTIVE) "
             + "VALUES (?, ?, ?, ?)");
            Database.objPreparedStatement.setString(1, User.getUid());
            Database.objPreparedStatement.setString(2, User.getUser());
            Database.objPreparedStatement.setString(3, User.getPassword());
            String ok;
            if(User.isActive()) ok = "Y"; else ok = "N";
            Database.objPreparedStatement.setString(4, ok);
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();

            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("INSERT INTO KASIR_TABEL"
                    + " (USERID, PRIVILAGE)"
             + " VALUES (?, ?)");
            Database.objPreparedStatement.setString(1, User.getUid());
            Database.objPreparedStatement.setInt(2, User.getPrivilage());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            ListKasirUsers.add( User);
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }

    public static boolean AddUserKurir(Kurir User)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("INSERT INTO USER_TABLE "
                    + "(USERID, USERNAME, PASSWORD, ACTIVE) "
             + "VALUES (?, ?, ?, ?)");
            Database.objPreparedStatement.setString(1, User.getUid());
            Database.objPreparedStatement.setString(2, User.getUser());
            Database.objPreparedStatement.setString(3, User.getPassword());
            String ok;
            if(User.isActive()) ok = "Y"; else ok = "N";
            Database.objPreparedStatement.setString(4, ok);
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();

            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("INSERT INTO KURIR_TABEL"
                    + " (USERID, UNITNO)"
             + " VALUES (?, ?)");
            Database.objPreparedStatement.setString(1, User.getUid());
            Database.objPreparedStatement.setInt(2, User.getUnitNo());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();

            ListKurirUsers.add(User);
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }


    public static boolean EditUserKasir(Kasir UserOld, Kasir UserNew)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE  USER_TABLE SET USERNAME = ?, PASSWORD = ? WHERE USERID=?");
            Database.objPreparedStatement.setString(1, UserNew.getUser());
            Database.objPreparedStatement.setString(2, UserNew.getPassword());
            Database.objPreparedStatement.setString(3, UserOld.getUid());

            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();

            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE KASIR_TABEL SET PRIVILAGE = ? WHERE USERID =? ");
            Database.objPreparedStatement.setString(2, UserOld.getUid());
            Database.objPreparedStatement.setInt(1, UserNew.getPrivilage());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            UserNew.setUid(UserOld.getUid());

            ListKasirUsers.set(findKasirIndex(UserOld.getUid()), UserNew);

            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }

    public static boolean EditUserKurir(Kurir UserOld, Kurir UserNew)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE  USER_TABLE SET USERNAME = ?, PASSWORD = ? WHERE USERID=?");
            Database.objPreparedStatement.setString(1, UserNew.getUser());
            Database.objPreparedStatement.setString(2, UserNew.getPassword());
            Database.objPreparedStatement.setString(3, UserOld.getUid());

            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();

            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("UPDATE KURIR_TABEL SET UNITNO = ? WHERE USERID =? ");
            Database.objPreparedStatement.setString(2, UserOld.getUid());
            Database.objPreparedStatement.setInt(1, UserNew.getUnitNo());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            UserNew.setUid(UserOld.getUid());

            ListKurirUsers.set(findKurirIndex(UserOld.getUid()), UserNew);

            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }

    public static boolean DeleteUserKasir(ModelUser User)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("DELETE FROM  KASIR_TABEL  WHERE USERID=?");
            Database.objPreparedStatement.setString(1, User.getUid());
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("DELETE FROM  USER_TABLE  WHERE USERID=?");
            Database.objPreparedStatement.setString(1, User.getUid());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }

    }

     public static boolean DeleteUserKurir(ModelUser User)
    {
        try
        {
            GlobalVariables.getLoadingScreen().show();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("DELETE FROM  KURIR_TABEL  WHERE USERID=?");
            Database.objPreparedStatement.setString(1, User.getUid());
            ResultSet rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            Database.objPreparedStatement = Database.objConnection.prepareStatement
            ("DELETE FROM  USER_TABLE  WHERE USERID=?");
            Database.objPreparedStatement.setString(1, User.getUid());
            rs = Database.objPreparedStatement.executeQuery();
            Database.objPreparedStatement.close();
            rs.close();
            GlobalVariables.getLoadingScreen().hide();
            return true;
        }
        catch(Exception e)
        {
            System.out.println(e);
            GlobalVariables.getLoadingScreen().hide();
            return false;
        }
    }
    public static ModelUser findUser(String User)
    {
        for(Kasir objUser : ListKasirUsers)
        {
            if(objUser.getUser().equalsIgnoreCase(User))
                return objUser;
        }

        for(Kurir objUser : ListKurirUsers)
        {
            if(objUser.getUser().equalsIgnoreCase(User))
                return objUser;
        }
        return null;
    }


    public static Kurir findKurir(String UID)
    {
        for(Kurir user : ListKurirUsers)
        {
            if(user.getUid().equals(UID)) return user;
        }
        return null;
    }

    public static Kasir findKasir(String UID)
    {
        for(Kasir user : ListKasirUsers)
        {
            if(user.getUid().equals(UID)) return user;
        }
        return null;
    }

    public static int findKurirIndex(String UID)
    {
        int i = 0;
        for(Kurir user : ListKurirUsers)
        {
            if(user.getUid().equals(UID)) return i;
            i++;
        }
        return -1;
    }

   public static int findKasirIndex(String UID)
    {
        int i = 0;
        for(Kasir user : ListKasirUsers)
        {
            if(user.getUid().equals(UID)) return i;
            i++;
        }
        return -1;
    }

    public static String getPassword(String User)
    {
        for(Kasir objUser : ListKasirUsers)
        {
            if(objUser.getUser().equalsIgnoreCase(User))
                return objUser.getPassword();
        }

        for(Kurir objUser : ListKurirUsers)
        {
            if(objUser.getUser().equalsIgnoreCase(User))
                return objUser.getPassword();
        }
        return "";
    }
    public static void PrintKasirToTabel(JTable tabel)
    {
        DefaultTableModel mtabel = (DefaultTableModel) tabel.getModel();
        while(tabel.getRowCount()>0)
            mtabel.removeRow(0);
        int i=0;

        for(Kasir kasir : ListKasirUsers)
        {
            Object kolom[] = new Object[5];
            kolom[0] = kasir.getUid();
            kolom[1] = kasir.getUser();
            kolom[2] = kasir.getPrivilage();
            kolom[3] = kasir.isActive();
            mtabel.insertRow(i++, kolom);

        }

    }

     public static void PrintKurirToTabel(JTable tabel)
    {
        DefaultTableModel mtabel = (DefaultTableModel) tabel.getModel();
        while(tabel.getRowCount()>0)
            mtabel.removeRow(0);
        int i=0;

        for(Kurir kurir : ListKurirUsers)
        {
            Object kolom[] = new Object[5];
            kolom[0] = kurir.getUid();
            kolom[1] = kurir.getUser();
            kolom[2] = kurir.getUnitNo();
            kolom[3] = kurir.isActive();
            mtabel.insertRow(i++, kolom);

        }

    }

}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package programkasirgrosiraninc.Storage;

import java.util.Random;
import java.util.UUID;

/**
 *
 * @author King Aldemar I
 */
public class Utils {
    public static String GenerateRandom()
    {
        return UUID.randomUUID().toString();
    }

     public static String getSaltString() {
        String SALTCHARS = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
        StringBuilder salt = new StringBuilder();
        Random rnd = new Random();
        while (salt.length() < 18) {
            int index = (int) (rnd.nextFloat() * SALTCHARS.length());
            salt.append(SALTCHARS.charAt(index));
        }
        String saltStr = salt.toString();
        return saltStr;

    }

}