protected void LoadGrid() { try { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.Mode = 1; DataTable dt = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); if (dt.Rows.Count != 0) { Rg_EmpSetup.DataSource = dt; Rg_EmpSetup.DataBind(); } else { DataTable dt1 = new DataTable(); Rg_EmpSetup.DataSource = dt1; Rg_EmpSetup.DataBind(); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_EmpSetup", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); Pms_Bll.ShowMessage(this, ex.Message.ToString()); return; } }
protected void btn_update_Click(object sender, EventArgs e) { try { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.EMP_SETUP_ID = Convert.ToInt32(lbl_Emp_Setup_Id.Text); _obj_Pms_EmpSetup.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Pms_EmpSetup.EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value); _obj_Pms_EmpSetup.REPORTINGMGR_ID = Convert.ToInt32(rcmb_ReportingMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.GENERALMGR_ID = Convert.ToInt32(rcmb_GeneralMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.EMP_SETUP_LASTMDFBY = 1; // ### Need to Get the Session _obj_Pms_EmpSetup.EMP_SETUP_LASTMDFDATE = DateTime.Now; _obj_Pms_EmpSetup.Mode = 20; bool status = Pms_Bll.set_EmpSetup(_obj_Pms_EmpSetup); if (status == true) { Pms_Bll.ShowMessage(this, "Record Updated Successfully"); LoadGrid(); btn_Save.Visible = true; Rm_EMPSETUP_PAGE.SelectedIndex = 0; return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_EmpSetup", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public static DataTable Load_Pms_Approver_Appraisal_Grid(PMS_EMPSETUP _obj_Pms_EmpSetup) { DataTable dt = new DataTable(); switch (_obj_Pms_EmpSetup.Mode) { case 23: dt = ExecuteQuery("EXEC USP_PMS_EMPLOYEESETUP @OPERATION = 'LOAD_APPROVE_APPRAISAL_GRID', @MODE = 23 ,@EMP_ID= " + Convert.ToString(_obj_Pms_EmpSetup.EMP_ID) + ",@EMP_SETUP_ORG_ID= " + Convert.ToString(_obj_Pms_EmpSetup.ORGANISATION_ID) + //",@BU_ID = " + Convert.ToInt32(_obj_Pms_EmpSetup.BU_ID) + ", @APPRAISALCYCLE_ID= " + Convert.ToInt32(_obj_Pms_EmpSetup.GSLIFECYCLE) + " "); break; case 24: dt = ExecuteQuery("EXEC USP_PMS_EMPLOYEESETUP @OPERATION = 'LOAD_APPROVE_APPRAISAL_GRID', @MODE = 24 ,@EMP_ID= " + Convert.ToString(_obj_Pms_EmpSetup.EMP_ID) + ",@EMP_SETUP_ORG_ID= " + Convert.ToString(_obj_Pms_EmpSetup.ORGANISATION_ID) + //",@BU_ID = " + Convert.ToInt32(_obj_Pms_EmpSetup.BU_ID) + ", @APPRAISALCYCLE_ID= " + Convert.ToInt32(_obj_Pms_EmpSetup.GSLIFECYCLE) + " "); break; case 25: dt = ExecuteQuery("EXEC USP_PMS_EMPLOYEESETUP @OPERATION = 'LOAD_APPROVE_APPRAISAL_GRID', @MODE = 25 ,@EMP_ID= " + Convert.ToString(_obj_Pms_EmpSetup.EMP_ID) + ",@EMP_SETUP_ORG_ID= " + Convert.ToString(_obj_Pms_EmpSetup.ORGANISATION_ID) + //",@BU_ID = " + Convert.ToInt32(_obj_Pms_EmpSetup.BU_ID) + ", @APPRAISALCYCLE_ID= " + Convert.ToInt32(_obj_Pms_EmpSetup.GSLIFECYCLE) + " "); break; default: break; } return(dt); }
/// <summary> ///IN THIS data binding from database to datatable binding to radgrid /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void rgem_needsource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { try { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.Mode = 1; DataTable dt = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); if (dt.Rows.Count != 0) { Rg_EmpSetup.DataSource = dt; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_EmpSetup", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/// <summary> ///IN THIS BASED ON Project_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void lnk_edit_Command(object sender, CommandEventArgs e) { try { btn_update.Visible = true; _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.Mode = 2; _obj_Pms_EmpSetup.EMP_SETUP_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable DT = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); lbl_Emp_Setup_Id.Text = Convert.ToString(DT.Rows[0]["EMP_SETUP_ID"]); LoadBusinessUnit(); rcmb_BusinessUnitType.SelectedIndex = rcmb_BusinessUnitType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["BU_ID"])); LoadEmployees(); rcmb_EmployeeType.SelectedIndex = rcmb_EmployeeType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["EMP_ID"])); LoadReportingManager(); rcmb_ReportingMgrType.SelectedIndex = rcmb_ReportingMgrType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["REPORTINGMGR_ID"])); LoadGeneralManager(); rcmb_GeneralMgrType.SelectedIndex = rcmb_GeneralMgrType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["GENERALMGR_ID"])); btn_Save.Visible = true; rcmb_ReportingMgrType.Enabled = true; Rm_EMPSETUP_PAGE.SelectedIndex = 1; rcmb_BusinessUnitType.Enabled = false; rcmb_EmployeeType.Enabled = false; btn_Save.Visible = false; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_EmpSetup", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); Pms_Bll.ShowMessage(this, ex.Message.ToString()); return; } }
private void LoadGrid() { try { DataTable dt_EMP = new DataTable(); ViewState["Status"] = 0; PMS_EMPSETUP _obj_Pms_EmpSetup; _obj_Pms_EmpSetup = new PMS_EMPSETUP(); //_obj_Pms_EmpSetup.Mode = 19; _obj_Pms_EmpSetup.EMP_ID = Convert.ToInt32(rcmb_RpMgr.SelectedItem.Value); //_obj_Pms_EmpSetup.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); _obj_Pms_EmpSetup.GSLIFECYCLE = Convert.ToInt32(rtxt_AppraisalCycle.SelectedItem.Value);//Convert.ToInt32(dtappidzzR.Rows[0]["APPRCYCLE_ID"]); _obj_Pms_EmpSetup.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //DataTable dt_EMP = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); int logEmpID = Convert.ToInt32(Session["EMP_ID"]); DataTable dtAppProcessEmpData = BLL.get_PMS_APPROVAL_PROCESS_BY_ORG_ID(Convert.ToInt32(Session["ORG_ID"]), Convert.ToInt32(rcmb_BU.SelectedValue)); if (dtAppProcessEmpData.Rows.Count > 0) { if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_1"])) { //_obj_Pms_EmpSetup.Mode = 1; _obj_Pms_EmpSetup.Mode = 23; } 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_EmpSetup.Mode = 24; } else if (logEmpID == Convert.ToInt32(dtAppProcessEmpData.Rows[0]["PMS_APPROVAL_PROCESS_EMP_ID_3"])) { _obj_Pms_EmpSetup.Mode = 25; } else { //status = 1; _obj_Pms_EmpSetup.Mode = 0; } } else { status = 2; } dt_EMP = BLL.Load_Pms_Approver_Appraisal_Grid(_obj_Pms_EmpSetup); //dt_EMP = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); if (dt_EMP.Rows.Count > 0) { RG_ApprAppraisal.DataSource = dt_EMP; RG_ApprAppraisal.DataBind(); } else { DataTable dt = new DataTable(); RG_ApprAppraisal.DataSource = dt; RG_ApprAppraisal.DataBind(); } 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 (Convert.ToString(dt_EMP.Rows[index]["APPRAISAL_STATUS"]) == "1" || Convert.ToString(dt_EMP.Rows[index]["APPRAISAL_STATUS"]) == "2" || Convert.ToString(dt_EMP.Rows[index]["APPRAISAL_STATUS"]) == "3") { chk.Enabled = true; } else { chk.Enabled = false; count++; } chk.Checked = false; } if (count == RG_ApprAppraisal.Items.Count) { if (RG_ApprAppraisal.Items.Count == 0) { ViewState["Status"] = 2; } else { ViewState["Status"] = 1; } tr_comments.Visible = false; tr_btns.Visible = false; rtxt_comments.Text = string.Empty; } else { tr_comments.Visible = true; tr_btns.Visible = true; 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"); } }
/// <summary> /// Here Edit a Particular Record.. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnk_Edit_Commnad(object sender, CommandEventArgs e) { try { clearfields(); _obj_idp = new pms_IDPSCREEN(); _obj_idp.IDP_MODE = 2; _obj_idp.IDP_ID = Convert.ToInt32(e.CommandArgument); DataTable DT = Pms_Bll.get_idp(_obj_idp); if (DT.Rows.Count != 0) { lbl_id.Text = Convert.ToString(DT.Rows[0]["IDP_ID"]); Session["empid1"] = (DT.Rows[0]["IDP_EMP_ID"]); _obj_idp = new pms_IDPSCREEN(); _obj_idp.IDP_MODE = 6; _obj_idp.IDP_EMP_ID = Convert.ToInt32(Convert.ToString(DT.Rows[0]["IDP_EMP_ID"])); _obj_idp.IDP_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Bus = Pms_Bll.get_idp(_obj_idp); loadBusinessUnit(); if (dt_Bus.Rows.Count != 0) { RCB_BusinessUnit.SelectedIndex = RCB_BusinessUnit.Items.FindItemIndexByValue(Convert.ToString(dt_Bus.Rows[0]["EMP_BUSINESSUNIT_ID"])); } //LoadEmployees(); _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_PMS_getemployee = new PMS_GETEMPLOYEE(); if ((Convert.ToString(Session["EMP_TYPE"])) == "5") { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } else { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } _obj_PMS_getemployee.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]); _obj_PMS_getemployee.BU_ID = Convert.ToInt32(RCB_BusinessUnit.SelectedItem.Value); _obj_PMS_getemployee.Mode = 5; DataTable dtbuid = Pms_Bll.get_RMEmployees(_obj_PMS_getemployee); if (dtbuid.Rows.Count != 0) { RCB_EmployeeName.DataSource = dtbuid; RCB_EmployeeName.DataTextField = "employee"; RCB_EmployeeName.DataValueField = "EMPID"; RCB_EmployeeName.DataBind(); RCB_EmployeeName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); //RCB_BusinessUnit.Visible = false; //lbl_BusinessUnit.Visible = false; } else { DataTable dt1 = new DataTable(); RCB_EmployeeName.DataSource = dt1; RCB_EmployeeName.DataBind(); //lbl_BusinessUnit.Visible = false; //RCB_BusinessUnit.Visible = false; } RCB_EmployeeName.SelectedIndex = RCB_EmployeeName.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["IDP_EMP_ID"])); //LoadAppraisalCycle1(); //rcm_apprcycle.SelectedIndex = rcm_apprcycle.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["IDP_APPRAISALCYCLE"])); txt_IDP.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["IDP_NAME"])); txt_Description.Text = Pms_Bll.ReplaceQuote(Convert.ToString(DT.Rows[0]["IDP_DESCRIPTION"])); RDP_StartDate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["IDP_STARTDATE"]); //RDP_EndDate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["IDP_ENDDATE"]); txt_Comments.Text = Convert.ToString(DT.Rows[0]["IDP_COMMENTS"]); if (DT.Rows[0]["IDP_STATUS"] != System.DBNull.Value) { if (Convert.ToString(DT.Rows[0]["IDP_STATUS"]).Trim() == "Active") { rcmb_status.SelectedValue = "1"; } else { rcmb_status.SelectedValue = "0"; } } else { rcmb_status.SelectedValue = "0"; } RM_Idpform.SelectedIndex = 1; RP_Idpform.Visible = false; RP_Idpform2.Visible = true; btn_SAVE.Visible = false; btn_UPDATE.Visible = true; RCB_BusinessUnit.Enabled = false; RCB_EmployeeName.Enabled = false; txt_IDP.Enabled = false; //lbl_BusinessUnit.Visible = false; //RCB_BusinessUnit.Visible = false; txt_Comments.Enabled = true; RDP_StartDate.Enabled = false; //RDP_EndDate.Enabled = true; //rcm_apprcycle.Enabled = false; if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_UPDATE.Visible = false; } else { btn_UPDATE.Visible = true; if (rcmb_status.SelectedValue == "0") { BLL.ShowMessage(this, "IDP is Inactive.You can not Update the record."); btn_UPDATE.Visible = false; } } } else { } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_idp", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/// <summary> /// Here RCB_BusinessUnit_SelectedIndexChanged for Getting Business Unit From SMHR... /// </summary> /// <param name="o"></param> /// <param name="e"></param> protected void RCB_BusinessUnit_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { try { //LoadEmployees(); if (RCB_BusinessUnit.SelectedIndex > 0) { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_PMS_getemployee = new PMS_GETEMPLOYEE(); if ((Convert.ToString(Session["EMP_TYPE"])) == "5") { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } else { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } _obj_PMS_getemployee.BU_ID = Convert.ToInt32(RCB_BusinessUnit.SelectedItem.Value); _obj_PMS_getemployee.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]); _obj_PMS_getemployee.Mode = 4; DataTable dtbuid = Pms_Bll.get_RMEmployees(_obj_PMS_getemployee); if (dtbuid.Rows.Count != 0) { RCB_EmployeeName.DataSource = dtbuid; RCB_EmployeeName.DataTextField = "employee"; RCB_EmployeeName.DataValueField = "EMPID"; RCB_EmployeeName.DataBind(); RCB_EmployeeName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); //RCB_BusinessUnit.Visible = false; //lbl_BusinessUnit.Visible = false; } else { DataTable dt1 = new DataTable(); RCB_EmployeeName.DataSource = dt1; RCB_EmployeeName.DataBind(); //lbl_BusinessUnit.Visible = false; //RCB_BusinessUnit.Visible = false; } //LoadAppraisalCycle(); } else { RCB_EmployeeName.ClearSelection(); RCB_EmployeeName.Items.Clear(); RCB_EmployeeName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); //rcm_apprcycle.ClearSelection(); //rcm_apprcycle.Items.Clear(); //rcm_apprcycle.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_idp", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Pms_EmpSetup.EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value); _obj_Pms_EmpSetup.REPORTINGMGR_ID = Convert.ToInt32(rcmb_ReportingMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.GENERALMGR_ID = Convert.ToInt32(rcmb_GeneralMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.Mode = 5; DataTable dtemp = Pms_Bll.get_EmpSetup(_obj_Pms_EmpSetup); if (Convert.ToInt32(dtemp.Rows[0]["Count"]) != 0) { Pms_Bll.ShowMessage(this, "Employee Already Assigned"); rcmb_ReportingMgrType.Enabled = true; } else { _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_Pms_EmpSetup.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Pms_EmpSetup.EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value); _obj_Pms_EmpSetup.REPORTINGMGR_ID = Convert.ToInt32(rcmb_ReportingMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.GENERALMGR_ID = Convert.ToInt32(rcmb_GeneralMgrType.SelectedItem.Value); _obj_Pms_EmpSetup.EMP_SETUP_CREATEDBY = 1; // ### Need to Get the Session _obj_Pms_EmpSetup.EMP_SETUP_CREATEDDATE = DateTime.Now; _obj_Pms_EmpSetup.Mode = 3; bool status = Pms_Bll.set_EmpSetup(_obj_Pms_EmpSetup); if (status == true) { Pms_Bll.ShowMessage(this, "Record Inserted Successfully"); btn_Save.Visible = true; LoadGrid(); Rm_EMPSETUP_PAGE.SelectedIndex = 0; DataTable dt = new DataTable(); rcmb_BusinessUnitType.SelectedIndex = 0; rcmb_EmployeeType.SelectedIndex = 0; rcmb_ReportingMgrType.SelectedIndex = 0; rcmb_GeneralMgrType.SelectedIndex = 0; rcmb_GeneralMgrType.Enabled = true; rcmb_BusinessUnitType.Enabled = true; rcmb_EmployeeType.Enabled = true; rcmb_ReportingMgrType.Enabled = true; rcmb_EmployeeType.DataSource = dt; rcmb_EmployeeType.DataBind(); rcmb_GeneralMgrType.DataSource = dt; rcmb_GeneralMgrType.DataBind(); rcmb_ReportingMgrType.DataSource = dt; rcmb_ReportingMgrType.DataBind(); return; } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_EmpSetup", 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"); } }
/// <summary> ///IN THIS BASED ON Task_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void lnk_edit_command(object sender, CommandEventArgs e) { try { clearControls(); btn_Save.Text = "Update"; LoadBusinessUnit(); //LoadGoal(); rcmb_BusinessUnitType.SelectedIndex = -1; _obj_Pms_Task = new SPMS_TASK(); _obj_Pms_Task.Mode = 2; _obj_Pms_Task.TASK_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable DT = Pms_Bll.get_Task(_obj_Pms_Task); if (DT.Rows.Count != 0) { lbl_Task_Id.Text = Convert.ToString(DT.Rows[0]["TASK_ID"]); Session["empid1"] = (DT.Rows[0]["EMP_ID"]); _obj_Pms_Task = new SPMS_TASK(); _obj_Pms_Task.Mode = 6; _obj_Pms_Task.TASK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(Convert.ToString(DT.Rows[0]["EMP_ID"])); DataTable dt_Bus = Pms_Bll.get_Task(_obj_Pms_Task); LoadBusinessUnit(); rcmb_BusinessUnitType.SelectedIndex = rcmb_BusinessUnitType.FindItemIndexByValue(Convert.ToString(dt_Bus.Rows[0]["EMP_BUSINESSUNIT_ID"])); //LoadEmployees(); PMS_EMPSETUP _obj_Pms_EmpSetup; _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_PMS_getemployee = new PMS_GETEMPLOYEE(); if ((Convert.ToString(Session["EMP_TYPE"])) == "5") { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } else { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } _obj_PMS_getemployee.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_PMS_getemployee.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]); _obj_PMS_getemployee.Mode = 5; dtbuid = Pms_Bll.get_RMEmployees(_obj_PMS_getemployee); if (dtbuid.Rows.Count != 0) { rcmb_EmployeeType.Items.Clear(); rcmb_EmployeeType.DataSource = dtbuid; rcmb_EmployeeType.DataTextField = "employee"; rcmb_EmployeeType.DataValueField = "EMPID"; rcmb_EmployeeType.DataBind(); rcmb_EmployeeType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); //rcmb_BusinessUnitType.Visible = false; //lbl_BusinessUnitName.Visible = false; } else { DataTable dt1 = new DataTable(); rcmb_EmployeeType.DataSource = dt1; rcmb_EmployeeType.DataBind(); //lbl_BusinessUnitName.Visible = false; //rcmb_BusinessUnitType.Visible = false; } //EmpLoad(); rcmb_EmployeeType.SelectedIndex = rcmb_EmployeeType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["EMP_ID"])); //rcmb_EmployeeType.SelectedValue = Convert.ToString(DT.Rows[0]["TASK_EMP_ID"]); rtxt_TaskName.Text = Convert.ToString(DT.Rows[0]["TASK_NAME"]); rtxt_TaskDescription.Text = Convert.ToString(DT.Rows[0]["TASK_DESCRIPTION"]); rdtp_DATE.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TASK_DATE"]); LoadGoal1(); rcmb_GoalType.SelectedIndex = rcmb_GoalType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TASK_GOAL"])); LoadAppraisalCycle1(); rcm_apprcycle.SelectedIndex = rcm_apprcycle.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TASK_APPRAISAL_CYCLE"])); btn_Save.Visible = true; rtxt_TaskName.Enabled = false; Rm_TASK_PAGE.SelectedIndex = 1; Rp_TASK_VIEWMAIN.Visible = false; Rp_TASK_VIEWDETAILS.Visible = true; rcmb_BusinessUnitType.Enabled = false; rcmb_EmployeeType.Enabled = false; //rcmb_BusinessUnitType.Visible = false; //lbl_BusinessUnitName.Visible = false; rcmb_GoalType.Enabled = false; rcm_apprcycle.Enabled = false; rdtp_DATE.Enabled = false; if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Save.Visible = false; } else { btn_Save.Visible = true; } } else { Pms_Bll.ShowMessage(this, "Error Occured"); } } catch (Exception ex) { //Pms_Bll.ShowMessage(this, ex.Message.ToString()); //return; SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PmsTask", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/// <summary> /// HERE I AM LOADING EMPLOYEE DETAILS WHEN BUSINESS UNIT COMBO BOX SELECT INDEX CHANGED EVENT FIRED /// </summary> /// <param name="o"></param> /// <param name="e"></param> protected void rcmb_BusinessUnitType_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { try { if (rcmb_BusinessUnitType.SelectedIndex > 0) { PMS_EMPSETUP _obj_Pms_EmpSetup; _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_PMS_getemployee = new PMS_GETEMPLOYEE(); _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); _obj_PMS_getemployee.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_PMS_getemployee.Mode = 4; _obj_PMS_getemployee.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]); dtbuid = Pms_Bll.get_RMEmployees(_obj_PMS_getemployee); if (dtbuid.Rows.Count != 0) { rcmb_EmployeeType.Items.Clear(); rcmb_EmployeeType.DataSource = dtbuid; rcmb_EmployeeType.DataTextField = "employee"; rcmb_EmployeeType.DataValueField = "EMPID"; rcmb_EmployeeType.DataBind(); rcmb_EmployeeType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); //rcmb_BusinessUnitType.Visible = false; //lbl_BusinessUnitName.Visible = false; } else { DataTable dt1 = new DataTable(); rcmb_EmployeeType.DataSource = dt1; rcmb_EmployeeType.DataBind(); //lbl_BusinessUnitName.Visible = false; //rcmb_BusinessUnitType.Visible = false; } rcmb_EmployeeType.SelectedIndex = 0; //lbl_BusinessUnitName.Visible = false; //rcmb_BusinessUnitType.Visible = false; rcm_apprcycle.Enabled = true; DataTable dt2 = new DataTable(); rcmb_GoalType.DataSource = dt2; rcmb_GoalType.DataBind(); LoadAppraisalCycle(); } else { rcmb_EmployeeType.ClearSelection(); rcmb_EmployeeType.Items.Clear(); rcmb_EmployeeType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rcm_apprcycle.ClearSelection(); rcm_apprcycle.Items.Clear(); rcm_apprcycle.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rcmb_GoalType.ClearSelection(); rcmb_GoalType.Items.Clear(); rcmb_GoalType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } } catch (Exception ex) { //Pms_Bll.ShowMessage(this, ex.Message.ToString()); //return; SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PmsTask", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Add_Command(object sender, CommandEventArgs e) { try { clearControls(); btn_Save.Visible = true; btn_cancel.Visible = true; btn_Save.Text = "Save"; btn_cancel.Text = "Cancel"; rtxt_TaskName.Enabled = true; LoadBusinessUnit(); rcmb_EmployeeType.Enabled = true; rcmb_BusinessUnitType.Enabled = true; rcmb_BusinessUnitType.SelectedIndex = -1; LoadGoal(); Rm_TASK_PAGE.SelectedIndex = 1; lbl_BusinessUnitName.Visible = false; rcmb_BusinessUnitType.Visible = false; rcmb_EmployeeType.SelectedIndex = Convert.ToInt32(Session["empid"]); PMS_EMPSETUP _obj_Pms_EmpSetup; _obj_Pms_EmpSetup = new PMS_EMPSETUP(); _obj_PMS_getemployee = new PMS_GETEMPLOYEE(); if ((Convert.ToString(Session["EMP_TYPE"])) == "13") { _obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]); } DataTable dtbuid = Pms_Bll.get_GMEmployees(_obj_PMS_getemployee); if (dtbuid.Rows.Count != 0) { rcmb_EmployeeType.Items.Clear(); rcmb_EmployeeType.DataSource = dtbuid; rcmb_EmployeeType.DataTextField = "employee"; rcmb_EmployeeType.DataValueField = "EMPID"; rcmb_EmployeeType.DataBind(); rcmb_EmployeeType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rcmb_BusinessUnitType.Visible = false; lbl_BusinessUnitName.Visible = false; } else { DataTable dt1 = new DataTable(); rcmb_EmployeeType.DataSource = dt1; rcmb_EmployeeType.DataBind(); lbl_BusinessUnitName.Visible = false; rcmb_BusinessUnitType.Visible = false; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Task", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }