/// <summary> /// Insert or Update Role-Sub Modules Right /// </summary> /// <param name="submoduleActvity"></param> public static void InsertUpdateRoleSubModuleRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.RoleSubModuleRightActivityCBE submoduleActvity) { string spName = string.Empty; try { if (submoduleActvity.Id == 0) { // Insert rec spName = Constants.oraclePackagePrefix + "ROLESUBMODRIGHT_INSERT"; } else { //update rec spName = Constants.oraclePackagePrefix + "ROLESUBMODRIGHT_UPDATE"; } DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ROLE_ID", DbType.Int32, submoduleActvity.RoleId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ENTRY_ID", DbType.Int32, submoduleActvity.Id, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUBMODULE_ID", DbType.Int32, submoduleActvity.SubModuleId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_ADD", DbType.Int32, submoduleActvity.SubModuleAdd ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_VIEW", DbType.Int32, submoduleActvity.SubModuleView ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_EDIT", DbType.Int32, submoduleActvity.SubModuleEdit ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_DELETE", DbType.Int32, submoduleActvity.SubModuleDelete ? 1 : 0, ParameterDirection.Input, 100)); VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.ExecuteNonQuery(command); } catch (Exception ex) { throw ex; } }
public static void InsertUpdateRoleSubModuleRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.RoleSubModuleRightActivityCBE submodule) { VaaaN.MLFF.Libraries.CommonLibrary.DAL.RoleSubmoduleRightDAL.InsertUpdateRoleSubModuleRight(submodule); }