//<summary> //This Method is used to fetch KRA's, Compentences, and Values from tables PMS_KRA, PMS_CMP, and PMS_IDP respectively. //</summary> //<returns> //DataSet //</returns> public static DataSet getKRACompetenciesValues(SPMS_ROLEKRA _obj_Pms_RoleKra) { DataSet ds = new DataSet(); switch (_obj_Pms_RoleKra.OPERATION) { case operation.Select: ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["connection"].ToString(), CommandType.Text, "EXEC USP_PMS_ROLEKRA @Operation = '" + _obj_Pms_RoleKra.OPERATION + "', @ROLEKRA_ORG_ID =" + _obj_Pms_RoleKra.ROLEKRA_ORG_ID + ", @PMS_BU_ID = " + _obj_Pms_RoleKra.BUID); break; //case operation.Get: // ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["connection"].ToString(), CommandType.Text, "EXEC USP_PMS_ROLEKRA @Operation = '" // + _obj_Pms_RoleKra.OPERATION // + "', @ROLEKRA_ORG_ID =" + _obj_Pms_RoleKra.ROLEKRA_ORG_ID // + ", @PMS_BU_ID = " + _obj_Pms_RoleKra.BUID // + ", @POSITION_ID =" + _obj_Pms_RoleKra.PositionID); // break; default: break; } return(ds); }
private void LoadGrid() { try { _obj_Pms_RoleKra = new SPMS_ROLEKRA(); _obj_Pms_RoleKra.ROLE_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["ROLE_ID"])); _obj_Pms_RoleKra.BUID = Convert.ToInt32(Request.QueryString["BU_ID"]); //_obj_Pms_RoleKra.Mode = 6; _obj_Pms_RoleKra.Mode = 12; _obj_Pms_RoleKra.ROLEKRA_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt1 = Pms_Bll.get_RoleKra(_obj_Pms_RoleKra); RG_ViewKRA.DataSource = dt1; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ViewKRA", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/// <summary> /// This method is used to check if KRA, Competence, and Values already exists for the given criteria /// </summary> /// <returns> ///bool /// </returns> public static bool del_KRA(SPMS_ROLEKRA _obj_Pms_RoleKra) { bool status = false; switch (_obj_Pms_RoleKra.OPERATION) { case operation.Delete: status = Pms_Bll.ExecuteNonQuery("EXEC USP_PMS_ROLEKRA @Operation ='" + _obj_Pms_RoleKra.OPERATION //+ "', @ROLEKRA_ORG_ID =" + _obj_Pms_RoleKra.ROLEKRA_ORG_ID //+ ", @PMS_BU_ID = " + _obj_Pms_RoleKra.BUID + "', @ROLEKRA_ID =" + _obj_Pms_RoleKra.ROLEKRA_ID); break; default: break; } return(status); }
/// This method is used to get KRA, Competence, and Values for the given criteria /// </summary> /// <returns> /// DataTable /// </returns> public static DataTable getPositionKRA(SPMS_ROLEKRA _obj_Pms_RoleKra) { DataTable dt = new DataTable(); switch (_obj_Pms_RoleKra.OPERATION) { case operation.Get: dt = Pms_Bll.ExecuteQuery("EXEC USP_PMS_ROLEKRA @OPERATION ='" + _obj_Pms_RoleKra.OPERATION + "', @ROLEKRA_ORG_ID = " + _obj_Pms_RoleKra.ROLEKRA_ORG_ID + ", @PMS_BU_ID =" + _obj_Pms_RoleKra.BUID + ", @POSITION_ID =" + _obj_Pms_RoleKra.PositionID + ", @PMS_Type =" + _obj_Pms_RoleKra.PMS_Type); break; default: break; } return(dt); }
/// <summary> /// This method is used to check if KRA, Competence, and Values already exists for the given criteria /// </summary> /// <returns> ///bool /// </returns> public static bool IsRoleKRAExits(SPMS_ROLEKRA _obj_Pms_RoleKra) { bool status = false; switch (_obj_Pms_RoleKra.OPERATION) { case operation.Check: return(status = Convert.ToBoolean(SqlHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["connection"].ToString(), CommandType.Text, "EXEC USP_PMS_ROLEKRA @Operation ='" + _obj_Pms_RoleKra.OPERATION + "', @ROLEKRA_ORG_ID =" + _obj_Pms_RoleKra.ROLEKRA_ORG_ID + ", @PMS_BU_ID = " + _obj_Pms_RoleKra.BUID + ", @POSITION_ID =" + _obj_Pms_RoleKra.PositionID + ", @ROLE_KRA_ID =" + _obj_Pms_RoleKra.ROLE_KRA_ID + ", @PMS_Type =" + _obj_Pms_RoleKra.PMS_Type))); default: return(status); } }
//<summary> //This Method is used for insertion, deletion and updation of ROLES based upon criteria //</summary> //<returns> //Bool //</returns> public static bool set_RoleKra(SPMS_ROLEKRA _obj_Pms_RoleKra) { bool status = false; switch (_obj_Pms_RoleKra.OPERATION) { case operation.Insert: if (Pms_Bll.ExecuteNonQuery("EXEC USP_PMS_ROLEKRA @Operation ='" + _obj_Pms_RoleKra.OPERATION + "', @ROLEKRA_ORG_ID =" + _obj_Pms_RoleKra.ROLEKRA_ORG_ID + ", @PMS_BU_ID = " + _obj_Pms_RoleKra.BUID + ", @POSITION_ID =" + _obj_Pms_RoleKra.PositionID + ", @ROLE_KRA_ID =" + _obj_Pms_RoleKra.ROLE_KRA_ID + ", @PMS_Type =" + _obj_Pms_RoleKra.PMS_Type + ", @ROLEKRA_CREATED_BY =" + _obj_Pms_RoleKra.CREATEDBY + ", @ROLEKRA_CREATED_DATE ='" + _obj_Pms_RoleKra.CREATEDDATE + "', @ROLEKRA_LASTMDF_BY =" + _obj_Pms_RoleKra.LASTMDFBY + ", @ROLEKRA_LASTMDF_DATE ='" + _obj_Pms_RoleKra.LASTMDFDATE + "'")) { status = true; } else { status = false; } break; default: break; } //switch (_obj_Pms_RoleKra.Mode) //{ // case 3: // if (ExecuteNonQuery("EXEC USP_PMS_ROLEKRA @MODE = 3 , @ROLE_ID = '" + Convert.ToString(_obj_Pms_RoleKra.ROLE_ID) + "'" + // " ,@ROLEKRA_ORG_ID= " + Convert.ToString(_obj_Pms_RoleKra.ROLEKRA_ORG_ID) + ",@ROLE_KRA_ID = " + Convert.ToString(_obj_Pms_RoleKra.ROLE_KRA_ID) + // " , @ROLEKRA_CREATED_BY = " + Convert.ToInt32(_obj_Pms_RoleKra.ROLEKRA_CREATED_BY) + // ", @ROLEKRA_CREATED_DATE = '" + Convert.ToDateTime(_obj_Pms_RoleKra.ROLEKRA_CREATED_DATE).ToString("MM/dd/yyyy") + "'")) // status = true; // else // status = false; // break; // case 4: // if (ExecuteNonQuery("EXEC USP_PMS_ROLEKRA @MODE = 4 , @ROLEKRA_ID = " + Convert.ToString(_obj_Pms_RoleKra.ROLEKRA_ID) // + ", @ROLE_ID = '" + Convert.ToString(_obj_Pms_RoleKra.ROLE_ID) + "'" + // " ,@ROLE_KRA_ID = " + Convert.ToString(_obj_Pms_RoleKra.ROLE_KRA_ID) + // " ,@ROLEKRA_LASTMDF_BY = " + Convert.ToInt32(_obj_Pms_RoleKra.ROLEKRA_LASTMDF_BY) + // ", @ROLEKRA_LASTMDF_DATE = '" + Convert.ToDateTime(_obj_Pms_RoleKra.ROLEKRA_LASTMDF_DATE).ToString("MM/dd/yyyy") + "'")) // status = true; // else // status = false; // break; // case 5: // if (ExecuteNonQuery("EXEC USP_PMS_ROLEKRA @MODE = 5 ,@ROLEKRA_ID= " + Convert.ToString(_obj_Pms_RoleKra.ROLEKRA_ID) // + " ")) // status = true; // else // status = false; // break; // default: // break; //} return(status); }