string _query = @"SELECT  EmpQual.EMP_ID,EmpQual.QLF_ID,Ins.IST_ID,EmpQual.EQL_SEQUENCENO,EmpQual.ACTION_TAG,
                            EmpQual.EQL_MAJOR, EmpQual.EQL_MINOR, EmpQual.EQL_PASSOUT, EmpQual.EQL_RESULT,EmpQual.EQL_REMARKS, Qual.QLF_TITLE,
                            INS.IST_NAME, Emp.EMP_FIRSTNAME, Emp.EMP_CODE, Emp.EMP_FATHERNAME, Emp.EMP_LASTNAME,EmpQual.REF_NO,
                            'Actual' status_
                            FROM  SETUP_EMP_QUALIFICATION  EmpQual 
                            INNER JOIN SETUP_QUALIFICATION  Qual ON EmpQual.QLF_ID = Qual.QLF_ID 
                            INNER JOIN SETUP_INSTITUTE  Ins ON EmpQual.IST_ID = Ins.IST_ID 
                            INNER JOIN SETUP_EMPLOYEE  Emp ON EmpQual.EMP_ID = Emp.EMP_ID
                            where EmpQual.EMP_ID = '" + _id.ToString() + @"' AND ( EmpQual.ACTION_TAG='Approve')
                            union

                            SELECT  EmpQual.EMP_ID,EmpQual.QLF_ID,Ins.IST_ID,EmpQual.EQL_SEQUENCENO,EmpQual.ACTION_TAG,
                            EmpQual.EQL_MAJOR, EmpQual.EQL_MINOR, EmpQual.EQL_PASSOUT, EmpQual.EQL_RESULT,EmpQual.EQL_REMARKS, Qual.QLF_TITLE,
                            INS.IST_NAME, Emp.EMP_FIRSTNAME, Emp.EMP_CODE, Emp.EMP_FATHERNAME, Emp.EMP_LASTNAME,EmpQual.REF_NO,
                            'Pending' status_ 
                            FROM  SETUP_EMP_QUAL_PENDING  EmpQual 
                            INNER JOIN SETUP_QUALIFICATION  Qual ON EmpQual.QLF_ID = Qual.QLF_ID 
                            INNER JOIN SETUP_INSTITUTE  Ins ON EmpQual.IST_ID = Ins.IST_ID 
                            INNER JOIN SETUP_EMPLOYEE  Emp ON EmpQual.EMP_ID = Emp.EMP_ID
                            where EmpQual.EMP_ID = '" + _id.ToString() + @"'";