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");
}
}
