private void LoadReportManager()
{
try
{
rcmb_RptEmp.Items.Clear();
_obj_Spms_Appraisal = new SPMS_APPRAISAL();
_obj_Spms_Appraisal.Mode = 1;
_obj_Spms_Appraisal.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
_obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_manager = Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal);
if (dt_manager.Rows.Count != 0)
{
rcmb_RptEmp.DataSource = dt_manager;
rcmb_RptEmp.DataTextField = "MANAGER";
rcmb_RptEmp.DataValueField = "REPORTINGMGR_ID";
rcmb_RptEmp.DataBind();
rcmb_RptEmp.Items.Insert(0, new RadComboBoxItem("All"));
}
else
{
DataTable dt5 = new DataTable();
rcmb_RptEmp.DataSource = dt5;
rcmb_RptEmp.DataBind();
rcmb_RptEmp.Items.Insert(0, new RadComboBoxItem("All"));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Pms_AppraisalDone", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_AppCycle_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_AppCycle.SelectedItem.Text != "Select")
{
//yyyy
_obj_Spms_Appraisal = new SPMS_APPRAISAL();
_obj_Spms_Appraisal.Mode = 1;
_obj_Spms_Appraisal.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
_obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_manager = Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal);
if (dt_manager.Rows.Count != 0)
{
rcmb_RManager.DataSource = dt_manager;
rcmb_RManager.DataTextField = "MANAGER";
rcmb_RManager.DataValueField = "REPORTINGMGR_ID";
rcmb_RManager.DataBind();
rcmb_RManager.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
else
{
DataTable dt5 = new DataTable();
rcmb_RManager.DataSource = dt5;
rcmb_RManager.DataBind();
rcmb_RManager.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
}
else
{
Pms_Bll.ShowMessage(this, "Please Select Appraisal Cycle");
DataTable dt5 = new DataTable();
//rcmb_RManager.Visible = false;
//lbl_RM.Visible = false;
rcmb_RManager.DataSource = dt5;
rcmb_RManager.DataBind();
//rcmb_RManager.Visible = false;
//lbl_RM.Visible = false;
Rg_Ratings.Visible = false;
return;
}
}
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");
}
}
protected void rcm_app_cycleAppDisc_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcm_app_cycleAppDisc.SelectedItem.Text != "Select")
{
_obj_Pms_Appraisalcycle = new PMS_Appraisalcycle();
_obj_Pms_Appraisalcycle.MODE = 8;
_obj_Pms_Appraisalcycle.APPRCYCLE_BU_ID = Convert.ToInt32(rcm_bunitAppDisc.SelectedValue);
_obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["org_id"]);
DataTable dtappidzz1 = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle);
if (dtappidzz1.Rows.Count != 0)
{
_obj_Spms_Appraisal = new SPMS_APPRAISAL();
_obj_Spms_Appraisal.Mode = 26;
_obj_Spms_Appraisal.APPRAISAL_BUSSINESS_UNIT = Convert.ToInt32(rcm_bunitAppDisc.SelectedItem.Value);
_obj_Spms_Appraisal.APPRAISAL_APPRAISALCYCLE = Convert.ToInt32(rcm_app_cycleAppDisc.SelectedItem.Value);//Convert.ToInt32(dtappidzz1.Rows[0]["APPRCYCLE_ID"]);
_obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["org_id"]);
DataTable DT = Pms_Bll.get_Appraisal(_obj_Spms_Appraisal);
if (DT.Rows.Count != 0)
{
Rg_appdisc.DataSource = DT;
Rg_appdisc.DataBind();
Rm_App_Disc.SelectedIndex = 1;
}
else
{
DataTable dt2 = new DataTable();
Rg_appdisc.DataSource = dt2;
Rg_appdisc.DataBind();
Rm_App_Disc.SelectedIndex = 1;
}
}
}
else
{
Pms_Bll.ShowMessage(this, "No Active Appraisal Cycle Under Business Unit");
DataTable dt1 = new DataTable();
Rg_appdisc.DataSource = dt1;
Rg_appdisc.DataBind();
Rm_Goal_Reports.SelectedIndex = 1;
}
}
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");
}
}
protected void rtxt_AppraisalCycle_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rtxt_AppraisalCycle.SelectedIndex > 0)
{
rcmb_RpMgr.Items.Clear();
_obj_Spms_Appraisal = new SPMS_APPRAISAL();
//_obj_Spms_Appraisal.Mode = 5;
//_obj_Spms_Appraisal.EMPID = Convert.ToInt32(Session["EMP_ID"]);
_obj_Spms_Appraisal.Mode = 1;
_obj_Spms_Appraisal.BUID = Convert.ToInt32(rcmb_BU.SelectedValue);
_obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_manager = Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal);
if (dt_manager.Rows.Count != 0)
{
rcmb_RpMgr.DataSource = dt_manager;
rcmb_RpMgr.DataTextField = "MANAGER";
rcmb_RpMgr.DataValueField = "REPORTINGMGR_ID";
rcmb_RpMgr.DataBind();
rcmb_RpMgr.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
}
else
{
rcmb_RpMgr.ClearSelection();
rcmb_RpMgr.Items.Clear();
rcmb_RpMgr.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
RG_ApprAppraisal.Visible = false;
tr_comments.Visible = false;
tr_btns.Visible = false;
rtxt_comments.Text = string.Empty;
}
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 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 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 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");
}
}
protected void rcmb_RManager_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_RManager.SelectedItem.Text != "Select")
{
_obj_Pms_Appraisalcycle = new PMS_Appraisalcycle();
_obj_Pms_Appraisalcycle.MODE = 11;
_obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Appraisalcycle.APPRCYCLE_ID = Convert.ToInt32(rcmb_RManager.SelectedItem.Value);//where i am passing employee to get bunit
DataTable dtemzzR = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle);
if (dtemzzR.Rows.Count != 0)
{
_obj_Pms_Appraisalcycle.MODE = 8;
_obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_Pms_Appraisalcycle.APPRCYCLE_BU_ID = Convert.ToInt32(dtemzzR.Rows[0]["EMP_BUSINESSUNIT_ID"]);
_obj_Pms_Appraisalcycle.APPRCYCLE_BU_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
DataTable dtappidzzR = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle);
_obj_Spms_Appraisal = new SPMS_APPRAISAL();
_obj_Spms_Appraisal.Mode = 2;
_obj_Spms_Appraisal.APPRAISAL_EMP_ID = Convert.ToInt32(rcmb_RManager.SelectedItem.Value);
if (dtappidzzR.Rows.Count != 0)
{
_obj_Spms_Appraisal.APPRAISAL_ID = Convert.ToInt32(rcmb_AppCycle.SelectedItem.Value); //Convert.ToInt32(dtappidzzR.Rows[0]["APPRCYCLE_ID"]);
}
_obj_Spms_Appraisal.APPRAISAL_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Rmanager = Pms_Bll.get_EmpRatingDetails(_obj_Spms_Appraisal);
if (dt_Rmanager.Rows.Count != 0)
{
Rg_Ratings.DataSource = dt_Rmanager;
Rg_Ratings.DataBind();
_obj_Pms_AppStatus = new SPMS_APRAISALSTATUS();
_obj_Pms_AppStatus.Mode = 7;
_obj_Pms_AppStatus.APP_STATUS_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_AppStatus.APP_STATUS_APPRAISALCYCLE = Convert.ToInt32(rcmb_AppCycle.SelectedItem.Value);
DataTable dtappsttusemp = Pms_Bll.get_AppStatus(_obj_Pms_AppStatus);
if (dtappsttusemp.Rows.Count != 0)
{
for (int k = 0; k <= Rg_Ratings.Items.Count - 1; k++)
{
for (int z = 0; z < dtappsttusemp.Rows.Count; z++)
{
if (Convert.ToInt32(dt_Rmanager.Rows[k]["EMP_ID"]) == Convert.ToInt32(dtappsttusemp.Rows[z]["APP_EMP_ID"]))
{
LinkButton lnkrej = Rg_Ratings.Items[k].FindControl("lnk_Employee_Edit") as LinkButton;
lnkrej.Visible = false;
}
}
}
}
else
{
Rg_Ratings.DataSource = dt_Rmanager;
Rg_Ratings.DataBind();
//Pms_Bll.ShowMessage(this, "No Employee Completed Appraisal Status");
}
Rm_Reprts_Main_PAGE.SelectedIndex = 2;
}
else
{
Pms_Bll.ShowMessage(this, "No Employee Under Reporting Manager");
//Rg_Ratings.Visible = false;
return;
}
}
//else
//{
// Pms_Bll.ShowMessage(this, "Employee Is In Active");
// //Rg_Ratings.Visible = false;
// return;
//}
}
else
{
Pms_Bll.ShowMessage(this, "Please Select Reporting Manager");
//Rg_Ratings.Visible = false;
return;
}
}
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");
}
}
