package inventorysystem.data;

import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JPanel;
import interfaces.Switchable;

/**
 *Login Class to login user into system
 * @author Epic
 */
public class Login {
    private DBConnectionClass connectionClass;
    public Login(){
        connectionClass = new DBConnectionClass();
    }
    /**
     * if user credential is a valid one then return an
     * employee object for that user.
     * @param username
     * @param password
     * @param panelSwitch if login is sucessfully then switch to next panel
     * @return Employee object
     */
    public  Employee isUser(String username, String password){
        
        Employee employee = null;
        try {
            Statement s = this.connectionClass.getConnection().createStatement();
            ResultSet rs = s.executeQuery("SELECT * FROM employees WHERE username = '"+username+"' AND password = '"+password+"'");
            if(rs.first()){
                employee =  new Employee(rs.getString("first_name").concat(" ").concat(rs.getString("last_name")),
                        rs.getString("username"), 
                        rs.getInt("employee_id"), 
                        rs.getString("gender"), 
                        rs.getString("birth_date"), 
                        rs.getString("address"));
                
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return employee;
    }
    
}