package com.framedobjects.dashwell.db;



import java.sql.Timestamp;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.HashMap;

import java.util.Hashtable;

import java.util.List;

import java.util.Map;

import java.util.Vector;

import java.util.regex.Matcher;

import java.util.regex.Pattern;



import javax.servlet.http.HttpServletRequest;



import org.apache.log4j.Logger;



import wsl.fw.datasource.DataManager;

import wsl.fw.datasource.DataObject;

import wsl.fw.datasource.DataSource;

import wsl.fw.datasource.DataSourceException;

import wsl.fw.datasource.Entity;

import wsl.fw.datasource.EntitySchemaName;

import wsl.fw.datasource.Field;

import wsl.fw.datasource.JdbcDataSourceParam;

import wsl.fw.datasource.Query;

import wsl.fw.datasource.QueryCriterium;

import wsl.fw.datasource.RecordSet;

import wsl.fw.datasource.Sort;

import wsl.fw.exception.MdnException;

import wsl.fw.resource.ResId;

import wsl.fw.resource.ResourceManager;

import wsl.fw.security.Feature;

import wsl.fw.security.Group;

import wsl.fw.security.GroupMembership;

import wsl.fw.security.SecurityManager;

import wsl.fw.security.User;

import wsl.fw.security.UserWrapper;

import wsl.fw.util.CKfw;

import wsl.fw.util.Config;

import wsl.fw.util.Log;

import wsl.mdn.common.MdnAdminConst;

import wsl.mdn.common.MdnDataManager;

import wsl.mdn.common.MdnResourceManager;

import wsl.mdn.dataview.DataSourceDobj;

import wsl.mdn.dataview.DataView;

import wsl.mdn.dataview.DataViewDataSource;

import wsl.mdn.dataview.DataViewField;

import wsl.mdn.dataview.EntityDobj;

import wsl.mdn.dataview.FieldDobj;

import wsl.mdn.dataview.FieldExclusion;

import wsl.mdn.dataview.GroupDataView;

import wsl.mdn.dataview.GroupTablePermission;

import wsl.mdn.dataview.JdbcDataSourceDobj;

import wsl.mdn.dataview.JdbcDriver;

import wsl.mdn.dataview.JoinDobj;

import wsl.mdn.dataview.LanguageDobj;

import wsl.mdn.dataview.MdnDataCache;

import wsl.mdn.dataview.ProjectDobj;

import wsl.mdn.dataview.QueryCriteriaDobj;

import wsl.mdn.dataview.QueryCriteriaHistoryDobj;

import wsl.mdn.dataview.QueryDobj;

import wsl.mdn.dataview.ResultWrapper;

//import wsl.mdn.dataview.UserLicenses;

import wsl.mdn.dataview.WebServiceDobj;

import wsl.mdn.dataview.WebServiceOperationDobj;

import wsl.mdn.guiconfig.MenuAction;

import wsl.mdn.mdnim.IMConnection;

import wsl.mdn.mdnim.IMContact;

import wsl.mdn.mdnim.IMMessage;

import wsl.mdn.mdnmsgsvr.BlockContacts;

import wsl.mdn.mdnmsgsvr.CustomField;

import wsl.mdn.mdnmsgsvr.MdnSmpp;

import wsl.mdn.mdnmsgsvr.MessagingSettingDetails;

import wsl.mdn.mdnmsgsvr.MdnEmailSetting;

import wsl.mdn.mdnmsgsvr.MdnMessageSeparator;

import wsl.mdn.mdnmsgsvr.MdnSmsSetting;

import wsl.mdn.mdnmsgsvr.MessageLog;

import wsl.mdn.mdnmsgsvr.TemporaryBlockContacInfo;

import wsl.mdn.mdnmsgsvr.UserCustomField;

import wsl.mdn.mdnmsgsvr.UserReply;

import wsl.mdn.server.LicenseManager;

import wsl.mdn.server.MdnServer;



import com.framedobjects.dashwell.biz.RecycleBinItem;

import com.framedobjects.dashwell.db.meta.MetaDbConnection;

import com.framedobjects.dashwell.mdnEmail.MdnMailService;

import com.framedobjects.dashwell.mdninstantmsg.MDNIMServer;

import com.framedobjects.dashwell.mdnsms.MdnSmppGatewayServer;

import com.framedobjects.dashwell.mdnsms.MdnSmsServer;

import com.framedobjects.dashwell.utils.MessagingUtils;

import com.framedobjects.dashwell.utils.Constants;



/**

 * Interacts via RMI with server to retrieve data.

 * @author Jens Richnow

 *

 */

public class RmiAgent implements IDataAgent {

	

	static Logger logger = Logger.getLogger(RmiAgent.class.getName());

	

	// resources

	// public static final ResId ERR_HELP   = new ResId ("MdnAdmin.err.Help");

	public static final ResId

		ERR_LICENSE1	= new ResId ("MdnAdminApp.err.license1"),

		ERR_LICENSE2	= new ResId ("MdnAdminApp.err.license2"),

		TEXT_STARTING	= new ResId ("MdnAdminApp.text.starting"),

		TEXT_VERSION	= new ResId ("mdn.versionText"),

		ERR_VERSION1	= new ResId ("MdnAdminApp.err.version1"),

		ERR_VERSION2	= new ResId ("MdnAdminApp.err.version2"),

		ERR_WILL_EXIT	= new ResId ("MdnAdminApp.err.willExit"),

		ERR_NO_SERVER	= new ResId ("MdnAdminApp.err.noServer");	

	

	public static boolean isInitialised = false;

	public static final String CONNECTED = "Connected!";

	private boolean execSql;

	public static final int FAILED_EXEC_SQL = -10;

	

	public RmiAgent() {

		super();

		if (!isInitialised) {

	        init();

	        isInitialised = true;

	      }

	}

	

	private void init(){

		/*

		 *	Set the ResourceManager

		 * (must be first as everything uses resource strings)

		 */

		ResourceManager.set (new MdnResourceManager ());



		// log start and version

		Log.log (

			TEXT_STARTING.getText ()

			+ " " + TEXT_VERSION.getText ()

			+ " " + MdnServer.VERSION_NUMBER);



		// set the config (must be second as nearly everything uses configs)

		Config.setSingleton (MdnAdminConst.MDN_CONFIG_FILE, true);

		Config.getSingleton ().addContext (CKfw.RMICLIENT_CONTEXT);



		// set the DataManager

		DataManager.setDataManager (new MdnDataManager ());



		// set the data cache

		MdnDataCache.setCache (new MdnDataCache (false));		

	}

	

	public int getNumberOfUsers(){

		// get the activation key

		return LicenseManager.getNumberOfUserLicense();

	}	



	public Boolean getPublicGroupFlag(){//True:unlimitided 

		// get the activation key

		return LicenseManager.getPublicGroupFlag();

	}	

	public int getAvailablePublicMessages(){ 

		// get the activation key

		return LicenseManager.getAvailablePublicMessages();

	}	

//	public ResultWrapper getUserLicenses(){

//		// get the activation key

//		return LicenseManager.getUserLicenses();

//	}		



	public String[] getLogFilePath(){

		// get the LogFilePath

		return LicenseManager.getLogFilePath();

	}	

	

//	public ArrayList<String> getUserLicenseTypes(){

//		ResultWrapper resultWrapper = getUserLicenses();

//		UserLicenses userLicenses = (UserLicenses)resultWrapper.getObject();

//		if (userLicenses != null){

//			return userLicenses.getUserLicenseType();

//		}else{

//			return new ArrayList<String>();

//		}		

//	}

	

	public List<LanguageDobj> getAllLanguages() throws MdnException{

		//Find LanguageDobj

		DataSource ds = DataManager.getSystemDS();

		List<LanguageDobj> langs = new Vector<LanguageDobj>();

		Query q = new Query(LanguageDobj.ENT_LANGUAGE);

        QueryCriterium qc = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc);

        try {

			RecordSet rs = ds.select(q);

			while (rs.next()){

				LanguageDobj lang = (LanguageDobj)rs.getCurrentObject();

				langs.add(lang);

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getAllLanguages()", e);

		}		

		return langs;

	}

	public LanguageDobj getDefaultLanguage() throws MdnException{

		//Find LanguageDobj

		DataSource ds = DataManager.getSystemDS();

		Query q = new Query(LanguageDobj.ENT_LANGUAGE);

        QueryCriterium qc = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc);

        QueryCriterium qc2 = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_DEFAULT, QueryCriterium.OP_EQUALS,

                true);

        q.addQueryCriterium(qc2);

        try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				LanguageDobj lang = (LanguageDobj)rs.getCurrentObject();

				return lang;

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getDefaultLanguage()", e);

		}		

		return null;

	}	

	

	public LanguageDobj getLanguageById(int id) throws MdnException{

		//Find LanguageDobj

		DataSource ds = DataManager.getSystemDS();

		Query q = new Query(LanguageDobj.ENT_LANGUAGE);

        /*QueryCriterium qc = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc);*/

        QueryCriterium qc2 = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_ID, QueryCriterium.OP_EQUALS,

                id);

        q.addQueryCriterium(qc2);

        try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				LanguageDobj lang = (LanguageDobj)rs.getCurrentObject();

				return lang;

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getLanguageById()", e);

		}		

		return null;

	}	

	public LanguageDobj getLanguageByName(String languageName) throws MdnException{

		//Find LanguageDobj

		DataSource ds = DataManager.getSystemDS();

		Query q = new Query(LanguageDobj.ENT_LANGUAGE);

        QueryCriterium qc = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc);

        QueryCriterium qc2 = new QueryCriterium(LanguageDobj.ENT_LANGUAGE,

        		LanguageDobj.FLD_NAME, QueryCriterium.OP_EQUALS,

        		languageName);

        q.addQueryCriterium(qc2);

        try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				LanguageDobj lang = (LanguageDobj)rs.getCurrentObject();

				return lang;

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getLanguageByName()", e);

		}		

		return null;

	}		

	public List<JdbcDriver> getAllJdbcDrivers() throws MdnException{

		//Find JdbcDriver

		DataSource ds = DataManager.getSystemDS();

		List<JdbcDriver> jdbcDrivers = new Vector<JdbcDriver>();

		Query q = new Query(JdbcDriver.ENT_JDBCDRIVER);

        QueryCriterium qc = new QueryCriterium(JdbcDriver.ENT_JDBCDRIVER,

        		JdbcDriver.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc);

        try {

			RecordSet rs = ds.select(q);

			while (rs.next()){

				JdbcDriver jdbcDriver = (JdbcDriver)rs.getCurrentObject();

				jdbcDrivers.add(jdbcDriver);

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getAllJdbcDrivers()", e);

		}		

		return jdbcDrivers;

	}

	public JdbcDriver getJdbcDriverByName(String driverName) throws MdnException{

		//Find JdbcDriver

		DataSource ds = DataManager.getSystemDS();

		JdbcDriver jdbcDriver = null;

		Query q = new Query(JdbcDriver.ENT_JDBCDRIVER);

		QueryCriterium qc = new QueryCriterium(JdbcDriver.ENT_JDBCDRIVER, JdbcDriver.FLD_NAME, QueryCriterium.OP_EQUALS, driverName);

		qc.setOrIsNull(true);

		q.addQueryCriterium(qc);

		try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				jdbcDriver = (JdbcDriver)rs.getCurrentObject();

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getJDBCDriverByName()", e);

		}		

		return jdbcDriver;

	}

	public JdbcDriver getJdbcDriverByDriver(String driver) throws MdnException{

		//Find JdbcDriver

		DataSource ds = DataManager.getSystemDS();

		JdbcDriver jdbcDriver = null;

		Query q = new Query(JdbcDriver.ENT_JDBCDRIVER);

		QueryCriterium qc = new QueryCriterium(JdbcDriver.ENT_JDBCDRIVER, JdbcDriver.FLD_DRIVER, QueryCriterium.OP_EQUALS, driver);

		qc.setOrIsNull(true);

		q.addQueryCriterium(qc);

		try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				jdbcDriver = (JdbcDriver)rs.getCurrentObject();

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getJDBCDriverByName()", e);

		}		

		return jdbcDriver;

	}

	public JdbcDriver getJdbcDriverById(int driverId) throws MdnException{

		//Find JdbcDriver

		DataSource ds = DataManager.getSystemDS();

		JdbcDriver jdbcDriver = null;

		Query q = new Query(JdbcDriver.ENT_JDBCDRIVER);

		QueryCriterium qc = new QueryCriterium(JdbcDriver.ENT_JDBCDRIVER, JdbcDriver.FLD_ID, QueryCriterium.OP_EQUALS, driverId);

		qc.setOrIsNull(true);

		q.addQueryCriterium(qc);

		try {

			RecordSet rs = ds.select(q);

			if (rs.next()){

				jdbcDriver = (JdbcDriver)rs.getCurrentObject();

			}

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getJDBCDriverByName()", e);

		}		

		return jdbcDriver;

	}

	public String handleTestDbConnection(DbConnection dbConn){

        // make a param describing the data source

        String     dsName  = dbConn.getName();

        JdbcDriver d       = dbConn.getJdbcDriver();

        String     driver  = (d == null) ? "" : d.getDriver();

        //String     url     = dbConn.getUrl();

        //String     catalog = dbConn.getSchema();

        String     user    = dbConn.getUsername();

        String     pw      = dbConn.getPassword();



        /*JdbcDataSourceParam dsParam = new JdbcDataSourceParam(dsName,

            driver, url, catalog, user, pw);*/

		String wholeUrl = dbConn.getUrl(); // + ":" + dbConn.getSchema();

		JdbcDataSourceParam dsParam = new JdbcDataSourceParam(dsName,

				driver, wholeUrl, user, pw);//catalog, 

        // get/create the data source from Datamanager

        DataSource ds = DataManager.getDataSource(dsParam);



        // test that the connection is valid

        String result = null;

        try {

			ds.testConnection();

			result = CONNECTED;

			

		} catch (DataSourceException e) {

			e.printStackTrace();

			//result = "Driver not supported";

			result = "Could not connect to the database. Check that the JDBC driver and URL are correct and that the database is accessible.";

		}catch (Exception e) {

			e.printStackTrace();

			//result = "Driver not supported";

			result = "Could not connect to the database. Check that the JDBC driver and URL are correct and that the database is accessible.";

		}		

//		DbConnectionTest test = DbConnectionTestFactory.getDbConnectionTest(dbConn.getDriver());

		/*if (test != null){

			String result = test.test(dbConn); 

			if (result == null){

				result = CONNECTED;

			} 

			return result;

		}*/

		return result;

	}

	public ResultWrapper createNewDbConnection(int projectId, DbConnection dbConn) {

		

		//Create JdbcDataSourceDobj from DbConnection

		JdbcDataSourceDobj jdbcDataSourceDobj = new JdbcDataSourceDobj();

		jdbcDataSourceDobj.setName(dbConn.getName());

		//String url = dbConn.getUrl() + ":" + dbConn.getSchema();

		String url = dbConn.getUrl();// + ":" + dbConn.getSchema();

		jdbcDataSourceDobj.setJdbcUrl(url);

		jdbcDataSourceDobj.setJdbcUser(dbConn.getUsername());

		jdbcDataSourceDobj.setJdbcPassword(dbConn.getPassword());

		//jdbcDataSourceDobj.setJdbcCatalog(dbConn.getSchema());

		jdbcDataSourceDobj.setIsMirrored(dbConn.getMirrorred() > 0 ? true : false);

		

		JdbcDriver jdbcDriver = dbConn.getJdbcDriver();//getJdbcDriverByName(dbConn.getDriver());



		jdbcDataSourceDobj.setDriverDobj(jdbcDriver);

		jdbcDataSourceDobj.setJdbcDriverId(jdbcDriver.getId());

		jdbcDataSourceDobj.setProjectId(projectId);



        // get/create the data source from Datamanager

        // create a param defining the datasource

		String wholeUrl = dbConn.getUrl(); // + ":" + dbConn.getSchema();

		JdbcDataSourceParam dsParam = new JdbcDataSourceParam(dbConn.getName(),

        		jdbcDriver.getDriver(), wholeUrl, //dbConn.getSchema(),

        		dbConn.getUsername(), dbConn.getPassword());



        // get/create the datasource

        DataSource _impl = DataManager.getDataSource(dsParam);

		

		//Insert into database

		try {

			jdbcDataSourceDobj.setState(DataObject.NEW);

			jdbcDataSourceDobj.setDelStatus(Constants.MARKED_AS_NOT_DELETED_INT);

			jdbcDataSourceDobj.save();

			int lastInsertId = jdbcDataSourceDobj.getId();

			logger.debug("... schema inserted with connection_id " + lastInsertId);

            

	        Vector tableNames = _impl.importTableNames();

	        // import definition

	        EntitySchemaName esn;

	        EntityDobj ed;

	        // iterate table names

	        // save all entities

	        for(int i = 0; tableNames != null && i < tableNames.size(); i++)

	        {

	            // create the EntityDobj and partially init it with the esn

	            esn = (EntitySchemaName) tableNames.elementAt(i);

	            ed = new EntityDobj();

	            ed.setEsn(esn); 

				

		        Entity importedEnt = null;

		        try

		        {

		            importedEnt = _impl.importEntityDefinition(esn);

		        }

		        catch (DataSourceException e)

		        {

		            e.printStackTrace();

		        	Log.error("DataSourceException when createNewDbConnection(): ", e);

		            return new ResultWrapper(jdbcDataSourceDobj, e.toString());

		        }catch (Exception e) {

		        	return new ResultWrapper(jdbcDataSourceDobj, e.toString());

				}



		        if (importedEnt != null)

		        {

		        	ed.setName(importedEnt.getName());

		        	ed.setFlags(importedEnt.getFlags());

					// if new set keys

		            ed.setDataSourceId (lastInsertId);

		        	

					// save entity/table

		            ed.save ();

					System.out.println("... table inserted with table_id " + ed.getId());

		            logger.debug("... table inserted with table_id " + ed.getId());		        	

		        	

		            // add the FieldDobjs

		            for(int j = 0; importedEnt.getFields() != null && j < importedEnt.getFields().size(); j++)

		            {

		                // create the FieldDobj

		                Field f = (Field) importedEnt.getFields().elementAt(j);

		                FieldDobj fd = new FieldDobj(f);

		                ed.addField(fd);

		                fd.setDsId(lastInsertId);

		                fd.setEntityId(ed.getId());

		                fd.save();

		                //System.out.println("... field inserted with field_id " + fd.getId());

		                logger.debug("... field inserted with field_id " + fd.getId());

		            }

		        }	

		        

			}

	        

	        return new ResultWrapper(jdbcDataSourceDobj, "OK");//getAllDbConnections(projectId);

		} catch (DataSourceException e) {

			e.printStackTrace();

			//throw new MdnException("DataSourceException when createNewDbConnection()", e);

			return new ResultWrapper(jdbcDataSourceDobj, e.toString());

		} catch (Exception e) {

			e.printStackTrace();

			return new ResultWrapper(jdbcDataSourceDobj, e.toString());

		}

	}

	public DbConnection dbConnection(HttpServletRequest request){

	    String idString = request.getParameter("id");

	    int id = idString != null ? Integer.parseInt(idString) : 0;

	    String name = request.getParameter("name");

	    String url = request.getParameter("url");

	    //String schema = request.getParameter("schema");

	    String driverId = request.getParameter("driverId");

	    String username = request.getParameter("username");

	    String password = request.getParameter("password");

	    String mirrorString = request.getParameter("mirrorred");

	    int mirror = 0;

	    if (mirrorString != null){

	    	mirror = mirrorString.equalsIgnoreCase("true") ? 1 : 0;

	    }

	    DbConnection newConn = new DbConnection(id, Integer.parseInt(driverId), name, username, password, url, mirror);

		//Find JdbcDriver

	    JdbcDriver jdbcDriver = null;

		try {

			jdbcDriver = getJdbcDriverById(Integer.parseInt(driverId));

		} catch (MdnException e) {

			jdbcDriver = null;

		}	    

		newConn.setJdbcDriver(jdbcDriver);

	    // Get the DbConnection object.

	    return newConn;

	}	

	

	public List<DataSourceDobj> getAllDbConnections(int projectId) throws MdnException{

        // select all datasources

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(DataSourceDobj.ENT_DATASOURCE);

        QueryCriterium qc = new QueryCriterium(JdbcDataSourceDobj.ENT_DATASOURCE,

            JdbcDataSourceDobj.FLD_IS_MIRROR_DB, QueryCriterium.OP_EQUALS,

            new Boolean(false));

        qc.setOrIsNull(true);

        q.addQueryCriterium(qc);

        

        QueryCriterium qc2 = new QueryCriterium(JdbcDataSourceDobj.ENT_DATASOURCE,

                JdbcDataSourceDobj.FLD_PROJECT_ID, QueryCriterium.OP_EQUALS,

                projectId);

        q.addQueryCriterium(qc2);            

        

        QueryCriterium qc3 = new QueryCriterium(JdbcDataSourceDobj.ENT_DATASOURCE,

                JdbcDataSourceDobj.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS,

                Constants.MARKED_AS_NOT_DELETED_INT);

        q.addQueryCriterium(qc3);   

        

        try {

			RecordSet rs = ds.select(q);

			List<DataSourceDobj> list = new Vector<DataSourceDobj>();

			while (rs.next()){

				DataSourceDobj object = (DataSourceDobj)rs.getCurrentObject();

				list.add(object);

	        }

			return list;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getAllDbConnections()", e);

		}

	}

	

	public List<WebServiceDobj> getAllSampleWebServices() throws MdnException{

        // select all datasources

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(WebServiceDobj.ENT_WEB_SERVICE);

        QueryCriterium qc = new QueryCriterium(WebServiceDobj.ENT_WEB_SERVICE,

        		WebServiceDobj.FLD_TYPE, QueryCriterium.OP_EQUALS,

        		WebServiceDobj.TYPE_SAMPLE);

        qc.setOrIsNull(true);

        q.addQueryCriterium(qc);

        try {

			RecordSet rs = ds.select(q);

			List<WebServiceDobj> list = new Vector<WebServiceDobj>();

			while (rs.next()){

				WebServiceDobj object = (WebServiceDobj)rs.getCurrentObject();

				list.add(object);

	        }

			return list;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getAllSampleWebServices()", e);

		}

	}	



	public List<WebServiceDobj> getAllThirdPartyWebServices() throws MdnException{

        // select all datasources

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(WebServiceDobj.ENT_WEB_SERVICE);

        QueryCriterium qc = new QueryCriterium(WebServiceDobj.ENT_WEB_SERVICE,

        		WebServiceDobj.FLD_TYPE, QueryCriterium.OP_EQUALS,

        		WebServiceDobj.TYPE_THIRDPARTY);

        qc.setOrIsNull(true);

        q.addQueryCriterium(qc);

        try {

			RecordSet rs = ds.select(q);

			List<WebServiceDobj> list = new Vector<WebServiceDobj>();

			while (rs.next()){

				WebServiceDobj object = (WebServiceDobj)rs.getCurrentObject();

				list.add(object);

	        }

			return list;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException when getAllSampleWebServices()", e);

		}

	}		



	public int clearConnection(int projectId, int connectionID){

		try {

			DataSourceDobj sourceDs = getDbConnectionByID(projectId, connectionID);

			sourceDs.setDelStatus(Constants.MARKED_AS_NOT_DELETED_INT);//delete status = 1

			sourceDs.save();

			return 1;

		} catch (MdnException e) {

			e.printStackTrace();

		} catch (DataSourceException e) {

			e.printStackTrace();

		}

		return 0;

	}	

	

	public int recycleConnection(int projectId, int connectionID){

		try {

			DataSourceDobj sourceDs = getDbConnectionByID(projectId, connectionID);

			sourceDs.setDelStatus(Constants.MARKED_AS_RECYCLED_INT);//delete status = 1

			sourceDs.save();

			return 1;

		} catch (MdnException e) {

			e.printStackTrace();

		} catch (DataSourceException e) {

			e.printStackTrace();

		}

		return 0;

	}



	public int deleteConnection(int projectId, int connectionID){

		try {

			DataSourceDobj sourceDs = getDbConnectionByID(projectId, connectionID);

			sourceDs.delete();

			return 1;

		} catch (MdnException e) {

			e.printStackTrace();

		} catch (DataSourceException e) {

			e.printStackTrace();

		}

		return 0;

	}	

	

	public List<EntityDobj> getAllMetaTables(int dbConnectionID, boolean includeFields) throws MdnException{

		// build entity/field join query

		DataSource ds = DataManager.getSystemDS ();

		Query q = new Query (EntityDobj.ENT_ENTITY);

		//q.addQueryEntity (FieldDobj.ENT_FIELD);

		q.addQueryCriterium (new QueryCriterium (EntityDobj.ENT_ENTITY,

			EntityDobj.FLD_DSID, QueryCriterium.OP_EQUALS,

			new Integer (dbConnectionID)));

		//q.addSort (new Sort (EntityDobj.ENT_ENTITY, EntityDobj.FLD_ID));

		//q.addSort (new Sort (FieldDobj.ENT_FIELD, FieldDobj.FLD_ID));

		try {

			RecordSet rs = ds.select (q);

			List<EntityDobj> tables = new Vector<EntityDobj>();

			while (rs != null && rs.next ())

			{

				EntityDobj ent = (EntityDobj)rs.getCurrentObject ();

				tables.add(ent);

			}

			return tables;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getAllMetaTables", e);

		}

	}

	

	public EntityDobj getMetaTableByID(int tableID, boolean includeFields) throws MdnException{

		// build entity/field join query

		DataSource ds = DataManager.getSystemDS ();

		Query q = new Query (EntityDobj.ENT_ENTITY);

		//q.addQueryEntity (FieldDobj.ENT_FIELD);

		q.addQueryCriterium (new QueryCriterium (EntityDobj.ENT_ENTITY,

			EntityDobj.FLD_ID, QueryCriterium.OP_EQUALS,

			new Integer (tableID)));

		RecordSet rs;

		try {

			rs = ds.select (q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getMetaTableByID", e);

		}

		if (rs != null && rs.next ())

		{

			EntityDobj ent = (EntityDobj)rs.getCurrentObject ();

			return ent;

		}

		return null;

	}

	

	public EntityDobj getMetaTableByName(String tableName, int connID, boolean includeFields) throws MdnException{

		// build entity/field join query

		DataSource ds = DataManager.getSystemDS ();

		Query q = new Query (EntityDobj.ENT_ENTITY);

		//q.addQueryEntity (FieldDobj.ENT_FIELD);

		q.addQueryCriterium (new QueryCriterium (EntityDobj.ENT_ENTITY,

			EntityDobj.FLD_NAME, QueryCriterium.OP_EQUALS,

			tableName));

		RecordSet rs;

		try {

			rs = ds.select (q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getMetaTableByID", e);

		}

		if (rs != null && rs.next ())

		{

			EntityDobj ent = (EntityDobj)rs.getCurrentObject ();

			return ent;

		}

		return null;

	}

	public DataView getMetaViewByName(String viewName, int connID) throws MdnException {

		// build entity/field join query

		DataSource ds = DataManager.getSystemDS ();

		

		Query q = new Query(DataView.ENT_DATAVIEW);

        q.addQueryCriterium(new QueryCriterium(DataView.ENT_DATAVIEW,

            DataView.FLD_NAME, QueryCriterium.OP_EQUALS,

            viewName));

        q.addQueryCriterium(new QueryCriterium(DataView.ENT_DATAVIEW,

                DataView.FLD_SOURCE_DSID, QueryCriterium.OP_EQUALS,

                connID));

        RecordSet rs;

		try {

			rs = ds.select (q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getMetaViewByName", e);

		}

		if (rs != null && rs.next ())

		{

			DataView ent = (DataView)rs.getCurrentObject ();

			return ent;

		}

		return null;

	}	

	

	public int editMetaTable(EntityDobj table){

		try {

			table.setState (DataObject.IN_DB);

			table.save();

			return 1;

		} catch (DataSourceException e) {

			e.printStackTrace();

			return -1;

		}

//		// drop table on old name

//        if(ds.isMirrored())

//            dropMirrorTable(ds, oldName);

//

//        // recreate table

//        if(ds.isMirrored())

//            createMirrorTable(ds, ed);

	}

	

	public FieldDobj getMetaField(int fieldID) throws MdnException{

        // build query

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(FieldDobj.ENT_FIELD);

        q.addQueryCriterium(new QueryCriterium(FieldDobj.ENT_FIELD,

            FieldDobj.FLD_ID, QueryCriterium.OP_EQUALS,

            new Integer(fieldID)));

        RecordSet rs;

		try {

			rs = ds.select(q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getMetaField", e);

		}   

		if (rs != null && rs.next ())

		{

			FieldDobj fieldDobj = (FieldDobj)rs.getCurrentObject ();

			return fieldDobj;

		}

		return null;		

	}

	

	public DataSourceDobj getDbConnectionByName(int projectId, String dbConnName) throws MdnException{

        // create query

        DataSource sysDs = DataManager.getSystemDS();

        Query q = new Query(new QueryCriterium(DataSourceDobj.ENT_DATASOURCE,

            DataSourceDobj.FLD_NAME, QueryCriterium.OP_EQUALS, dbConnName));

        

        QueryCriterium qc2 = new QueryCriterium(JdbcDataSourceDobj.ENT_DATASOURCE,

                JdbcDataSourceDobj.FLD_PROJECT_ID, QueryCriterium.OP_EQUALS,

                projectId);

        q.addQueryCriterium(qc2);        

        

        RecordSet rs;

		try {

			rs = sysDs.select(q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getDbConnectionByName", e);

		}

        DataSourceDobj sourceDs = null;

        // get the ds

        if(rs != null && rs.next())

            sourceDs = (DataSourceDobj)rs.getCurrentObject();

        

        return sourceDs;

	}

	

	public DataSourceDobj getDbConnectionByID(int projectId, int connectionID) throws MdnException{

        // create query

        DataSource sysDs = DataManager.getSystemDS();

        Query q = new Query(new QueryCriterium(DataSourceDobj.ENT_DATASOURCE,

            DataSourceDobj.FLD_ID, QueryCriterium.OP_EQUALS, new Integer(connectionID)));

        

        QueryCriterium qc2 = new QueryCriterium(JdbcDataSourceDobj.ENT_DATASOURCE,

                JdbcDataSourceDobj.FLD_PROJECT_ID, QueryCriterium.OP_EQUALS,

                projectId);

        q.addQueryCriterium(qc2);        

        RecordSet rs;

		try {

			rs = sysDs.select(q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getDbConnectionByID", e);

		}

        DataSourceDobj sourceDs = null;

        // get the ds

        if(rs != null && rs.next())

            sourceDs = (DataSourceDobj)rs.getCurrentObject();

        

        return sourceDs;

	}

	

	public MetaDbConnection getDbConnectionByFullUrl(String url, String schema){

		return null;

	}



	

	public Group getGroup(int groupID) throws MdnException {

        DataSource ds = DataManager.getSystemDS();



        Query q1 = new Query(Group.ENT_GROUP);

        QueryCriterium qc1 = new QueryCriterium(Group.ENT_GROUP, Group.FLD_ID,

            QueryCriterium.OP_EQUALS, new Integer(groupID) );

        q1.addQueryCriterium(qc1);

        RecordSet rsGroup;

		try {

			rsGroup = ds.select(q1);

	        if (rsGroup.next())

	        {

	            Group group = (Group)rsGroup.getCurrentObject();

	            return group;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroup()", e);

		}   

        return null;

	}

	

	public Group getGroupByName(String groupName, int projectId) throws MdnException{

        

        DataSource ds = DataManager.getDataSource(Group.ENT_GROUP);

        QueryCriterium qc1 = new QueryCriterium(Group.ENT_GROUP, Group.FLD_NAME,QueryCriterium.OP_EQUALS, groupName );

        QueryCriterium qc2 = new QueryCriterium(Group.ENT_GROUP, Group.FLD_PROJECT_ID,QueryCriterium.OP_EQUALS, projectId );

        Query q = new Query(qc1, qc2);

        RecordSet rsGroup;

		try {

			rsGroup = ds.select(q);

	        if (rsGroup.next())

	        {

	            Group group = (Group)rsGroup.getCurrentObject();

	            return group;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupByName()", e);

		}   

        return null;

	}

	

	public Group getGuestGroup(int projectId) throws MdnException{

        

        DataSource ds = DataManager.getDataSource(Group.ENT_GROUP);

        QueryCriterium qc1 = new QueryCriterium(Group.ENT_GROUP, Group.FLD_GUEST,QueryCriterium.OP_EQUALS, 1);

        QueryCriterium qc2 = new QueryCriterium(Group.ENT_GROUP, Group.FLD_PROJECT_ID,QueryCriterium.OP_EQUALS, projectId );

        Query q = new Query(qc1, qc2);

        RecordSet rsGroup;

		try {

			rsGroup = ds.select(q);

	        if (rsGroup.next())

	        {

	            Group group = (Group)rsGroup.getCurrentObject();

	            return group;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupByName()", e);

		}   

        return null;

	}	

	public GroupMembership getUserGroupByProjectId(int userId, int projectId) throws MdnException{

		DataSource ds = DataManager.getDataSource(GroupMembership.ENT_GROUPMEMBERSHIP);

        QueryCriterium q1 = new QueryCriterium(GroupMembership.ENT_GROUPMEMBERSHIP, GroupMembership.FLD_USERID, QueryCriterium.OP_EQUALS, new Integer(userId));

        QueryCriterium q2 = new QueryCriterium(GroupMembership.ENT_GROUPMEMBERSHIP, GroupMembership.FLD_PROJECT_ID, QueryCriterium.OP_EQUALS, new Integer(projectId));

        Query query = new Query(q1,q2);

        

        // get the results

        RecordSet rs;

		try {

			rs = ds.select(query);

	        // get the user out of the result set

	        if (rs.next())

	        {

	        	GroupMembership group = (GroupMembership) rs.getCurrentObject();

	        	return group;

	        }	

	        return null;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUserGroupByProjectId()", e);

		}

	}



	public List<GroupMembership> getUserGroupByGroupId(int groupId, int projectId) throws MdnException{

		DataSource ds = DataManager.getDataSource(GroupMembership.ENT_GROUPMEMBERSHIP);

        QueryCriterium q1 = new QueryCriterium(GroupMembership.ENT_GROUPMEMBERSHIP, GroupMembership.FLD_GROUPID, QueryCriterium.OP_EQUALS, new Integer(groupId));

        QueryCriterium q2 = new QueryCriterium(GroupMembership.ENT_GROUPMEMBERSHIP, GroupMembership.FLD_PROJECT_ID, QueryCriterium.OP_EQUALS, new Integer(projectId));

        Query query = new Query(q1,q2);

        

        // get the results

        RecordSet rs;

        Vector<GroupMembership> groupsMembership = new Vector<GroupMembership>();

		try {

			rs = ds.select(query);

	        // get the user out of the result set

			while (rs.next())

	        {

	        	GroupMembership group = (GroupMembership) rs.getCurrentObject();

	        	//return group;

	        	groupsMembership.add(group);

	        }	

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUserGroupByProjectId()", e);

		}

		return groupsMembership;

	}

	

	public Vector<Group> getGroups(int projectId) throws MdnException{

        // select all groups

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(new QueryCriterium(Group.ENT_GROUP, Group.FLD_PROJECT_ID,

                QueryCriterium.OP_EQUALS, projectId ));

        RecordSet rsGroup;

        Vector<Group> groups = new Vector<Group>();

        try {

			rsGroup = ds.select(q);

	        while (rsGroup.next())

	        {

	            Group group = (Group)rsGroup.getCurrentObject();

	            if(group.getDelStatus()!= null && group.getDelStatus().equals(Constants.MARKED_AS_NOT_DELETED))

	            groups.add(group);

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroups()", e);

		}

        return groups;

	}



	public int saveGroup(Group group) throws MdnException {

		try {

			group.setDelStatus(Constants.MARKED_AS_NOT_DELETED);

			group.save();

			return group.getId();

		} catch (DataSourceException e) {

			e.printStackTrace();

			//throw new MdnException("DataSourceException in saveGroup", e);

			return 0;

		}

	}

	

	public List<GroupDataView> getGroupViewsPermissions(int groupID) throws MdnException

	{

		DataSource ds = DataManager.getSystemDS();

		Query q = new Query(GroupDataView.ENT_GROUPDATAVIEW);

        QueryCriterium qc = new QueryCriterium(GroupDataView.ENT_GROUPDATAVIEW, GroupDataView.FLD_GROUPID,

            QueryCriterium.OP_EQUALS, groupID );

        q.addQueryCriterium(qc);

        Vector<GroupDataView> groupViews = new Vector<GroupDataView>();

        try {

			RecordSet rsGroupDataView = ds.select(q);

			while(rsGroupDataView.next())

            {

            	GroupDataView dobj = (GroupDataView)rsGroupDataView.getCurrentObject();

            	groupViews.add(dobj);

            }			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupViewsPermissions()", e);

		}

		return groupViews;

	}

	

	public List<GroupTablePermission> getGroupTablePermissions(int groupID) throws MdnException

	{

		DataSource ds = DataManager.getSystemDS();

		Query q = new Query(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION);

        QueryCriterium qc = new QueryCriterium(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION, GroupTablePermission.FLD_GROUPID,

            QueryCriterium.OP_EQUALS, groupID );

        q.addQueryCriterium(qc);

        Vector<GroupTablePermission> groupTables = new Vector<GroupTablePermission>();

        try {

			RecordSet rsGroupDataView = ds.select(q);

			while(rsGroupDataView.next())

            {

				GroupTablePermission tablPermission = (GroupTablePermission)rsGroupDataView.getCurrentObject();

				groupTables.add(tablPermission);

            }			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupTablePermissions()", e);

		}

		return groupTables;

	}

	

	public GroupTablePermission getGroupTablePermissionByEntityID(int entityId,int groupID) throws MdnException{  

        DataSource ds = DataManager.getSystemDS();

        Query q = new Query(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION);

        

        QueryCriterium qc = new QueryCriterium(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION, GroupTablePermission.FLD_ENTITY_ID, QueryCriterium.OP_EQUALS, entityId);

        QueryCriterium qc2 = new QueryCriterium(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION, GroupTablePermission.FLD_GROUPID,QueryCriterium.OP_EQUALS, groupID );



        q.addQueryCriterium(qc);

        q.addQueryCriterium(qc2);            

        

		try {

			RecordSet rsGroupTablePermission = ds.select(q);

	        if (rsGroupTablePermission.next())

	        {

	        	GroupTablePermission groupTblPermission = (GroupTablePermission)rsGroupTablePermission.getCurrentObject();

	            return groupTblPermission;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupTablePermissionByEntityID()", e);

		}   

        return null;

	}

	

	public int saveGroupDataView(GroupDataView groupDataView) throws MdnException

	{

		int groupFieldId = 0;

		try {

			groupDataView.save();

			groupFieldId = groupDataView.getId();

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in saveGroupDataViews", e);

		}

		return groupFieldId;

	}



	public void deleteGroupDataView(GroupDataView groupDataView) throws MdnException {

        try {

        	groupDataView.delete();

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in groupDataView", e);

		}

	}



	public Vector<GroupDataView> getGroupDataViewByFieldID(int groupDataViewId) throws MdnException{

        // create query

        DataSource sysDs = DataManager.getSystemDS();

        Query q = new Query(new QueryCriterium(GroupDataView.ENT_GROUPDATAVIEW,

        		GroupDataView.FLD_DATAVIEWID, QueryCriterium.OP_EQUALS, new Integer(groupDataViewId)));

        RecordSet rs;

		try {

			rs = sysDs.select(q);

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupDataViewByID", e);

		}

		Vector<GroupDataView> GroupDataViews = new Vector<GroupDataView>();

        // get the ds

        if(rs != null && rs.next())

        {

        	GroupDataView dobj = (GroupDataView)rs.getCurrentObject();

        	GroupDataViews.add(dobj);

        }

        

        return GroupDataViews;

	}

	public GroupDataView getGroupDataViewByGroupID(int groupId) throws MdnException{

        DataSource ds = DataManager.getSystemDS();



        Query q1 = new Query(GroupDataView.ENT_GROUPDATAVIEW);

        QueryCriterium qc1 = new QueryCriterium(GroupDataView.ENT_GROUPDATAVIEW, GroupDataView.FLD_GROUPID,

            QueryCriterium.OP_EQUALS, new Integer(groupId) );

        q1.addQueryCriterium(qc1);

        RecordSet rsGroup;

		try {

			rsGroup = ds.select(q1);

	        if (rsGroup.next())

	        {

	        	GroupDataView group = (GroupDataView)rsGroup.getCurrentObject();

	            return group;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroup()", e);

		}   

        return null;

	}

	 public GroupDataView getGroupDataViewByID(int id) throws MdnException{

	        DataSource ds = DataManager.getSystemDS();



	        Query q1 = new Query(GroupDataView.ENT_GROUPDATAVIEW);

	        QueryCriterium qc1 = new QueryCriterium(GroupDataView.ENT_GROUPDATAVIEW, GroupDataView.FLD_ID,

	            QueryCriterium.OP_EQUALS, new Integer(id) );

	        q1.addQueryCriterium(qc1);

	        RecordSet rsGroup;

			try {

				rsGroup = ds.select(q1);

		        if (rsGroup.next())

		        {

		        	GroupDataView group = (GroupDataView)rsGroup.getCurrentObject();

		            return group;

		        }  			

			} catch (DataSourceException e) {

				e.printStackTrace();

				throw new MdnException("DataSourceException in getGroup()", e);

			}   

	        return null;

		 

	 }

	 

	 public GroupTablePermission getGroupTablePermissionByID(int id) throws MdnException {

        DataSource ds = DataManager.getSystemDS();



        Query q1 = new Query(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION);

        QueryCriterium qc1 = new QueryCriterium(GroupTablePermission.ENT_GROUP_ENTITY_PERMISSION, GroupTablePermission.FLD_ID,

            QueryCriterium.OP_EQUALS, new Integer(id) );

        q1.addQueryCriterium(qc1);

        RecordSet rsGroup;

		try {

			rsGroup = ds.select(q1);

	        if (rsGroup.next())

	        {

	        	GroupTablePermission groupTablePermission = (GroupTablePermission)rsGroup.getCurrentObject();

	            return groupTablePermission;

	        }  			

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getGroupTablePermissionByID()", e);

		}   

        return null;		 

	 }



	 public Vector<FieldExclusion> getFieldExclusion(int groupID) throws MdnException{

		DataSource ds = DataManager.getSystemDS();

        Query q2 = new Query(FieldExclusion.ENT_FIELDEXCLUSION);

        QueryCriterium qc1 = new QueryCriterium(FieldExclusion.ENT_FIELDEXCLUSION,

            FieldExclusion.FLD_GROUPID,

            QueryCriterium.OP_EQUALS,

            groupID );

        q2.addQueryCriterium(qc1);

        Vector<FieldExclusion> fieldExclusions = new Vector<FieldExclusion>();

        try {

			RecordSet rsFieldExclusion = ds.select(q2);

			while(rsFieldExclusion.next())

            {

				FieldExclusion dobj = (FieldExclusion)rsFieldExclusion.getCurrentObject();

				fieldExclusions.add(dobj);

            }

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getFieldExclusion()", e);

		}

		return fieldExclusions;

	}

	

	public int markGroupAsCleared(int groupID) throws MdnException{

		try {

			//get group by id

			Group group = getGroup(groupID);

			group.setDelStatus(Constants.MARKED_AS_NOT_DELETED);//delete status = 1

			group.save();

			return group.getId();

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in markGroupAsCleared", e);

		}

	}

	

	public int markGroupAsRecycled(int groupID) throws MdnException{

		try {

			//get group by id

			Group group = getGroup(groupID);

			group.setDelStatus(Constants.MARKED_AS_RECYCLED);//delete status = 1

			group.save();

			return group.getId();

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in markGroupAsDeleted", e);

		}

	}

	

	public User getUserByName(String username) throws MdnException {

        DataSource ds = DataManager.getDataSource(User.ENT_USER);



        // create the query for user on username

        Query query = new Query(new QueryCriterium(User.ENT_USER, User.FLD_NAME, QueryCriterium.OP_EQUALS, username));

        // get the results

        RecordSet rs;

		try {

			rs = ds.select(query);

	        // get the user out of the result set

	        if (rs.next())

	        {

	        	User user = (User) rs.getCurrentObject();

	        	return user;

	        }	

	        return null;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUserByName()", e);

		}

	}



	public Vector<User> getAdminUsers() throws MdnException {

        RecordSet  rs;

        DataSource ds = DataManager.getDataSource(User.ENT_USER);

        QueryCriterium q1 = new QueryCriterium(User.ENT_USER, User.FLD_PRIVILEGE, QueryCriterium.OP_EQUALS, "ADMIN");

        QueryCriterium q2 = new QueryCriterium(User.ENT_USER, User.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS, "0");

        Query query = new Query(q1,q2);

        Vector<User> users = new Vector<User>();

        try {

			rs    = ds.select(query);

	        while (rs.next())

	        {

	            User user = (User) rs.getCurrentObject();

	            String userStatus = user.getDelStatus();

	            if(userStatus == null || userStatus.equals(Constants.MARKED_AS_NOT_DELETED))

	            	users.add(user);

	        }

        } catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUsers()", e);

		}



        return users;

	}

	

	public User getUserByMobileNumber(String mobileNumber) throws MdnException{

		DataSource ds = DataManager.getDataSource(User.ENT_USER);



        // create the query for user on username

        //Query query = new Query(new QueryCriterium(User.ENT_USER, User.FLD_MOBILE, QueryCriterium.OP_EQUALS, mobileNumber));

        

        QueryCriterium q1 = new QueryCriterium(User.ENT_USER, User.FLD_MOBILE, QueryCriterium.OP_EQUALS, mobileNumber);

        QueryCriterium q2 = new QueryCriterium(User.ENT_USER, User.FLD_DEL_STATUS, QueryCriterium.OP_EQUALS, "0");

        Query query = new Query(q1,q2);

        

        // get the results

        RecordSet rs;

		try {

			rs = ds.select(query);

	        // get the user out of the result set

	        if (rs.next())

	        {

	        	User user = (User) rs.getCurrentObject();

	        	return user;

	        }	

	        return null;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUserByMobileNumber()", e);

		}

	}



	public UserWrapper getLoginUser(String username, String password) throws MdnException{

		return SecurityManager.login(username, password);

	}



	public UserWrapper getLoginUser(String username) throws MdnException{

		return SecurityManager.getLoginUserByName(username);

	}	

	

	public int isLicenseValid (){

		int rvLicense = LicenseManager.isLicenseValid ();

		return rvLicense;

	}

	

	public User getUser(int userID, boolean includeGroups) throws MdnException{

        // perform a query to find the user

        // get the data source for querying

        DataSource ds = DataManager.getDataSource(User.ENT_USER);



        // create the query for user on username

        Query query = new Query(new QueryCriterium(User.ENT_USER, User.FLD_ID,

            QueryCriterium.OP_EQUALS, userID));

        // get the results

        RecordSet rs;

		try {

			rs = ds.select(query);

	        // get the user out of the result set

	        if (rs.next())

	        {

	        	User user = (User) rs.getCurrentObject();

	        	return user;

	        }	

	        return null;

		} catch (DataSourceException e) {

			e.printStackTrace();

			throw new MdnException("DataSourceException in getUser()", e);

		}

	}

	

	/*

	 * Get users list from DB when users status deleted are not recycled status. 

	 */

	public Vector<User> getUsers() throws MdnException {

        DataSource ds;

        Query      query;

        RecordSet  rs;

		ds    = DataManager.getDataSource(User.ENT_USER);

		query = new Query(User.ENT_USER);

//        query = new Query(new QueryCriterium(User.ENT_USER, User.FLD_PROJECT_ID,

//                QueryCriterium.OP_EQUALS, projectId));

        Vector<User> u…