protected void btn_Approve_Click(object sender, EventArgs e) { try { int logEmpID = Convert.ToInt32(Session["EMP_ID"]); bool status = false; int count = 0; DataTable dtAppProcessEmpData = BLL.get_PMS_APPROVAL_PROCESS_BY_ORG_ID(Convert.ToInt32(Session["ORG_ID"]), Convert.ToInt32(rcmb_BU.SelectedValue)); for (int index = 0; index < RG_ApprAppraisal.Items.Count; index++) { CheckBox chk = RG_ApprAppraisal.Items[index].FindControl("chckbtn_Select") as CheckBox; if (chk.Checked) { count++; string EMP_ID = Convert.ToString(RG_ApprAppraisal.Items[index]["EMP_ID"].Text); string rtng = Convert.ToString(RG_ApprAppraisal.Items[index]["APPRAISAL_AVGRTG"].Text); //RadRating rtng = RG_ApprAppraisal.Items[index].FindControl("rtng_emprtng") as RadRating; _obj_Pms_Appraisalcycle = new PMS_Appraisalcycle(); _obj_Pms_Appraisalcycle.APPRCYCLE_BU_ID = Convert.ToInt32(rcmb_BU.SelectedItem.Value); _obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dtappid = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle); _obj_Pms_EmpGoalSetting = new SPMS_EMPGOALSETTING(); _obj_Pms_EmpGoalSetting.Mode = 8; _obj_Pms_EmpGoalSetting.GS_EMP_ID = Convert.ToInt32(EMP_ID); if (dtappid.Rows.Count != 0) { _obj_Pms_EmpGoalSetting.GS_APPRAISAL_CYCLE = Convert.ToString(rtxt_AppraisalCycle.SelectedItem.Value);//Convert.ToString(dtappid.Rows[0]["APPRCYCLE_ID"]); } else { _obj_Pms_EmpGoalSetting.GS_APPRAISAL_CYCLE = "0"; } _obj_Pms_EmpGoalSetting.CREATEDBY = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = Pms_Bll.get_EmpGoalSetting(_obj_Pms_EmpGoalSetting); _obj_GS = new PMS_GoalSettings(); if (dt.Rows.Count != 0) { _obj_GS.GS_ID = Convert.ToInt32(dt.Rows[0]["GS_ID"]); } else { _obj_GS.GS_ID = 0; } //TO UPDATE THE STATUS IN APPRAISAL _obj_Spms_Appraisal = new SPMS_APPRAISAL(); _obj_Spms_Appraisal.APPRAISAL_EMP_ID = Convert.ToInt32(EMP_ID); _obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rtxt_AppraisalCycle.SelectedItem.Value);//Convert.ToInt32(dtappid.Rows[0]["APPRCYCLE_ID"]); _obj_Spms_Appraisal.APPRAISAL_STATUS = 3; _obj_Spms_Appraisal.APPRAISAL_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); _obj_Spms_Appraisal.APPRAISAL_LASTMDFDATE = DateTime.Now; _obj_Spms_Appraisal.Mode = 48; status = Pms_Bll.set_Appraisal(_obj_Spms_Appraisal); //TO GET THE APPRAISAL ID _obj_Spms_Appraisal = new SPMS_APPRAISAL(); _obj_Spms_Appraisal.APPRAISAL_EMP_ID = Convert.ToInt32(EMP_ID); _obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rtxt_AppraisalCycle.SelectedItem.Value); //Convert.ToInt32(dtappid.Rows[0]["APPRCYCLE_ID"]); _obj_Spms_Appraisal.Mode = 5; _obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_app_id = Pms_Bll.get_Appraisal(_obj_Spms_Appraisal); //TO CHECK WHETHER DATA EXISTS IN APPRAISAL APPROVER OR NOT _obj_Pms_AppApprover = new SPMS_APRAISALAPPROVER(); if (dt_app_id.Rows.Count != 0) { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = Convert.ToInt32(dt_app_id.Rows[0]["APPRAISAL_ID"]); } else { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = 0; } _obj_Pms_AppApprover.Mode = 6; DataTable dt_appr = Pms_Bll.get_AppApprover(_obj_Pms_AppApprover); if (dt_appr.Rows.Count == 0) { //TO INSERT DATA INTO APPRAISAL APPROVER _obj_Pms_AppApprover = new SPMS_APRAISALAPPROVER(); if (dt_app_id.Rows.Count != 0) { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = Convert.ToInt32(dt_app_id.Rows[0]["APPRAISAL_ID"]); } else { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = 0; } _obj_Pms_AppApprover.Mode = 3; _obj_Pms_AppApprover.APP_APPROVER_RATING = Convert.ToDecimal(rtng); _obj_Pms_AppApprover.APP_APPROVER_COMMENTS = Convert.ToString(Pms_Bll.ReplaceQuote(rtxt_comments.Text)); _obj_Pms_AppApprover.APP_APPROVER_CREATEDBY = Convert.ToInt32(Session["user_id"]); _obj_Pms_AppApprover.APP_APPROVER_CREATEDDATE = DateTime.Now; _obj_Pms_AppApprover.APP_APPROVER_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); if (dtAppProcessEmpData.Rows.Count > 0) { if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_1"])) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 1; } else if (logEmpID == Convert.ToInt32(string.IsNullOrEmpty(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_2"].ToString()) ? 0 : Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_2"]))) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 2; } else if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_3"])) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 3; } else { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 0; } } bool status1 = Pms_Bll.set_AppApprover(_obj_Pms_AppApprover); } else { //TO UPDATE DATA IN APPRAISAL APPROVER _obj_Pms_AppApprover = new SPMS_APRAISALAPPROVER(); if (dt_app_id.Rows.Count != 0) { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = Convert.ToInt32(dt_app_id.Rows[0]["APPRAISAL_ID"]); } else { _obj_Pms_AppApprover.APP_APPROVER_APP_ID = 0; } _obj_Pms_AppApprover.Mode = 8; _obj_Pms_AppApprover.APP_APPROVER_RATING = Convert.ToDecimal(rtng); //_obj_Pms_AppApprover.APP_APPROVER_COMMENTS = Convert.ToString(rtxt_comments.Text.Replace("'", "''")); _obj_Pms_AppApprover.APP_APPROVER_COMMENTS = Convert.ToString(Pms_Bll.ReplaceQuote(rtxt_comments.Text)); _obj_Pms_AppApprover.APP_APPROVER_LASTMDFBY = Convert.ToInt32(Session["user_id"]); _obj_Pms_AppApprover.APP_APPROVER_LASTMDFDATE = DateTime.Now; _obj_Pms_AppApprover.APP_APPROVER_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); if (dtAppProcessEmpData.Rows.Count > 0) { if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_1"])) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 1; } else if (logEmpID == Convert.ToInt32(string.IsNullOrEmpty(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_2"].ToString()) ? 0 : Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_2"]))) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 2; } else if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_3"])) { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 3; } else { _obj_Pms_AppApprover.APP_APPROVER_STATUS = 0; } } bool status1 = Pms_Bll.set_AppApprover(_obj_Pms_AppApprover); } } } if (count == 0) { BLL.ShowMessage(this, "Please Select Atleast one Employee to Approve."); return; } BLL.ShowMessage(this, "Approver Comments Finalized Successfully."); LoadGrid(); Rm_Appraisal_PAGE.SelectedIndex = 0; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ApprAppraisal_latest", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void LoadGrid() { try { _obj_pms_EmployeeSetup = new PMS_EMPSETUP(); _obj_pms_EmployeeSetup.EMP_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["EMP_ID"])); _obj_pms_EmployeeSetup.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]); DataTable dtbuid1 = Pms_Bll.get_LoginInfo(_obj_pms_EmployeeSetup); if (dtbuid1.Rows.Count != 0) { lbl_RPMgr_Name.Text = Convert.ToString(dtbuid1.Rows[0]["REPORTINGMANAGER"]); lbl_ApprMgr_Name.Text = Convert.ToString(dtbuid1.Rows[0]["APPROVALMANAGER"]); _obj_GS = new PMS_GoalSettings(); _obj_GS.GS_MODE = 9; _obj_GS.GS_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_GS.GS_EMP_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["EMP_ID"])); _obj_GS.GS_APPRAISAL_CYCLE = Convert.ToString(Request.QueryString["APPCYCLE_ID"]);//Convert.ToString(dtappid.Rows[0]["APPRCYCLE_ID"]); DataTable dt1 = Pms_Bll.get_GS(_obj_GS); if (dt1.Rows.Count != 0) { lbl_Role_Name.Text = Convert.ToString(dt1.Rows[0]["ROLE_NAMES"]); //lbl_Project_Name.Text = Convert.ToString(dt1.Rows[0]["PROJECT_NAME"]); } } //TO GET SELFAPPRAISAL FOR THE APPRAISAL CYCLE ENABLE OR NOT,18.09.2012 _obj_Pms_Appraisalcycle = new PMS_Appraisalcycle(); _obj_Pms_Appraisalcycle.MODE = 2; _obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_Appraisalcycle.APPRCYCLE_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["APPCYCLE_ID"])); DataTable DT = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle); if (DT.Rows.Count > 0) { if (DT.Rows[0]["APPRCYCLE_SELFAPPRAISAL"] != System.DBNull.Value) { if (Convert.ToBoolean(DT.Rows[0]["APPRCYCLE_SELFAPPRAISAL"]) == true) { //RG_EmpAppraisalDetails.Columns[6].Visible = true; //RG_EmpAppraisalDetails.Columns[7].Visible = true; RG_EmpAppraisalDetails.Columns[4].Visible = true; } else { //RG_EmpAppraisalDetails.Columns[6].Visible = false; //RG_EmpAppraisalDetails.Columns[7].Visible = false; RG_EmpAppraisalDetails.Columns[4].Visible = false; } } } //TO LOAD THE GRID _obj_Pms_EmpGoalSetting = new SPMS_EMPGOALSETTING(); _obj_Pms_EmpGoalSetting.Mode = 8; _obj_Pms_EmpGoalSetting.GS_EMP_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["EMP_ID"])); _obj_Pms_EmpGoalSetting.GS_APPRAISAL_CYCLE = Convert.ToString(Request.QueryString["APPCYCLE_ID"]); //Convert.ToString(dtappid.Rows[0]["APPRCYCLE_ID"]); _obj_Pms_EmpGoalSetting.CREATEDBY = Convert.ToInt32(Session["ORG_ID"]); _obj_GS = new PMS_GoalSettings(); DataTable dt = Pms_Bll.get_EmpGoalSetting(_obj_Pms_EmpGoalSetting); if (dt.Rows.Count != 0) { _obj_GS.GS_ID = Convert.ToInt32(dt.Rows[0]["GS_ID"]); } else { _obj_GS.GS_ID = 0; } if (Convert.ToString(Request.QueryString["STR"].Trim()) == "GS_APPROVAL") { _obj_GS.GS_MODE = 33; //RG_EmpAppraisalDetails.Columns[6].Visible = false; //RG_EmpAppraisalDetails.Columns[7].Visible = false; //RG_EmpAppraisalDetails.Columns[8].Visible = false; //RG_EmpAppraisalDetails.Columns[9].Visible = false; RG_EmpAppraisalDetails.Columns[4].Visible = false; RG_EmpAppraisalDetails.Columns[5].Visible = false; RG_EmpAppraisalDetails.Columns[6].Visible = false; } else { _obj_GS.GS_MODE = 37; RG_EmpAppraisalDetails.Columns[2].Visible = false; RG_EmpAppraisalDetails.Columns[3].Visible = false; //RG_EmpAppraisalDetails.Columns[4].Visible = false; //RG_EmpAppraisalDetails.Columns[5].Visible = false; } _obj_GS.GS_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //_obj_GS.GS_ID = Convert.ToInt32(Session["GSID"]); DataTable dt_details = new DataTable(); dt_details = Pms_Bll.get_GS(_obj_GS); if (dt_details.Rows.Count > 0) { RG_EmpAppraisalDetails.DataSource = dt_details; RG_EmpAppraisalDetails.DataBind(); } else { RG_EmpAppraisalDetails.DataSource = dt_details; RG_EmpAppraisalDetails.DataBind(); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_EMPAppraisalDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }