public String getConsignmentNotInWareHouse(String referenceId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getConsignmentNotInWareHouse(referenceId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getConsignmentNotInWareHouse()] -> " + e.toString());
throw new EJBException("Error Doing getConsignmentNotInWareHouse");
}
return result;
}
public String isValidReferenceId(String referenceId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.isValidReferenceId(referenceId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [isValidReferenceId()] -> " + e.toString());
throw new EJBException("Error Validating referenceId");
}
return result;
}
public String getAirlineDescription(String Airline) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getAirlineDescription(Airline);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getAirlineDescription()] -> " + e.toString());
throw new EJBException("Error Doing getAirlineDescription");
}
return result;
}
public String getPRSData(String prsId, String terminalId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getPRSData(prsId, terminalId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getPRSData()] -> " + e.toString());
throw new EJBException("Error Doing getPRSData");
}
return result;
}
public String getPalletData(String palletId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getPalletData(palletId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [palletId()] -> " + e.toString());
throw new EJBException("Error getting Pallet Data");
}
return result;
}
// Goutham
public String isValidDepotId(String depotId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getDepotIdData(depotId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [isValidDepotId()] -> " + e.toString());
throw new EJBException("Error while getting DepotId");
}
return result;
} // Goutham
public String getReferenceType(String referenceId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getRefType(referenceId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getReferenceType()] -> " + e.toString());
throw new EJBException("Error while getting ReferenceType");
}
return result;
}
/*public String getConsignmentData(String consignmentId,String terminalId)throws RemoteException{
String result = "";
try{
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getConsignmentData(consignmentId,terminalId);
}catch (Exception e) {
Logger.error(FILE_NAME, " [getGSDStatusReport()] -> "+e.toString());
throw new EJBException("Error while getting consignmentData");
}
return result;
}*/
public String isValidLocationCode(String locationId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.isValidLocationCode(locationId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [isValidLocationCode()] -> " + e.toString());
throw new EJBException("Error while getting LocationCode");
}
return result;
}
public String getReferenceData(String referenceId, String subOperation) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getReferenceData(referenceId, subOperation);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getReferenceData()] -> " + e.toString());
throw new EJBException("Error getting ReferenceId Data");
}
return result;
}
public String createMAWBULD(String masterDocId, String[] uldId) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.createMAWBULD(masterDocId, uldId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [createMAWBULD()] -> " + e.toString());
throw new EJBException("Error getting ULD Data");
}
return result;
}
public String isValidConsignmentId(String consignmentId, String terminalId)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.isValidConsignmentId(consignmentId, terminalId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [isValidConsignmentId()] -> " + e.toString());
throw new EJBException("Error in isValidConsignmentId");
}
return result;
}
public String getGSDStatusReport(String consignmentId, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getGSDStatusReport(consignmentId, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getGSDStatusReport()] -> " + e.toString());
throw new EJBException("Error in getting Goods Storage status");
}
return result;
}
public String getWHStatusReport(String referenceId, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getWHStatusReport(referenceId, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getWHStatusReport()] -> " + e.toString());
throw new EJBException("Error getting WH Status Report");
}
return result;
}
// Added by SureshK for CR_1918
public ArrayList getMAWBDtl(String masterDocId, String terminalId) throws RemoteException {
Logger.info(FILE_NAME, " [getMasterDataForULDBuild()] [masterDocId] " + masterDocId);
ArrayList result = null;
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getMAWBDetails(masterDocId, terminalId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getMasterDataForULDBuild()] -> " + e.toString());
throw new EJBException("Error getting getMasterDataForULDBuild ");
}
return result;
}
public String loadMAWBULD(String masterDocId, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.loadMAWBULD(masterDocId, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [loadMAWBULD()] -> " + e.toString());
throw new EJBException("Error getting ULD Data");
}
return result;
}
public String getPickListData(
String docId, String subOperation, ESupplyGlobalParameters loginBean) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getPickListData(docId, subOperation, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getPickListData()] -> " + e.toString());
throw new EJBException("Error getting Pick List Data");
}
return result;
}
// Added by SureshK for CR_1918
public String getULDAllocationDtl(String houseDocId, String terminalId) throws RemoteException {
Logger.info(FILE_NAME, " [getMasterDataForULDBuild()] [houseDocId] " + houseDocId);
String result = null;
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getULDAllocationDetails(houseDocId, terminalId);
} catch (Exception e) {
Logger.error(FILE_NAME, " [getMasterDataForULDBuild()] -> " + e.toString());
throw new EJBException("Error getting getMasterDataForULDBuild ");
}
return result;
}
public String isValidULDId(String uldId, String terminalId) throws RemoteException {
Logger.info(FILE_NAME, " In isValidULDId() uldId " + uldId);
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.isValidULDId(uldId, terminalId);
Logger.info(FILE_NAME, " In isValidULDId() result " + result);
} catch (Exception e) {
Logger.error(FILE_NAME, " [isValidULDId()] -> " + e.toString());
throw new EJBException("Error while getting ULDId data");
}
return result;
}
public String putAway(
String locationId, String referenceId, String refType, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.putAway(locationId, referenceId, refType, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [putAway()] -> " + e.toString());
throw new EJBException("Error Doing putAway");
}
return result;
}
public String updateWareHouseStatus(
String referenceId, String refType, String subOperation, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.updateWareHouseStatus(referenceId, refType, subOperation, loginBean);
} catch (Exception e) {
Logger.error(FILE_NAME, " [updateWareHouseStatus()] -> " + e.toString());
throw new EJBException("Error Doing updateWareHouseStatus");
}
return result;
}
public String updateTWHStatus(
String docId, String subOperation, String status, ESupplyGlobalParameters loginBean) {
Logger.info(FILE_NAME, " In updateTWHStatus() docId " + docId);
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.updateTWHStatus(docId, subOperation, status, loginBean);
Logger.info(FILE_NAME, " In getDetpatchData() ");
} catch (Exception e) {
Logger.error(FILE_NAME, " [updateTWHStatus()] -> " + e.toString());
throw new EJBException("Error while updating status");
}
return result;
}
/*
* ULD Build Methods Ends Here
*/
public String getDespatchData(String referenceId, String refType) throws RemoteException {
Logger.info(
FILE_NAME, " In getDetpatchData() ReferenceId " + referenceId + " RefType " + refType);
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
result = gsdDAO.getDespatchData(referenceId, refType);
Logger.info(FILE_NAME, " In getDetpatchData() ");
} catch (Exception e) {
Logger.error(FILE_NAME, " [getDetpatchData()] -> " + e.toString());
throw new EJBException("Error while getting ULDId data");
}
return result;
}
public String create(
ETGSDDOB gsdDetailDOB,
String operation,
String subOperation,
ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
// @@Added By V.Sreelatha on 16/04/2010 for Audit Trail
gsdDetailDOB.setLoginBean(loginBean);
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("GSD".equals(subOperation)) {
result = gsdDAO.createGSD(gsdDetailDOB, operation, loginBean);
} else if ("Despatch".equals(subOperation)) {
result = gsdDAO.createDespatch(gsdDetailDOB, operation);
} else if ("WHLocation".equals(subOperation)) {
result = gsdDAO.createDepotLocation(gsdDetailDOB, operation);
} else if ("ULD".equals(subOperation)) {
result = gsdDAO.createULD(gsdDetailDOB, operation);
} else if ("Pallet".equals(subOperation)) {
result = gsdDAO.createPallet(gsdDetailDOB, loginBean);
} else if ("HousePick".equals(subOperation) || "MasterPick".equals(subOperation)) {
result = gsdDAO.createPickList(gsdDetailDOB, subOperation, loginBean);
} else if ("ULDBuild".equals(subOperation)) {
// result = gsdDAO.createULDBuild(gsdDetailDOB, loginBean);
result = gsdDAO.updateULDStatus(gsdDetailDOB, loginBean);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [create()] -> Add " + e.toString());
throw new EJBException("Error in Inserting Goods Storage Details");
}
return result;
}
public ETGSDDOB load(String Id, String operation, String subOperation) throws RemoteException {
ETGSDDOB gsdDetailDOB = null;
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("GSD".equals(subOperation)) {
gsdDetailDOB = gsdDAO.loadGSD(Id, operation);
} else if ("Despatch".equals(subOperation) || "RFDespatch".equals(subOperation)) {
gsdDetailDOB = gsdDAO.loadDespatch(Id, operation);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [load()] -> load " + e.toString());
throw new EJBException("Error in Loading Goods Storage Details");
}
return gsdDetailDOB;
}
public String remove(String consignmentId, String subOperation) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("GSD".equals(subOperation)) {
result = gsdDAO.removeGSD(consignmentId);
} else if ("Despatch".equals(subOperation)) {
result = gsdDAO.removeDespatch(consignmentId);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [remove()] -> " + e.toString());
throw new EJBException("Error in removing Goods Storage Details");
}
return result;
}
public String remove(String Id1, String Id2, String subOperation) throws RemoteException {
String result = "";
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("WHLocation".equals(subOperation)) {
result = gsdDAO.removeDepotLocation(Id1, Id2);
} else if ("ULD".equals(subOperation)) {
result = gsdDAO.removeULD(Id1, Id2);
} else if ("MAWBULD".equals(subOperation)) {
result = gsdDAO.removeMAWBULDId(Id1, Id2);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [remove()] -> " + e.toString());
}
return result;
}
// overloaded method changed by goutam on 22nov
public ETGSDDOB load(String id1, String id2, String operation, String subOperation)
throws RemoteException {
ETGSDDOB gsdDetailDOB = null;
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("WHLocation".equals(subOperation)) {
gsdDetailDOB = gsdDAO.loadDepotLocation(id1, id2, operation);
}
// smithav for depotId
if ("ULD".equals(subOperation)) {
gsdDetailDOB = gsdDAO.loadULD(id1, id2, operation);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [load()] -> load " + e.toString());
throw new EJBException("Error in Loading Goods Storage Details");
}
return gsdDetailDOB;
}
public String store(ETGSDDOB gsdDetailDOB, String subOperation, ESupplyGlobalParameters loginBean)
throws RemoteException {
String result = "";
// @@Added By V.Sreelatha on 16/04/2010 for Audit Trail
gsdDetailDOB.setLoginBean(loginBean);
try {
ETGSDDAO gsdDAO = new ETGSDDAO();
if ("GSD".equals(subOperation)) {
result = gsdDAO.storeGSD(gsdDetailDOB, loginBean);
} else if ("Despatch".equals(subOperation) || "RFDespatch".equals(subOperation)) {
result = gsdDAO.storeDespatch(gsdDetailDOB, subOperation);
} else if ("WHLocation".equals(subOperation)) {
result = gsdDAO.storeDepotLocation(gsdDetailDOB);
} else if ("ULD".equals(subOperation)) {
result = gsdDAO.storeULD(gsdDetailDOB);
} else if ("Pallet".equals(subOperation)) {
result = gsdDAO.updatePallet(gsdDetailDOB, loginBean);
}
} catch (Exception e) {
Logger.error(FILE_NAME, " [store()] -> update " + e.toString());
throw new EJBException("Error in updating Goods Storage Details");
}
return result;
}