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