protected void btn_Reject_Click(object sender, EventArgs e) { try { bool status10; bool status11; string EMP_ID = string.Empty; string EMP_NAME = string.Empty; DataTable dtemployee223; DataTable dtemployee22; DataTable dtemployee224; string HR = string.Empty; string RpMgr = string.Empty; string Email = string.Empty; string APPR_EMAIL = string.Empty; int count = 0; 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++; EMP_ID = Convert.ToString(RG_ApprAppraisal.Items[index]["EMP_ID"].Text); _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); _obj_Spms_Appraisal.Mode = 5; DataTable dtgoal4 = Pms_Bll.get_Appraisal(_obj_Spms_Appraisal); if (dtgoal4.Rows.Count != 0) { _obj_Spms_Appraisal.APPRAISAL_ID = Convert.ToInt32(dtgoal4.Rows[0]["APPRAISAL_ID"]); } _obj_Spms_Appraisal.EMPID = Convert.ToInt32(EMP_ID); _obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //TO GET THE EMP DETAILS _obj_Pms_AppDiscDtls = new SPMS_APRAISALDISCUSSION(); _obj_Pms_AppDiscDtls.Mode = 6; _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_LASTMDFBY = Convert.ToInt32(EMP_ID); dtemployee22 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); //TO ONSERT DATA INTO APPRAISAL_REJECT TABLE _obj_Spms_Appraisal.Mode = 6; _obj_Spms_Appraisal.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Spms_Appraisal.EMPID = Convert.ToInt32(EMP_ID); _obj_Spms_Appraisal.APPRAISAL_ID = Convert.ToInt32(dtgoal4.Rows[0]["APPRAISAL_ID"]); _obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rtxt_AppraisalCycle.SelectedItem.Value); _obj_Spms_Appraisal.APP_REJECT_COMMENTS = Convert.ToString(rtxt_comments.Text.Replace("'", "''")); _obj_Spms_Appraisal.APPRAISAL_BUSSINESS_UNIT = Convert.ToInt32(dtemployee22.Rows[0]["EMP_BU_ID"]); _obj_Spms_Appraisal.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); bool st_reject = Pms_Bll.set_EmpRejectdetails(_obj_Spms_Appraisal); _obj_Spms_Appraisal.Mode = 4; //if (Convert.ToString(Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal).Rows[0]["Count"]) == "0") //{ // BLL.ShowMessage(this, "Please do Appraisal Discussion Before Reject."); // return; //} _obj_Spms_Appraisal.Mode = 3; bool st = Pms_Bll.set_EmpRatingdetails(_obj_Spms_Appraisal); Pms_Bll.ShowMessage(this, "Rejected Successfully"); _obj_Pms_AppDiscDtls = new SPMS_APRAISALDISCUSSION(); _obj_Pms_AppDiscDtls.Mode = 9; _obj_Pms_AppDiscDtls.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); dtemployee223 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); //if ((dtemployee22.Rows.Count != 0)) //{ // Dal.ExecuteNonQuery("EXEC USP_SEND_EMAIL_PMS_APPraisalReject_Backup @HR_name='" + Convert.ToString(dtemployee223.Rows[0]["HrMANAGER"]) + "',@EMPLOYEEmail='" + Convert.ToString(dtemployee22.Rows[0]["employee_EMAILID"]) + "',@REPORTINGMANAGER='" + Convert.ToString(dtemployee22.Rows[0]["REPORTINGMANAGER"]) + "',@EMPNAME='" + Convert.ToString(dtemployee22.Rows[0]["employeename"]) + "'"); // status10 = true; //} //else //{ // status10 = false; //} _obj_Pms_AppDiscDtls.Mode = 7; _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_LASTMDFBY = Convert.ToInt32(EMP_ID); dtemployee224 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); HR = Convert.ToString(dtemployee223.Rows[0]["HrMANAGER"]); RpMgr = Convert.ToString(dtemployee224.Rows[0]["REPORTINGMANAGER"]); Email = Convert.ToString(dtemployee224.Rows[0]["LOGIN_EMAILID_rmgr"]); APPR_EMAIL = Convert.ToString(dtemployee224.Rows[0]["APPR_EMAIL"]); if (EMP_NAME == string.Empty) { EMP_NAME = Convert.ToString(dtemployee224.Rows[0]["employee"]); } else { EMP_NAME = string.Concat(EMP_NAME, ",", Convert.ToString(dtemployee224.Rows[0]["employee"])); } } } if (count == 0) { BLL.ShowMessage(this, "Please Select Atleast one Employee to Reject."); return; } if (Email != string.Empty) { Dal.ExecuteNonQuery("EXEC USP_SEND_EMAIL_PMS_APPraisalRejetomgr @HR_name='" + HR + "',@empname='" + Convert.ToString(EMP_NAME) + "',@REPORTINGMANAGERname='" + RpMgr + "',@REPORTINGMANAGERmail='" + Email + "',@APPCYCLE='" + Convert.ToString(rtxt_AppraisalCycle.SelectedItem.Text) + "',@APPR_EMAIL= '" + APPR_EMAIL + "'"); status11 = true; } else { status11 = false; } if (status11) { Pms_Bll.ShowMessage(this, "Notification Send"); } LoadGrid(); } 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 lnk_Reject_Command(object sender, CommandEventArgs e) { try { _obj_Spms_Appraisal = new SPMS_APPRAISAL(); _obj_Spms_Appraisal.APPRAISAL_EMP_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); _obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rcmb_AppCycle.SelectedItem.Value); _obj_Spms_Appraisal.Mode = 5; DataTable dtgoal4 = Pms_Bll.get_Appraisal(_obj_Spms_Appraisal); if (dtgoal4.Rows.Count != 0) { _obj_Spms_Appraisal.APPRAISAL_ID = Convert.ToInt32(dtgoal4.Rows[0]["APPRAISAL_ID"]); } //_obj_Spms_AppraisalKra.APP_KRA_FIXED = 1; _obj_Spms_Appraisal.EMPID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); _obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Spms_Appraisal.Mode = 4; //if (Convert.ToString(Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal).Rows[0]["Count"]) == "0") //{ // BLL.ShowMessage(this, "Please do Appraisal Discussion Before Reject."); // return; //} //TO GET THE EMP DETAILS SPMS_APRAISALDISCUSSION _obj_Pms_AppDiscDtls = new SPMS_APRAISALDISCUSSION(); _obj_Pms_AppDiscDtls.Mode = 6; _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_LASTMDFBY = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable dtemployee22 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); //TO ONSERT DATA INTO APPRAISAL_REJECT TABLE _obj_Spms_Appraisal.Mode = 6; _obj_Spms_Appraisal.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Spms_Appraisal.EMPID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); _obj_Spms_Appraisal.APPRAISAL_ID = Convert.ToInt32(dtgoal4.Rows[0]["APPRAISAL_ID"]); _obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rcmb_AppCycle.SelectedItem.Value); _obj_Spms_Appraisal.APPRAISAL_BUSSINESS_UNIT = Convert.ToInt32(dtemployee22.Rows[0]["EMP_BU_ID"]); _obj_Spms_Appraisal.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); bool st_reject = Pms_Bll.set_EmpRejectdetails(_obj_Spms_Appraisal); _obj_Spms_Appraisal.Mode = 3; bool st = Pms_Bll.set_EmpRatingdetails(_obj_Spms_Appraisal); Pms_Bll.ShowMessage(this, "Rejected Successfully"); _obj_Pms_AppDiscDtls = new SPMS_APRAISALDISCUSSION(); _obj_Pms_AppDiscDtls.Mode = 9; _obj_Pms_AppDiscDtls.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dtemployee223 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); bool status10; bool status11; //if ((dtemployee22.Rows.Count != 0)) //{ // Dal.ExecuteNonQuery("EXEC USP_SEND_EMAIL_PMS_APPraisalReject_Backup @HR_name='" + Convert.ToString("HR") + "',@EMPLOYEEmail='" + Convert.ToString(dtemployee22.Rows[0]["employee_EMAILID"]) + "',@REPORTINGMANAGER='" + Convert.ToString(dtemployee22.Rows[0]["REPORTINGMANAGER"]) + "',@EMPNAME='" + Convert.ToString(dtemployee22.Rows[0]["employeename"]) + "'"); // status10 = true; //} //else //{ // status10 = false; //} _obj_Pms_AppDiscDtls.Mode = 7; _obj_Pms_AppDiscDtls.APP_DISCUSSION_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_AppDiscDtls.APP_DISCUSSION_LASTMDFBY = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable dtemployee224 = Pms_Bll.get_AppDiscDtls(_obj_Pms_AppDiscDtls); if (dtemployee224.Rows.Count > 0 && dtemployee223.Rows.Count > 0) { Dal.ExecuteNonQuery("EXEC USP_SEND_EMAIL_PMS_APPraisalRejetomgr @HR_name='" + Convert.ToString(dtemployee223.Rows[0]["HrMANAGER"]) + "',@empname='" + Convert.ToString(dtemployee224.Rows[0]["employee"]) + "',@REPORTINGMANAGERname='" + Convert.ToString(dtemployee224.Rows[0]["REPORTINGMANAGER"]) + "',@REPORTINGMANAGERmail='" + Convert.ToString(dtemployee224.Rows[0]["LOGIN_EMAILID_rmgr"]) + "'"); status11 = true; } else { status11 = false; } if (status11) { Pms_Bll.ShowMessage(this, "Notification Sent"); } Rm_Reprts_Main_PAGE.SelectedIndex = 0; Rm_Reprts_Main_PAGE.Visible = true; Rm_Goal_Reports.Visible = false; Rm_Appraisal.Visible = false; Rm_App_Disc.Visible = false; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Reports", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }