/********************************************************************************
* *
* (c) Copyright 2010 Verizon Communications USA and The Open University UK *
* *
* This software is freely distributed in accordance with *
* the GNU Lesser General Public (LGPL) license, version 3 or later *
* as published by the Free Software Foundation. *
* For details see LGPL: http://www.fsf.org/licensing/licenses/lgpl.html *
* and GPL: http://www.fsf.org/licensing/licenses/gpl-3.0.html *
* *
* This software is provided by the copyright holders and contributors "as is" *
* and any express or implied warranties, including, but not limited to, the *
* implied warranties of merchantability and fitness for a particular purpose *
* are disclaimed. In no event shall the copyright owner or contributors be *
* liable for any direct, indirect, incidental, special, exemplary, or *
* consequential damages (including, but not limited to, procurement of *
* substitute goods or services; loss of use, data, or profits; or business *
* interruption) however caused and on any theory of liability, whether in *
* contract, strict liability, or tort (including negligence or otherwise) *
* arising in any way out of the use of this software, even if advised of the *
* possibility of such damage. *
* *
********************************************************************************/
package com.compendium.core.datamodel.services;
import java.sql.SQLException;
import java.util.Vector;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.compendium.core.datamodel.PCSession;
import com.compendium.core.db.DBCodeGroup;
import com.compendium.core.db.management.DBConnection;
import com.compendium.core.db.management.DBDatabaseManager;
/**
* The CodeGroupService class provides services to manipuate code group data in the database.
*
* @author Michelle Bachler
*/
public class CodeGroupService extends ClientService implements ICodeGroupService, java.io.Serializable {
/**
* class's own logger
*/
final Logger log = LoggerFactory.getLogger(getClass());
/**
* Constructor, does nothing
*/
public CodeGroupService() {}
/**
* Constructor, set the name of the service.
*
* @param String sName, the name of this service.
*/
public CodeGroupService(String sName) {
super(sName) ;
}
/**
* Constructor, set the name, ServiceManager and DBDatabaseManager for this service.
*
* @param String sName, the name of this service.
* @param ServiceManager sm, the ServiceManager used by this service.
* @param DBDatabaseManager dbMgr, the DBDatabaseManager used by this service.
*/
public CodeGroupService(String sName, ServiceManager sm, DBDatabaseManager dbMgr) {
super(sName, sm, dbMgr);
}
/**
* Adds a new code group to the database and returns it if successful
*
* @param PCSession session, the session object for the database to use.
* @param String sCodeGroupID, the id of the new code group to add.
* @param String sAuthor, the author of the new code group.
* @param String sName, the name of the new code group.
* @param java.util.Date dCreationDate, the creation date of the new code group.
* @param java.util.Date dModificationDate, the modification date of the new code group.
*
* @return boolean, indicates if the new code group was successfully added.
* @exception java.sql.SQLException, if something went wrong adding the new code group to the database.
*/
public boolean createCodeGroup(PCSession session, String sCodeGroupID, String sAuthor, String sName,
java.util.Date dCreationDate, java.util.Date dModificationDate) throws SQLException {
DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName()) ;
boolean isSucessful = DBCodeGroup.insert(dbcon, sCodeGroupID, sAuthor, sName, dCreationDate, dModificationDate);
getDatabaseManager().releaseConnection(session.getModelName(),dbcon);
return isSucessful;
}
/**
* Delete a codegroup from the database and returns if it is successful.
*
* @param PCSession session, the session object for the database to use.
* @param String sCodeGroupID, the id of the code group to delete.
*
* @return boolean, indicates if the code group was successfully deleted.
* @exception java.sql.SQLException
*/
public boolean deleteCodeGroup(PCSession session, String sCodeGroupID) throws SQLException {
DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName()) ;
boolean deleted = DBCodeGroup.delete(dbcon, sCodeGroupID);
getDatabaseManager().releaseConnection(session.getModelName(),dbcon);
return deleted;
}
/**
* Set the Name of the group to the given name.
*
* @param PCSession session, the session object for the database to use.
* @param String sCodeGroupID, the id of the code group to set the name of.
* @param String sName, the new name of the code group.
* @param java.util.Date dModificationDate, the modification date of the code group name.
* @param String sUserID, the id of the user setting the name of the code group.
*
* @return boolean, indicates if the new name was successfully added.
* @exception java.sql.SQLException, if something went wrong setting the new name in the database.
*/
public boolean setName(PCSession session, String sCodeGroupID, String sName, java.util.Date dModificationDate, String sUserID) throws SQLException {
DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName()) ;
boolean successful = DBCodeGroup.setName(dbcon, sCodeGroupID, sName, dModificationDate, sUserID);
getDatabaseManager().releaseConnection(session.getModelName(),dbcon);
return successful;
}
/**
* Returns the CodeGroup information from the Database for the given CodeGroupID
*
* @param PCSession session, the session object for the database to use.
* @param String sCodeGroupID, the id of the code group to get.
*
* @return Vector, of information on the CodeGroup in the Database with the given CodeGroupID
* @exception java.sql.SQLException
*/
public Vector getCodeGroup(PCSession session, String sCodeGroupID) throws SQLException {
DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName()) ;
Vector vtCodeGroup = DBCodeGroup.getCodeGroup(dbcon, sCodeGroupID);
getDatabaseManager().releaseConnection(session.getModelName(),dbcon);
return vtCodeGroup;
}
/**
* Returns all the code groups from the Database.
*
* @param PCSession session, the session object for the database to use.
*
* @return a Vector of information on all the CodeGroups in the Database
* @exception java.sql.SQLException
*/
public Vector getCodeGroups(PCSession session) throws SQLException {
DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName());
Vector vtCodeGroups = DBCodeGroup.getCodeGroups(dbcon);
getDatabaseManager().releaseConnection(session.getModelName(), dbcon);
return vtCodeGroups;
}
}