public void FillPromotionsToGrid() { string sqlText = ""; DataTable dt = new DataTable(); //objDB = new SQLDB(); objHRInfo = new HRInfo(); gvPromotiomDetl.Rows.Clear(); string sBranch = "", sPBType = "", sDetlType = ""; if (iFormType == 1) { sDetlType = "AGENT_APPROVAL"; } else { if (cmbPBType.SelectedIndex == 0 && cmbRepToBranch.SelectedIndex == 0) { //sqlText = "SELECT HESS_TRXN_NO,HESS_LTR_REF_NO,HESS_APPL_NUMBER,HESS_EORA_CODE,MEMBER_NAME,HESS_TO_BRANCH_CODE,HESS_PROMOTION_CATEGORY_CODE" + // ",HPCM_PROMOTION_CATEGORY_NAME,HESS_BASIC,HESS_HRA,HESS_CCA,HESS_CONV_ALW,HESS_LTA_ALW,HESS_SPL_ALW,HESS_TO_COMPANY_CODE,HESS_UNF_ALW" + // ",HESS_VEH_ALW,HESS_CH_ED_ALW,HESS_BNP_ALW,HESS_MED_REIMB,HESS_PET_ALW,(HESS_BASIC+HESS_HRA+HESS_CCA+HESS_CONV_ALW+" + // "HESS_LTA_ALW+HESS_SPL_ALW+HESS_UNF_ALW+HESS_VEH_ALW+HESS_CH_ED_ALW+HESS_BNP_ALW+HESS_MED_REIMB+HESS_PET_ALW) HESS_GROSS_SAL" + // ",HESS_EFF_DATE,ISNULL(elevel_id,0) ELEVEL_ID,HESS_DESIG_ID,HESS_TO_DEPT_ID,desig_name FROM HR_EMP_SAL_STRU INNER JOIN EORA_MASTER ON ECODE = HESS_EORA_CODE INNER JOIN HR_PROMOTION_CATEGORY_MASTER " + // "ON HPCM_PROMOTION_CATEGORY_CODE = HESS_PROMOTION_CATEGORY_CODE LEFT JOIN LevelsDesig_mas ON ldm_company_code = HESS_TO_COMPANY_CODE AND LDM_DESIG_ID = HESS_DESIG_ID INNER JOIN DESIG_MAS ON desig_code = HESS_DESIG_ID " + // "WHERE HESS_APPR_STATUS='P' ORDER BY HESS_EFF_DATE ASC"; sDetlType = "ALL"; } else if (cmbPBType.SelectedIndex > 0 && cmbRepToBranch.SelectedIndex == 0) { //sqlText = "SELECT HESS_TRXN_NO,HESS_LTR_REF_NO,HESS_APPL_NUMBER,HESS_EORA_CODE,MEMBER_NAME,HESS_TO_BRANCH_CODE,HESS_PROMOTION_CATEGORY_CODE" + // ",HPCM_PROMOTION_CATEGORY_NAME,HESS_BASIC,HESS_HRA,HESS_CCA,HESS_CONV_ALW,HESS_LTA_ALW,HESS_SPL_ALW,HESS_TO_COMPANY_CODE,HESS_UNF_ALW" + // ",HESS_VEH_ALW,HESS_CH_ED_ALW,HESS_BNP_ALW,HESS_MED_REIMB,HESS_PET_ALW,(HESS_BASIC+HESS_HRA+HESS_CCA+HESS_CONV_ALW+"+ // "HESS_LTA_ALW+HESS_SPL_ALW+HESS_UNF_ALW+HESS_VEH_ALW+HESS_CH_ED_ALW+HESS_BNP_ALW+HESS_MED_REIMB+HESS_PET_ALW) HESS_GROSS_SAL"+ // ",HESS_EFF_DATE,ISNULL(elevel_id,0) ELEVEL_ID,HESS_DESIG_ID,HESS_TO_DEPT_ID,desig_name FROM HR_EMP_SAL_STRU INNER JOIN EORA_MASTER ON ECODE = HESS_EORA_CODE INNER JOIN HR_PROMOTION_CATEGORY_MASTER " + // "ON HPCM_PROMOTION_CATEGORY_CODE = HESS_PROMOTION_CATEGORY_CODE LEFT JOIN LevelsDesig_mas ON ldm_company_code = HESS_TO_COMPANY_CODE AND LDM_DESIG_ID = HESS_DESIG_ID INNER JOIN DESIG_MAS ON desig_code = HESS_DESIG_ID WHERE HESS_APPR_STATUS='P' " + // "AND HESS_PROMOTION_CATEGORY_CODE='" + cmbPBType.SelectedValue + "' ORDER BY HESS_EFF_DATE ASC"; sPBType = cmbPBType.SelectedValue.ToString(); sDetlType = "BYCAT"; } else if (cmbPBType.SelectedIndex > 0 && cmbRepToBranch.SelectedIndex > 0) { //sqlText = "SELECT HESS_TRXN_NO,HESS_LTR_REF_NO,HESS_APPL_NUMBER,HESS_EORA_CODE,MEMBER_NAME,HESS_TO_BRANCH_CODE,HESS_PROMOTION_CATEGORY_CODE" + // ",HPCM_PROMOTION_CATEGORY_NAME,HESS_BASIC,HESS_HRA,HESS_CCA,HESS_CONV_ALW,HESS_LTA_ALW,HESS_SPL_ALW,HESS_TO_COMPANY_CODE,HESS_UNF_ALW" + // ",HESS_VEH_ALW,HESS_CH_ED_ALW,HESS_BNP_ALW,HESS_MED_REIMB,HESS_PET_ALW,(HESS_BASIC+HESS_HRA+HESS_CCA+HESS_CONV_ALW+" + // "HESS_LTA_ALW+HESS_SPL_ALW+HESS_UNF_ALW+HESS_VEH_ALW+HESS_CH_ED_ALW+HESS_BNP_ALW+HESS_MED_REIMB+HESS_PET_ALW) HESS_GROSS_SAL" + // ",HESS_EFF_DATE,ISNULL(elevel_id,0) ELEVEL_ID,HESS_DESIG_ID,HESS_TO_DEPT_ID,desig_name FROM HR_EMP_SAL_STRU INNER JOIN EORA_MASTER ON ECODE = HESS_EORA_CODE INNER JOIN HR_PROMOTION_CATEGORY_MASTER " + // "ON HPCM_PROMOTION_CATEGORY_CODE = HESS_PROMOTION_CATEGORY_CODE LEFT JOIN LevelsDesig_mas ON ldm_company_code = HESS_TO_COMPANY_CODE AND LDM_DESIG_ID = HESS_DESIG_ID INNER JOIN DESIG_MAS ON desig_code = HESS_DESIG_ID WHERE HESS_APPR_STATUS='P' " + // "AND HESS_PROMOTION_CATEGORY_CODE='" + cmbPBType.SelectedValue + "' AND HESS_FROM_BRANCH_CODE = '" + cmbRepToBranch.SelectedValue + // "' ORDER BY HESS_EFF_DATE ASC"; sPBType = cmbPBType.SelectedValue.ToString(); sBranch = cmbRepToBranch.SelectedValue.ToString(); sDetlType = "BYCATBR"; } else if (cmbPBType.SelectedIndex == 0 && cmbRepToBranch.SelectedIndex > 0) { //sqlText = "SELECT HESS_TRXN_NO,HESS_LTR_REF_NO,HESS_APPL_NUMBER,HESS_EORA_CODE,MEMBER_NAME,HESS_TO_BRANCH_CODE,HESS_PROMOTION_CATEGORY_CODE" + // ",HPCM_PROMOTION_CATEGORY_NAME,HESS_BASIC,HESS_HRA,HESS_CCA,HESS_CONV_ALW,HESS_LTA_ALW,HESS_SPL_ALW,HESS_TO_COMPANY_CODE,HESS_UNF_ALW" + // ",HESS_VEH_ALW,HESS_CH_ED_ALW,HESS_BNP_ALW,HESS_MED_REIMB,HESS_PET_ALW,(HESS_BASIC+HESS_HRA+HESS_CCA+HESS_CONV_ALW+" + // "HESS_LTA_ALW+HESS_SPL_ALW+HESS_UNF_ALW+HESS_VEH_ALW+HESS_CH_ED_ALW+HESS_BNP_ALW+HESS_MED_REIMB+HESS_PET_ALW) HESS_GROSS_SAL" + // ",HESS_EFF_DATE,ISNULL(elevel_id,0) ELEVEL_ID,HESS_DESIG_ID,HESS_TO_DEPT_ID,desig_name FROM HR_EMP_SAL_STRU INNER JOIN EORA_MASTER ON ECODE = HESS_EORA_CODE INNER JOIN HR_PROMOTION_CATEGORY_MASTER " + // "ON HPCM_PROMOTION_CATEGORY_CODE = HESS_PROMOTION_CATEGORY_CODE LEFT JOIN LevelsDesig_mas ON ldm_company_code = HESS_TO_COMPANY_CODE AND LDM_DESIG_ID = HESS_DESIG_ID INNER JOIN DESIG_MAS ON desig_code = HESS_DESIG_ID " + // "WHERE HESS_APPR_STATUS='P' AND HESS_FROM_BRANCH_CODE = '" + cmbRepToBranch.SelectedValue + "' ORDER BY HESS_EFF_DATE ASC"; sBranch = cmbRepToBranch.SelectedValue.ToString(); sDetlType = "BYBR"; } } //if (sqlText.Length > 10) // dt = objDB.ExecuteDataSet(sqlText).Tables[0]; try { dt = objHRInfo.GetPromotionsDetlsForApproval("", sBranch, sPBType, sDetlType).Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objHRInfo = null; } if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataGridViewRow tempRow = new DataGridViewRow(); DataGridViewCell tempSlNo = new DataGridViewTextBoxCell(); tempSlNo.Value = i + 1; tempRow.Cells.Add(tempSlNo); DataGridViewCell tempTrnNo = new DataGridViewTextBoxCell(); tempTrnNo.Value = dt.Rows[i]["HESS_TRXN_NO"].ToString(); tempRow.Cells.Add(tempTrnNo); DataGridViewCell tempRefNo = new DataGridViewTextBoxCell(); tempRefNo.Value = dt.Rows[i]["HESS_LTR_REF_NO"].ToString(); tempRow.Cells.Add(tempRefNo); DataGridViewCell tempApplNo = new DataGridViewTextBoxCell(); tempApplNo.Value = dt.Rows[i]["HESS_APPL_NUMBER"].ToString(); tempRow.Cells.Add(tempApplNo); DataGridViewCell tempEcode = new DataGridViewTextBoxCell(); tempEcode.Value = dt.Rows[i]["HESS_EORA_CODE"].ToString(); tempRow.Cells.Add(tempEcode); DataGridViewCell tempName = new DataGridViewTextBoxCell(); tempName.Value = dt.Rows[i]["MEMBER_NAME"].ToString(); tempRow.Cells.Add(tempName); DataGridViewCell tempBCode = new DataGridViewTextBoxCell(); tempBCode.Value = dt.Rows[i]["HESS_TO_BRANCH_CODE"].ToString(); tempRow.Cells.Add(tempBCode); DataGridViewCell tempCCode = new DataGridViewTextBoxCell(); tempCCode.Value = dt.Rows[i]["HESS_TO_COMPANY_CODE"].ToString(); tempRow.Cells.Add(tempCCode); DataGridViewCell tempDesig = new DataGridViewTextBoxCell(); tempDesig.Value = dt.Rows[i]["desig_name"].ToString(); tempRow.Cells.Add(tempDesig); DataGridViewCell tempDesigID = new DataGridViewTextBoxCell(); tempDesigID.Value = dt.Rows[i]["HESS_DESIG_ID"].ToString(); tempRow.Cells.Add(tempDesigID); DataGridViewCell tempDeptID = new DataGridViewTextBoxCell(); tempDeptID.Value = dt.Rows[i]["HESS_TO_DEPT_ID"].ToString(); tempRow.Cells.Add(tempDeptID); DataGridViewCell tempElevelID = new DataGridViewTextBoxCell(); tempElevelID.Value = dt.Rows[i]["ELEVEL_ID"].ToString(); tempRow.Cells.Add(tempElevelID); DataGridViewCell tempPCat = new DataGridViewTextBoxCell(); tempPCat.Value = dt.Rows[i]["HPCM_PROMOTION_CATEGORY_NAME"].ToString(); tempRow.Cells.Add(tempPCat); DataGridViewCell tempSal = new DataGridViewTextBoxCell(); tempSal.Value = dt.Rows[i]["HESS_GROSS_SAL"].ToString(); tempRow.Cells.Add(tempSal); DataGridViewCell tempEff = new DataGridViewTextBoxCell(); tempEff.Value = Convert.ToDateTime(dt.Rows[i]["HESS_EFF_DATE"].ToString()).ToString("dd/MMM/yyyy").ToUpper(); tempRow.Cells.Add(tempEff); gvPromotiomDetl.Rows.Add(tempRow); } } objDB = null; dt = null; }