/**
    * Copyright 2011 The Kuali Foundation Licensed under the
    * Educational Community License, Version 2.0 (the "License"); you may
    * not use this file except in compliance with the License. You may
    * obtain a copy of the License at
    *
    * http://www.osedu.org/licenses/ECL-2.0
    *
    * Unless required by applicable law or agreed to in writing,
   * software distributed under the License is distributed on an "AS IS"
   * BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
   * or implied. See the License for the specific language governing
   * permissions and limitations under the License.
   */
  
  package org.kuali.mobility.push.dao;
  
  import java.util.List;
  
  import javax.persistence.EntityManager;
  import javax.persistence.PersistenceContext;
  import javax.persistence.Query;
  
  import org.kuali.mobility.push.entity.Preference;
  import org.kuali.mobility.push.entity.Sender;
  import org.springframework.stereotype.Repository;
  
  /**
   * Implementation of the Preference Data Access Object.
   * 
   * @author Kuali Mobility Team (mobility.dev@kuali.org)
   * @since 2.0.0
   */
  @Repository
  public class PreferenceDaoImpl implements PreferenceDao{
  
  	/** A reference to a logger */
  	private static final org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(PreferenceDaoImpl.class);		
  	
  
  	@PersistenceContext
      private EntityManager entityManager;
  	
  	/**
  	 * Creates new instance of the <code>PreferenceDaoImpl</code>.
  	 */
      public PreferenceDaoImpl(){}
  
  	/*
  	 * (non-Javadoc)
  	 * @see org.kuali.mobility.push.dao.PreferenceDao#findPreferencesByUsername(java.lang.String)
  	 */
  	public List<Preference> findPreferencesByUsername(String username){
          Query query = entityManager.createQuery("select p from Preference p where p.username = :username");
          query.setParameter("username", username);
  
  		return query.getResultList();
  	}
  
  	/*
  	 * (non-Javadoc)
  	 * @see org.kuali.mobility.push.dao.PreferenceDao#findPreference(java.lang.String, java.lang.String)
  	 */
  	public Preference findPreference(String username, String shortName){
  //		Sender sender = null;
  //		try {
  //			Query query = entityManager.createQuery("select s from Sender s where s.shortName = :shortName");
  //	        query.setParameter("shortName", shortName);
  //			sender = (Sender)query.getSingleResult();
  //
  //		} catch (Exception e1) {
  //			LOG.info("query.getSingleResult in findPreference failed to return a specific Sender.");
  //			return null;
  //		}
  //      Query query = entityManager.createQuery("select p from Preference p where p.username = :username and p.pushSenderID = :senderId");
  //        Query query = entityManager.createQuery("select p from Preference p where p.username = :username and p.pushSenderID = (select s.id from Sender s where s.shortName = :shortName)");
  		Query query = getEntityManager().createNamedQuery("Preference.findPreferenceWithUsernameAndShortname");
  
          query.setParameter("username", username);
          query.setParameter("shortName", shortName);
  //      query.setParameter("senderId", sender.getId());
          Preference result; 
          try{
          	result = (Preference) query.getSingleResult();
          }catch(Exception e){
          	LOG.info("No Preference Found: " + username + ", " + shortName);
          	result = null;
          }	
          return result;
  	}
  	
  	/*
  	 * (non-Javadoc)
  	 * @see org.kuali.mobility.push.dao.PreferenceDao#findPreference(java.lang.String, org.kuali.mobility.push.entity.Sender)
  	 */
  	public Preference findPreference(String username, Sender sender){
  				
          Query query = entityManager.createQuery("select p from Preference p where p.username = :username and p.pushSenderID = :senderId");
          query.setParameter("username", username);
         query.setParameter("senderId", sender.getId());
         LOG.info(username + " & " + sender.getId());
         Preference result; 
         try{
         	result = (Preference) query.getSingleResult();
         }catch(Exception e){
         	LOG.info("No Preference Found: " + username + ", " + sender.getShortName());
         	result = null;
         }	
         return result;
 	}
 	
 	/*
 	 * (non-Javadoc)
 	 * @see org.kuali.mobility.push.dao.PreferenceDao#findPreference(long)
 	 */
 	public Preference findPreference(long id){
         Query query = entityManager.createQuery("select p from Preference p where p.id = :id");
         query.setParameter("id", id);
 
         Preference result; 
         try{
         	result = (Preference) query.getSingleResult();
         }catch(Exception e){
         	LOG.info("Exception: " + e.getMessage());
         	result = null;
         }	
         return result;
 		
 	}
 
 	/*
 	 * (non-Javadoc)
 	 * @see org.kuali.mobility.push.dao.PreferenceDao#setPreference(org.kuali.mobility.push.entity.Preference, boolean)
 	 */
 	public void setPreference(Preference preference, boolean enabled ){
 		if(preference == null){
     		return;
     	}
     	if(preference.getId() == null){
     		LOG.info("persist");
     		entityManager.persist(preference);
     	}else{
     		LOG.info("merge");
     		preference.setEnabled(enabled);
     		entityManager.merge(preference);
     	}
 	}
 
 	/*
 	 * (non-Javadoc)
 	 * @see org.kuali.mobility.push.dao.PreferenceDao#savePreference(org.kuali.mobility.push.entity.Preference)
 	 */
 	public void savePreference(Preference preference){
 		if(preference == null){
     		return;
     	}
     	if(preference.getId() == null){
     		LOG.info("persist");
     		entityManager.persist(preference);
     	}else{
     		LOG.info("merge");
     		entityManager.merge(preference);
     	}
 	}	
 	
 	/*
 	 * (non-Javadoc)
 	 * @see org.kuali.mobility.push.dao.PreferenceDao#removePreference(org.kuali.mobility.push.entity.Preference)
 	 */
     @SuppressWarnings("unchecked")
     public boolean removePreference(Preference preference){
     	LOG.info("PreferenceDaoImpl.removePreference");
     	boolean result = true;
     	if(preference == null){
         	LOG.info("PreferenceDaoImpl.removePreference null");
     		return false;
     	}
     	if(preference.getId() != null){
         	LOG.info("PreferenceDaoImpl.removePreference ! null");
     		try{
     			Preference p = entityManager.find(Preference.class, preference.getId());
     			entityManager.remove(p);
     	    	LOG.info("PreferenceDaoImpl.removePreference : remove(p)");
     		}catch(Exception e){
     			LOG.info("Exception Caught: " + e.getMessage());
     			result = false;
     		}
     	}else{
     		result = false;
     	}
     	LOG.info("PreferenceDaoImpl.removePreference " + (result ? "true":"false") );
     	return result;
     }
 	
 	/** A reference to the <code>EntityManager</code> */ /**
 	 * Returns the reference to the <code>EntityManager</code>
 	 * @return The reference to the <code>EntityManager</code>
 	 */
     public EntityManager getEntityManager() {
         return entityManager;
     }
 
 	/**
 	 * Sets the reference to the <code>EntityManager</code>
 	 * @param entityManager The reference to the <code>EntityManager</code>
 	 */
     public void setEntityManager(EntityManager entityManager) {
         this.entityManager = entityManager;
     }
 }