package com.reallinkbilling.update;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.resource.CheckOldPasswordCorrect;

public class ChangePassword extends ActionSupport implements SessionAware{
/**
	 * 
	 */
	private static final long serialVersionUID = 5991522839988676165L;
	private SessionMap<String,Object> sessionMap;
	private String oldPassword;
	private String newPassword;
	private String confirmPassword;
	private String addSideBarJs;
	
	public String execute(){
		
		String result = "login";
		   if(this.getSessionMap()==null || this.getSessionMap().get("login")==null){ 
			   addActionMessage("Please Login First !!!");
	        	result = "login";
	        }  
	        else{
	        	String shopId = (String) this.getSessionMap().get("shopId");
	    		String shopCode = (String) this.getSessionMap().get("shopCode");
	    		
	        	Connection connection = null;
	    		PreparedStatement preparedStatement= null;
	    		ResultSet resultSet = null;
	    		
	    		String sql = "";
	    		String db = (String) this.getSessionMap().get("db");
	    		
	    			try
	    			{
	    				
	    				String userNameS = (String) this.getSessionMap().get("userFullName");
	    				connection = GetDBConnection.getDBConnection(db);
	    				
	    				sql = "UPDATE "
	    						+ "shop_user_master "
	    						+ "SET "
	    						+ "shop_user_password_1 = ? "
	    						+ "WHERE "
	    						+ "shop_user_full_name = ? "
	    						+ "AND "
	    						+ "shop_user_password_1 = ? "
	    						+ "AND "
								+ "shop_id = ? "
								+ "AND "
								+ "shop_code = ? ";

	    				
	    				preparedStatement = connection.prepareStatement(sql);
	    				
	    				preparedStatement.setString(1, EncryptionDecryption.encrypt(this.getNewPassword().trim()));
	    				preparedStatement.setString(2, userNameS);
	    				preparedStatement.setString(3, EncryptionDecryption.encrypt(this.getOldPassword().trim()));
	    				preparedStatement.setString(4, shopId);
						preparedStatement.setString(5, shopCode);

	    				int updatedCount = preparedStatement.executeUpdate();
	    				
	    				if(updatedCount>0)
	    				{
	    					this.getSessionMap().invalidate();
	    					result = LOGIN;
	    					addActionMessage("Password Changed Successfully !");
	    				}
	    				else
	    				{
	    					result = ERROR;
	    					
	    					addActionError("Could't Update Password Please Try Again !");
	    				}
	    				
	    			} catch (SQLException e) {
	    				e.printStackTrace();
	    				result = ERROR;
	    				
	    			} catch (Exception e) {
	    				e.printStackTrace();
	    				
	    				result = ERROR;
	    			}finally {
	    				if(resultSet != null)
	    				{
	    					try {
	    						resultSet.close(); resultSet = null;
	    					} catch (SQLException e) {
	    						
	    					}
	    				}
	    				if(preparedStatement != null)
	    				{
	    					try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
	    				}
	    				if(connection != null)
	    				{
	    					
	    					try {connection.close(); connection = null;}catch (SQLException e) {}
	    				}
	    				
	    			}
	    		
	        	
	        	
	        	
	        }
		   
		   return result;
}
	        
	@Override
		public void validate() {
		this.setAddSideBarJs("FALSE");
	    
		if(this.getOldPassword() == null || this.getOldPassword().equals("")){
			addActionError("Please Provide Old Password!");
		}
		
		if(!hasActionErrors())
		{
			if(this.getNewPassword() == null || this.getNewPassword().equals(""))
			{
				addActionError("Please Provide New Password!");
			}
		}
		
		
		if(!hasActionErrors())
		{
			if(this.getConfirmPassword() == null || this.getConfirmPassword().equals(""))
			{
				
				addActionError("Please Provide Confirm Password!");
			}
		}
		
		
		if(!hasActionErrors())
		{
			String userNameS = (String) this.getSessionMap().get("userFullName");
			String encryptedPass = EncryptionDecryption.encrypt(this.getOldPassword());
			boolean oldPasswordCorrect = CheckOldPasswordCorrect.getOldPasswordCorrect(userNameS, encryptedPass, this.getSessionMap());
			
			if(!oldPasswordCorrect)
			{
				addActionError("old Password Does Not Match Please Provide Correct Old Password!");
			
			}
			
			
		}
		
		
		if(!this.getNewPassword().trim().equals(this.getConfirmPassword().trim()))
		{
			addActionError("new Password And Confirm Password Does Not Match!");
		}
	}
	
	public String getAddSideBarJs() {
		return addSideBarJs;
	}

	public void setAddSideBarJs(String addSideBarJs) {
		this.addSideBarJs = addSideBarJs;
	}

	public String getOldPassword() {
		return oldPassword;
	}


	public void setOldPassword(String oldPassword) {
		this.oldPassword = oldPassword;
	}


	public String getNewPassword() {
		return newPassword;
	}


	public void setNewPassword(String newPassword) {
		this.newPassword = newPassword;
	}


	public String getConfirmPassword() {
		return confirmPassword;
	}


	public void setConfirmPassword(String confirmPassword) {
		this.confirmPassword = confirmPassword;
	}


	public static long getSerialversionuid() {
		return serialVersionUID;
	}


	@Override  
	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}



	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}
}
