Examples with ClientNotConnected SQLDatabase.SQLDatabaseException.ClientNotConnected used on opensource projects

Example 6 with ClientNotConnected

use of SQLDatabase.SQLDatabaseException.ClientNotConnected in project SmartCity-Market by TechnionYP5777.

the class CommandExecuter method removeProductPackageFromStoreCommand.

private void removeProductPackageFromStoreCommand(SQLDatabaseConnection c) {
    ProductPackage productPackage = null;
    log.info("Remove Product Package From Store command called");
    try {
        productPackage = Serialization.deserialize(inCommandWrapper.getData(), ProductPackage.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Remove Product Package From Store command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!productPackage.isValid()) {
        log.info("Remove Product Package From Store command failed, product package is invalid");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else {
        try {
            if (productPackage.getLocation().getPlaceInMarket().equals(PlaceInMarket.STORE))
                c.removeProductPackageFromShelves(inCommandWrapper.getSenderID(), productPackage);
            else
                c.removeProductPackageFromWarehouse(inCommandWrapper.getSenderID(), productPackage);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        } catch (CriticalError e) {
            log.fatal("Remove Product Package From Store command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Remove Product Package From Store command failed, username dosen't login to the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
        } catch (ProductNotExistInCatalog e) {
            log.info("Remove Product Package From Store command failed, product dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        } catch (ProductPackageAmountNotMatch e) {
            log.info("Remove Product Package From Store command failed, try to place more than available");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_AMOUNT_BIGGER_THEN_AVAILABLE);
        } catch (ProductPackageNotExist e) {
            log.info("Remove Product Package From Store command failed, package dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_DOES_NOT_EXIST);
        }
        log.info("Remove Product Package From Store with product package barcode " + productPackage.getSmartCode().getBarcode() + " and amount " + productPackage.getAmount() + " finished");
    }
}

Example 7 with ClientNotConnected

use of SQLDatabase.SQLDatabaseException.ClientNotConnected in project SmartCity-Market by TechnionYP5777.

the class CommandExecuter method addNewManufacturer.

private void addNewManufacturer(SQLDatabaseConnection c) {
    Manufacturer manufacturer = null;
    log.info("Add new manufacturer from serderID " + inCommandWrapper.getSenderID() + " command called");
    try {
        manufacturer = Serialization.deserialize(inCommandWrapper.getData(), Manufacturer.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Add New Manufacturer command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    log.info("Trying to add new manufacturer " + manufacturer + " to system");
    try {
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK, c.addManufacturer(inCommandWrapper.getSenderID(), manufacturer.getName()));
    } catch (CriticalError e) {
        log.fatal("Add new manufacturer command failed, critical error occured from SQL Database connection");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
    } catch (ClientNotConnected e) {
        log.info("Add new manufacturer command failed, client is not connected");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
    }
    log.info("Add new manufacturer " + manufacturer + " to system finished");
}

Example 8 with ClientNotConnected

use of SQLDatabase.SQLDatabaseException.ClientNotConnected in project SmartCity-Market by TechnionYP5777.

the class CommandExecuter method loginEmployeeCommand.

private void loginEmployeeCommand(SQLDatabaseConnection c) {
    Login login = null;
    log.info("Login employee command called");
    try {
        login = Serialization.deserialize(inCommandWrapper.getData(), Login.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for login command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!login.isValid()) {
        log.info("Login command failed, username and password can't be empty");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
        return;
    }
    try {
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        outCommandWrapper.setSenderID(c.loginWorker(login.getUserName(), login.getPassword()));
        try {
            outCommandWrapper.setData(c.getClientType(outCommandWrapper.getSenderID()));
        } catch (ClientNotConnected e) {
            log.fatal("Client is not connected for sender ID " + outCommandWrapper.getSenderID());
        }
        log.info("Login command succeded with sender ID " + outCommandWrapper.getSenderID() + " with client type " + outCommandWrapper.getData());
    } catch (AuthenticationError e) {
        log.info("Login command failed, username dosen't exist or wrong password received");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_USERNAME_DOES_NOT_EXIST_WRONG_PASSWORD);
    } catch (CriticalError e) {
        log.fatal("Login command failed, critical error occured from SQL Database connection");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
    } catch (ClientAlreadyConnected e) {
        log.info("Login command failed, user already connected");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_ALREADY_CONNECTED);
    } catch (NumberOfConnectionsExceeded e) {
        log.fatal("Login command failed, too much connections (try to increase TRYS_NUMBER)");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
    }
    log.info("Login employee with User " + login.getUserName() + " finished");
}

Example 9 with ClientNotConnected

use of SQLDatabase.SQLDatabaseException.ClientNotConnected in project SmartCity-Market by TechnionYP5777.

the class CommandExecuter method removeManufacturer.

private void removeManufacturer(SQLDatabaseConnection c) {
    Manufacturer manufacturer = null;
    log.info("Remove manufacturer from serderID " + inCommandWrapper.getSenderID() + " command called");
    try {
        manufacturer = Serialization.deserialize(inCommandWrapper.getData(), Manufacturer.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Remove Manufacturer command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    log.info("Trying to remove manufacturer " + manufacturer + " from system");
    try {
        c.removeManufacturer(inCommandWrapper.getSenderID(), manufacturer);
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
    } catch (CriticalError e) {
        log.fatal("Remove manufacturer command failed, critical error occured from SQL Database connection");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
    } catch (ClientNotConnected e) {
        log.info("Remove manufacturer command failed, client is not connected");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
    } catch (ManufacturerNotExist e) {
        log.info("Remove manufacturer customer command failed, manufacturer does not exist");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.PARAM_ID_IS_NOT_EXIST);
    } catch (ManufacturerStillUsed e) {
        log.info("Remove manufacturer customer command failed, manufacturer still in use");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_MANUFACTURER_STILL_IN_USE);
    }
    log.info("Remove manufacturer " + manufacturer + " from system finished");
}

Example 10 with ClientNotConnected

use of SQLDatabase.SQLDatabaseException.ClientNotConnected in project SmartCity-Market by TechnionYP5777.

the class CommandExecuter method getProductPackageAmount.

private void getProductPackageAmount(SQLDatabaseConnection c) {
    ProductPackage productPackage = null;
    log.info("Get Product Package Amount command called");
    try {
        productPackage = Serialization.deserialize(inCommandWrapper.getData(), ProductPackage.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Get Product Package Amount command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!productPackage.isValid()) {
        log.info("Get Product Package Amount command failed, product package is invalid");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else {
        String amount = "";
        try {
            amount = productPackage.getLocation().getPlaceInMarket().equals(PlaceInMarket.STORE) ? c.getProductPackageAmonutOnShelves(inCommandWrapper.getSenderID(), productPackage) : c.getProductPackageAmonutInWarehouse(inCommandWrapper.getSenderID(), productPackage);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK, amount);
        } catch (CriticalError e) {
            log.fatal("Get Product Package Amount command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Get Product Package Amount command failed, username dosen't login to the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
        } catch (ProductNotExistInCatalog e) {
            log.info("Get Product Package Amount command failed, product dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        }
        log.info("Get Product Package Amount returned with amount " + amount + " finished");
    }
}