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

Example 51 with ProductNotExistInCatalog

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

the class CommandExecuter method editProductFromCatalogCommand.

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

Example 52 with ProductNotExistInCatalog

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

the class CommandExecuter method placeProductPackageOnShelvesCommand.

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

Example 53 with ProductNotExistInCatalog

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

the class CommandExecuter method removeProductFromCatalogCommand.

private void removeProductFromCatalogCommand(SQLDatabaseConnection c) {
    SmartCode smartCode = null;
    log.info("Remove 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 Remove Product From Catalog command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!smartCode.isValid()) {
        log.info("Remove Product From Catalog command failed, barcode can't be negative");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else {
        try {
            c.removeProductFromCatalog(inCommandWrapper.getSenderID(), smartCode);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        } catch (CriticalError e) {
            log.fatal("Remove Product From Catalog command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Remove Product From Catalog 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 From Catalog command failed, product dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        } catch (ProductStillForSale e) {
            log.info("Remove Product From Catalog command failed, product still for sale");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_STILL_FOR_SALE);
        }
        log.info("Remove Product From Catalog with product barcode " + smartCode.getBarcode() + " finished");
    }
}

Example 54 with ProductNotExistInCatalog

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

the class CommandExecuter method removeProductFromGroceryList.

private void removeProductFromGroceryList(SQLDatabaseConnection c) {
    ProductPackage productPackage = null;
    log.info("Remove Product From Grocery List from serderID " + inCommandWrapper.getSenderID() + " command called");
    try {
        productPackage = Serialization.deserialize(inCommandWrapper.getData(), ProductPackage.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Remove Product From Grocery List command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    log.info("Trying to remove product package " + productPackage + " from grocery list");
    if (!productPackage.isValid()) {
        log.info("Remove Product From Grocery List command failed, product package is invalid");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else
        try {
            c.removeProductFromGroceryList(inCommandWrapper.getSenderID(), productPackage);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        } catch (CriticalError e) {
            log.fatal("Remove Product From Grocery List command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Remove Product From Grocery List command failed, client is not connected");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
        } catch (ProductNotExistInCatalog e) {
            log.info("Remove Product From Grocery List command failed, product is not exist in catalog");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        } catch (ProductPackageAmountNotMatch e) {
            log.info("Remove Product From Grocery List command failed, product package amount does not match");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_AMOUNT_BIGGER_THEN_AVAILABLE);
        } catch (ProductPackageNotExist e) {
            log.info("Remove Product From Grocery List command failed, product package does not exist");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_DOES_NOT_EXIST);
        }
    log.info("Remove Product From Grocery List with product package " + productPackage + " finished");
}

Example 55 with ProductNotExistInCatalog

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

the class RemoveProductFromCatalogTest method removeCatalogProductSuccessfulTest.

@Test
public void removeCatalogProductSuccessfulTest() {
    int senderID = 1;
    SmartCode smartCode = new SmartCode(1, null);
    String command = new CommandWrapper(senderID, CommandDescriptor.REMOVE_PRODUCT_FROM_CATALOG, new Gson().toJson(smartCode, SmartCode.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doNothing().when(sqlDatabaseConnection).removeProductFromCatalog(senderID, smartCode);
    } catch (CriticalError | ClientNotConnected | ProductNotExistInCatalog | ProductStillForSale e) {
        fail();
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_OK, out.getResultDescriptor());
}