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