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

Example 1 with ProductNotExistInCatalog

use of SQLDatabase.SQLDatabaseException.ProductNotExistInCatalog 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 2 with ProductNotExistInCatalog

use of SQLDatabase.SQLDatabaseException.ProductNotExistInCatalog 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");
    }
}

Example 3 with ProductNotExistInCatalog

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

the class CommandExecuter method viewProductFromCatalogCommand.

private void viewProductFromCatalogCommand(SQLDatabaseConnection c) {
    SmartCode smartCode = null;
    log.info("View Product From Catalog command called");
    try {
        smartCode = Serialization.deserialize(inCommandWrapper.getData(), SmartCode.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for View Product From Catalog command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!smartCode.isValid()) {
        log.info("View Product From Catalog command failed, barcode can't be negative");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
        return;
    }
    try {
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK, c.getProductFromCatalog(inCommandWrapper.getSenderID(), smartCode.getBarcode()));
        log.info("Get product from catalog command secceeded with barcode " + smartCode.getBarcode());
    } catch (ProductNotExistInCatalog e) {
        log.info("Get product from catalog command failed, product dosen't exist in the system");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
    } catch (ClientNotConnected e) {
        log.info("Get product from catalog command failed, username dosen't login to the system");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
    } catch (CriticalError e) {
        log.fatal("Get product from catalog command failed, critical error occured from SQL Database connection");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
    }
    log.info("View Product From Catalog with product barcode " + smartCode.getBarcode() + " finished");
}

Example 4 with ProductNotExistInCatalog

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

the class CommandExecuter method addProductPackageToWarehouseCommand.

private void addProductPackageToWarehouseCommand(SQLDatabaseConnection c) {
    ProductPackage productPackage = null;
    log.info("Add Product Package To Warehouse command called");
    try {
        productPackage = Serialization.deserialize(inCommandWrapper.getData(), ProductPackage.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Add Product Package To Warehouse command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!productPackage.isValid()) {
        log.info("Add Product Package To Warehouse command failed, product package is invalid");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else {
        try {
            c.addProductPackageToWarehouse(inCommandWrapper.getSenderID(), productPackage);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        } catch (CriticalError e) {
            log.fatal("Add Product Package To Warehouse command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Add Product Package To Warehouse command failed, username dosen't login to the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
        } catch (ProductNotExistInCatalog e) {
            log.info("Add Product Package To Warehouse command failed, product dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        }
        log.info("Add Product Package To Warehouse with product package barcode " + productPackage.getSmartCode().getBarcode() + " and amount " + productPackage.getAmount() + " finished");
    }
}

Example 5 with ProductNotExistInCatalog

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

the class PlaceProductPackageOnShelvesTest method placeProductPackageOnShelvesCriticalErrorTest.

@Test
public void placeProductPackageOnShelvesCriticalErrorTest() {
    int senderID = 1;
    ProductPackage productPackage = new ProductPackage(new SmartCode(1, null), 1, new Location(0, 0, PlaceInMarket.WAREHOUSE));
    String command = new CommandWrapper(senderID, CommandDescriptor.PLACE_PRODUCT_PACKAGE_ON_SHELVES, new Gson().toJson(productPackage, ProductPackage.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doThrow(new CriticalError()).when(sqlDatabaseConnection).placeProductPackageOnShelves(senderID, productPackage);
    } catch (ClientNotConnected | ProductNotExistInCatalog | ProductPackageAmountNotMatch | ProductPackageNotExist e) {
        fail();
    } catch (CriticalError __) {
    /* Success */
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_ERR, out.getResultDescriptor());
}